Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6A6B5634B0A for ; Wed, 31 Mar 2010 11:29:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56395-01-4 for ; Wed, 31 Mar 2010 14:29:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id D05E3633AF8 for ; Wed, 31 Mar 2010 11:28:34 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o2VESVkY020626; Wed, 31 Mar 2010 10:28:31 -0400 (EDT) To: gnanam@zoniac.com cc: "'Guillaume Lelarge'" , pgsql-admin@postgresql.org Subject: Re: Statistics Collector not collecting server activities In-reply-to: <00fd01cad0d5$46eed870$d4cc8950$@com> References: <007501cad09d$326fefc0$974fcf40$@com> <4BB2FA68.6060708@lelarge.info> <00b601cad0b0$5e713760$1b53a620$@com> <4BB31032.6060809@lelarge.info> <00c001cad0b2$a4a89c30$edf9d490$@com> <4BB3153F.6010901@lelarge.info> <00da01cad0c0$169f3030$43dd9090$@com> <4BB33F87.3070901@lelarge.info> <00fd01cad0d5$46eed870$d4cc8950$@com> Comments: In-reply-to "Gnanakumar" message dated "Wed, 31 Mar 2010 18:52:53 +0530" Date: Wed, 31 Mar 2010 10:28:31 -0400 Message-ID: <20625.1270045711@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/289 X-Sequence-Number: 34088 "Gnanakumar" writes: >> But still, if I query after performing heavy DML operations, I'm always >> getting zero, even though there are INSERT/UPDATE/DELETE. Is the stats collector actually running according to "ps"? If not, look in the postmaster log to see why it failed (problems creating the communication socket are the most common cause). regards, tom lane