pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_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