Re: [ADMIN] Pg_statio_user_tables view does not get populated

From: Bhella Paramjeet-PFCW67 <PBhella(at)Motorola.com>
Date: Tue Jan 15 2008 - 12:34:06 EST

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?

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq Received on Tue Jan 15 12:36:32 2008