pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_stat tables empty
3+ messages / 2 participants
[nested] [flat]
* pg_stat tables empty
@ 2004-06-10 07:58 Gavin Thompson <gavin@catalyst.net.nz>
0 siblings, 1 reply; 3+ messages in thread
From: Gavin Thompson @ 2004-06-10 07:58 UTC (permalink / raw)
To: 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
-------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_stat tables empty
@ 2004-06-10 18:47 Tom Lane <tgl@sss.pgh.pa.us>
parent: Gavin Thompson <gavin@catalyst.net.nz>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2004-06-10 18:47 UTC (permalink / raw)
To: Gavin Thompson <gavin@catalyst.net.nz>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_stat tables empty
@ 2004-06-10 23:31 Gavin Thompson <gavin@catalyst.net.nz>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Gavin Thompson @ 2004-06-10 23:31 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-06-10 23:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-10 07:58 pg_stat tables empty Gavin Thompson <gavin@catalyst.net.nz>
2004-06-10 18:47 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-10 23:31 ` Gavin Thompson <gavin@catalyst.net.nz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox