Thread: PG Stats Collector
Hello and greetings,
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
Reported In pg_stat_user_tables
-------------------------------------
idx_tup_fetch,
n_tup_hot_upd,
n_live_tup,
n_dead_tup
thank you,
arvind
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
Reported In pg_stat_user_tables
-------------------------------------
idx_tup_fetch,
n_tup_hot_upd,
n_live_tup,
n_dead_tup
thank you,
arvind
For such things documentation is your best friend. Please see inline.
Michael
On Sun, May 12, 2013 at 4:30 PM, Arvind Singh <arvindps@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:
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
http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW
Thanks,
Michael
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.paquier@gmail.com
To: arvindps@hotmail.com
CC: pgsql-general@postgresql.org
regards and greetings from india
Date: Sun, 12 May 2013 20:33:14 +0900
Subject: Re: [GENERAL] PG Stats Collector
From: michael.paquier@gmail.com
To: arvindps@hotmail.com
CC: pgsql-general@postgresql.org
For such things documentation is your best friend. Please see inline.
Michael
On Sun, May 12, 2013 at 4:30 PM, Arvind Singh <arvindps@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:
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
http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW
Thanks,
Michael