Обсуждение: 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