I know two ways:
1) Use DbVisualizer, very handy, but a bit slow. For a give table go to
the indexes tab and it's show you the cardinality
2) Use this sql
SELECT relname, relkind, reltuples as cardinality, relpages
FROM pg_class
WHERE relname LIKE 'mytablename%';
David
- Original message
http://www.postgresql.org/docs/8.0/static/catalog-pg-class.html
On Thu, Apr 21, 2005 at 08:11:09AM -0700, Bill Chandler wrote:
> All,
>
> Is there a way to determine cardinality (size) of an
> index? In general how to you query the 'attributes'
> (for lack of a better word) of an index.
>
> tha
