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 ------------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
