| From: | "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Pg_statio_user_tables view does not get populated |
| Date: | 2008-01-15 18:12:31 |
| Message-ID: | C84662912D280D4AB5C50100A100F0C5030CD9EB@ct11exm61.ds.mot.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
There is data in pg_stat_activity and pg_stat_database view. There is
also data in the pg_stat views related to system but not in pg_stat
views related to user .
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, January 15, 2008 10:04 AM
To: Bhella Paramjeet-PFCW67
Cc: Scott Marlowe; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Pg_statio_user_tables view does not get populated
"Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com> writes:
> Yes I did restart the database after making these changes but still
> there is no data in pg_statio_user_tables view.
Is data appearing in *any* of the pg_stat views?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | imad | 2008-01-15 20:31:27 | Installation problem in win32 |
| Previous Message | Tom Lane | 2008-01-15 18:07:32 | Re: WAL copying includes vacuum, reindex, etc? |