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@xxxxxxxxx] Sent: Tuesday, January 15, 2008 7:20 AM To: Bhella Paramjeet-PFCW67 Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Pg_statio_user_tables view does not get populated On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 <PBhella@xxxxxxxxxxxx> 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? ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
