On Wed, Apr 8, 2009 at 12:05 PM, Jennifer Trey <jennifer.trey@xxxxxxxxx> wrote:
From pgAdmin, you could:
select * from pg_stat_all_indexes;
You will see this system view in pgAdmin by:
database +
Catalogs +
PostgreSQL (pg_catalog) +
Views +
You should be able to see the structure there.
--Scott
max_connections = 150 # A comprimise :)
Scott, you mentioned :From where can I see these stats ? Is there any graphic tool?
You can also use the pg_stat_all_indexes table to look at index scans
vs. tuples being read, this can sometimes hint at index 'bloat'. I
would also recommend pg_stattuple which has a pg_statindex function
for looking at index fragmentation.
From pgAdmin, you could:
select * from pg_stat_all_indexes;
You will see this system view in pgAdmin by:
database +
Catalogs +
PostgreSQL (pg_catalog) +
Views +
You should be able to see the structure there.
--Scott
