pg_stat_user_indexes and pg_stat_user_tables description?

Started by AI Rummanabout 16 years ago2 messagesgeneral
Jump to latest
#1AI Rumman
rummandba@gmail.com

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.

#2Ben
bench@silentmedia.com
In reply to: AI Rumman (#1)
Re: pg_stat_user_indexes and pg_stat_user_tables description?

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