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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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