Thread: pg_stat_user_indexes and pg_stat_user_tables description?

pg_stat_user_indexes and pg_stat_user_tables description?

From
AI Rumman
Date:
Could anyone please tell me where may I get the details of the following views:
pg_stat_user_indexes
pg_stat_user_tables
 
I want to know the meaning of every column like idx_tup_read and idx_tup_fetch.

Re: pg_stat_user_indexes and pg_stat_user_tables description?

From
Ben Chobot
Date:
On Feb 8, 2010, at 9:02 PM, AI Rumman wrote:

> Could anyone please tell me where may I get the details of the following views:
> pg_stat_user_indexes
> pg_stat_user_tables
>
> I want to know the meaning of every column like idx_tup_read and idx_tup_fetch.

The fine user manual is helpful for questions like this:

http://www.postgresql.org/docs/8.4/interactive/monitoring-stats.html