From: | Gavin Thompson <gavin(at)catalyst(dot)net(dot)nz> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_stat tables empty |
Date: | 2004-06-10 07:58:47 |
Message-ID: | 1086854327.5633.164.camel@xenothanes |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
My statistics collector is not collecting any statistics and functions
such as pg_stat_get_tuples_fetched() return 0.
I have set run-time parameters thusly:
stats_command_string | on
stats_reset_on_server_start | on
stats_row_level | on
stats_start_collector | on
stats processes are running:
postgres ... postgres: stats buffer process
postgres ... postgres: stats collector process
I can't find any suspicious looking messages in syslog or postgres logs.
Any clues where to look next?
--
-------------------------------------------------------------------------
Gavin @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64 803-2206 MOB: +64(27)4707-815 OFFICE: +64(4)499-2267
-------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | lise chhay | 2004-06-10 08:55:35 | "select * from groupes" didn't display any data |
Previous Message | Bruce Momjian | 2004-06-10 04:26:01 | Re: Dump only part of a DB |