From: | Gavin Thompson <gavin(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_stat tables empty |
Date: | 2004-06-10 23:31:15 |
Message-ID: | 1086910275.2990.33.camel@xenothanes |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)catalyst(dot)net(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Striebeck | 2004-06-11 01:14:32 | out of memory error |
Previous Message | Tom Lane | 2004-06-10 21:20:56 | Re: Using CIDR and md5 in pg_hba.conf |