Postgres Pro
Downloads
Home   >   mailing lists

Re: PG Stats Collector - Mailing list pgsql-general

From Michael Paquier
Subject Re: PG Stats Collector
Date
Msg-id CAB7nPqTu_yEG4=tuB8pX6fEXEn-KXY4xXoeP=bOn-mgsdfb-jg@mail.gmail.com
Whole thread Raw
In response to PG Stats Collector  (Arvind Singh <arvindps@hotmail.com>)
Responses Re: PG Stats Collector  (Arvind Singh <arvindps@hotmail.com>)
List pgsql-general
Tree view
For such things documentation is your best friend. Please see inline.

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

Thanks,
--
Michael

pgsql-general by date:

Previous
From: Arvind Singh
Date:
Subject: PG Stats Collector
Next
From: Moshe Jacobson
Date:
Subject: Re: How to clone a running master cluster?