| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Arvind Singh <arvindps(at)hotmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PG Stats Collector |
| Date: | 2013-05-12 11:33:14 |
| Message-ID: | CAB7nPqTu_yEG4=tuB8pX6fEXEn-KXY4xXoeP=bOn-mgsdfb-jg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
For such things documentation is your best friend. Please see inline.
On Sun, May 12, 2013 at 4:30 PM, Arvind Singh <arvindps(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Moshe Jacobson | 2013-05-12 12:54:50 | Re: How to clone a running master cluster? |
| Previous Message | Arvind Singh | 2013-05-12 07:30:43 | PG Stats Collector |