pg_stat tables empty

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
-------------------------------------------------------------------------

Responses

Browse pgsql-admin by date

  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