Postgres Pro
Downloads
Home   >   mailing lists

Thread: Pg_statio_user_tables view does not get populated

Pg_statio_user_tables view does not get populated

From
"Bhella Paramjeet-PFCW67"
Date:
I have installed postgres 8.2.4 in my development environment. I have
the stats_command_string, stats_start_collector, stats_block_level,
stats_row_level options turned on in postgresql.conf file but still the
pg_statio_user_tables view does not get populated. Is there any other
option I need to enable? Please advice.

Thanks
Paramjeet Bhella

Re: Pg_statio_user_tables view does not get populated

From
"Scott Marlowe"
Date:
On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 <PBhella@motorola.com> wrote:
> I have installed postgres 8.2.4 in my development environment. I have
> the stats_command_string, stats_start_collector, stats_block_level,
> stats_row_level options turned on in postgresql.conf file but still the
> pg_statio_user_tables view does not get populated. Is there any other
> option I need to enable? Please advice.

Have you restarted postgresql since making those changes?

Re: Pg_statio_user_tables view does not get populated

From
"Bhella Paramjeet-PFCW67"
Date:
Yes I did restart the database after making these changes but still
there is no data in  pg_statio_user_tables view.

-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Tuesday, January 15, 2008 7:20 AM
To: Bhella Paramjeet-PFCW67
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Pg_statio_user_tables view does not get populated

On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 <PBhella@motorola.com>
wrote:
> I have installed postgres 8.2.4 in my development environment. I have
> the stats_command_string, stats_start_collector, stats_block_level,
> stats_row_level options turned on in postgresql.conf file but still
> the pg_statio_user_tables view does not get populated. Is there any
> other option I need to enable? Please advice.

Have you restarted postgresql since making those changes?

Re: Pg_statio_user_tables view does not get populated

From
Tom Lane
Date:
"Bhella Paramjeet-PFCW67" <PBhella@Motorola.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

Re: Pg_statio_user_tables view does not get populated

From
"Bhella Paramjeet-PFCW67"
Date:
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@sss.pgh.pa.us]
Sent: Tuesday, January 15, 2008 10:04 AM
To: Bhella Paramjeet-PFCW67
Cc: Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Pg_statio_user_tables view does not get populated

"Bhella Paramjeet-PFCW67" <PBhella@Motorola.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

Re: Pg_statio_user_tables view does not get populated

From
Tom Lane
Date:
"Bhella Paramjeet-PFCW67" <PBhella@Motorola.com> writes:
> 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 .

[ squint.. ]  That's pretty hard to believe --- those views use the same
underlying view, which doesn't even know the difference between system
and user tables.

            regards, tom lane