pg_stat tables empty

[Gavin Thompson]

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: [phone] MOB: [phone] OFFICE: [phone]
-------------------------------------------------------------------------


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

Post by Gavin Thompson
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Gavin Thompson]

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

Post by Tom Lane

Post by Gavin Thompson
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org