Обсуждение: Pg_statio_user_tables view does not get populated
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
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?
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?
"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
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
"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