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

Re: Pg_statio_user_tables view does not get populated

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Bhella Paramjeet-PFCW67" <PBhella(at)motorola(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Pg_statio_user_tables view does not get populated
Date: 2008-01-15 15:19:46
Message-ID: dcc563d10801150719s36b73468g91a3b2912d8d96fd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 <PBhella(at)motorola(dot)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?

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-01-15 15:21:52
Subject: Re: update performance 8.1.4
Previous:From: Sebastian ReitenbachDate: 2008-01-15 09:44:28
Subject: backup WAL files,

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