Skip site navigation (1) Skip section navigation (2)

Re: Pg_statio_user_tables view does not get populated

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 (view raw or flat)
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

In response to

Responses

pgsql-admin by date

Next:From: imadDate: 2008-01-15 20:31:27
Subject: Installation problem in win32
Previous:From: Tom LaneDate: 2008-01-15 18:07:32
Subject: Re: WAL copying includes vacuum, reindex, etc?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group