oh thanks a lot, we desperately needed to work on the stats collector and since we were using windows platform, there is not even a decent application that reports such information regards and greetings from india
Date: Sun, 12 May 2013 20:33:14 +0900 Subject: Re: [GENERAL] PG Stats Collector From: michael.paqu...@gmail.com To: arvin...@hotmail.com CC: pgsql-general@postgresql.org 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
