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 -----
From: "Bill Chandler" <billybobc1210@yahoo.com>
To: "pgsql-general" <pgsql-general@postgresql.org>
Date: Thu, 21 Apr 2005 08:11:09 -0700 (PDT)
Subject: [GENERAL] Finding cardinality of an index
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.
thanks,
Bill
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings