Thread: pg_stat tables empty
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 -------------------------------------------------------------------------
Gavin Thompson <gavin@catalyst.net.nz> writes:
> My statistics collector is not collecting any statistics and functions
> such as pg_stat_get_tuples_fetched() return 0.
I'd wonder about kernel packet filtering preventing the data from
getting through to the collector. Our CVS tip has a startup-time check
to warn of this situation, but it's not in any released version...
regards, tom lane
Sorry Tom, my description was a bit misleading, some stats tables are being updated, some aren't. e.g. pg_stat_all_tables is being updated, whereas pg_statio_all_tables has rows for each table but the columns are not being updated. Cheers, Gavin On Fri, 2004-06-11 at 06:47, Tom Lane wrote: > Gavin Thompson <gavin@catalyst.net.nz> writes: > > My statistics collector is not collecting any statistics and functions > > such as pg_stat_get_tuples_fetched() return 0. > > I'd wonder about kernel packet filtering preventing the data from > getting through to the collector. Our CVS tip has a startup-time check > to warn of this situation, but it's not in any released version... > > regards, tom lane