X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3B237D1B187 for ; Thu, 10 Jun 2004 20:31:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91920-10 for ; Thu, 10 Jun 2004 23:31:24 +0000 (GMT) Received: from mail2.catalyst.net.nz (godel.catalyst.net.nz [202.49.159.12]) by svr1.postgresql.org (Postfix) with ESMTP id 580EAD1B17C for ; Thu, 10 Jun 2004 20:31:19 -0300 (ADT) Received: from leibniz.catalyst.net.nz ([202.49.159.7] helo=dhcp138.wgtn.cat-it.co.nz) by mail2.catalyst.net.nz with esmtp (Cipher TLSv1:RC4-MD5:128) (Exim 3.35 #1 (Debian)) id 1BYZ0s-00052s-02; Fri, 11 Jun 2004 11:31:14 +1200 Subject: Re: pg_stat tables empty From: Gavin Thompson To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <2819.1086893233@sss.pgh.pa.us> References: <1086854327.5633.164.camel@xenothanes> <2819.1086893233@sss.pgh.pa.us> Content-Type: text/plain Message-Id: <1086910275.2990.33.camel@xenothanes> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Fri, 11 Jun 2004 11:31:15 +1200 Content-Transfer-Encoding: 7bit X-System-Filter-Id: mail2.catalyst.net.nz 1BYZ0s-00052s-02 X-Virus-Scanned-By: Amavis with CLAM Anti Virus on mail2.catalyst.net.nz X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/160 X-Sequence-Number: 13820 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 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