pg_stat tables empty - Mailing list pgsql-admin

From Gavin Thompson
Subject pg_stat tables empty
Date
Msg-id 1086854327.5633.164.camel@xenothanes
Whole thread Raw
Responses Re: pg_stat tables empty  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
-------------------------------------------------------------------------


pgsql-admin by date:

Previous
From: Dave Cramer
Date:
Subject: Re: [JDBC] Trouble with locking tables - reg.
Next
From: Naomi Walker
Date:
Subject: Re: "select * from groupes" didn't display any data