From: | "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Pg_statio_user_tables view does not get populated |
Date: | 2008-01-15 17:34:06 |
Message-ID: | C84662912D280D4AB5C50100A100F0C5030CD9B9@ct11exm61.ds.mot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)marlowe(at)gmail(dot)com]
Sent: Tuesday, January 15, 2008 7:20 AM
To: Bhella Paramjeet-PFCW67
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Pg_statio_user_tables view does not get populated
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2008-01-15 17:35:32 | Re: WAL copying includes vacuum, reindex, etc? |
Previous Message | David Wall | 2008-01-15 17:19:42 | WAL copying includes vacuum, reindex, etc? |