For such things documentation is your best friend. Please see inline. On Sun, May 12, 2013 at 4:30 PM, Arvind Singh <arvin...@hotmail.com> wrote:
> I need help in understanding the purpose of the following columns produced > by PG stats collector in version 9.1 > > From pg_stat_database > ----------------------------- > blks_read, > blks_hit, > _tup_returned, > tup_fetched > Meaning of columns of pg_stat_database: http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-DATABASE-VIEW > > Reported In pg_stat_user_tables > ------------------------------------- > idx_tup_fetch, > n_tup_hot_upd, > n_live_tup, > n_dead_tup > pg_stat_user_tables is similar to pg_stat_all_tables, except that it contains only user tables: http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW Thanks, -- Michael
