Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B02609FA473 for ; Mon, 11 Jun 2007 05:50:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 34131-10 for ; Mon, 11 Jun 2007 05:50:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.230]) by postgresql.org (Postfix) with ESMTP id 0BCEF9FA2FD for ; Mon, 11 Jun 2007 05:50:28 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id s16so1298448wxc for ; Mon, 11 Jun 2007 01:50:27 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=obQ9Kmn71w7fuTqYE9vGo1dfi1+HDyQMQUPbRR6GdumjjIo7ttbaw/ocY218thpvK51Og2L9afqcznaDf8m/sxX1J4ijrnxtZTxSHZm8itvU7R1YRVABmiyKPxOL8XtmapIp8CF7fkiKaAPY/3tX90gieJDCUaUB4BkVp/lJllc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=TnUK+2+S8TzkPLooLq5RmH7vF2FyP5PfgFEtdUUVKe3xxVU8KSOhXEbXefzFwrxySz+On2hRWvKP8RzyI6J7I0F3ayqU7NiucvjZivEaS2PMFD902osSLAe9JTvVc915wiYCd0hOe3uW2qJG/HuaXXW4EP0psq7p1fsp3KXmRd8= Received: by 10.70.116.14 with SMTP id o14mr8180600wxc.1181551827816; Mon, 11 Jun 2007 01:50:27 -0700 (PDT) Received: by 10.70.118.16 with HTTP; Mon, 11 Jun 2007 01:50:27 -0700 (PDT) Message-ID: <965aa3ed0706110150g6f5e85bevfb4be0b50b649271@mail.gmail.com> Date: Mon, 11 Jun 2007 14:20:27 +0530 From: "Nimesh Satam" To: pgsql-performance@postgresql.org, database@zedo.com Subject: pg_statistic doesnt contain details for specific table MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_72521_23897737.1181551827784" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/175 X-Sequence-Number: 25208 ------=_Part_72521_23897737.1181551827784 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, While monitioring we noticed that there are no details in the pg_statistics for a particular table. Can you let us know what might be the reason? Also what steps can be taken care for adding the statistics? Note: The queries which are running on this table are taken longer time then al the other queries. Thanks, Nimesh. ------=_Part_72521_23897737.1181551827784 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi,
 
 
While monitioring we noticed that there are no details in the pg_statistics for a particular table. Can you let us know what might be the reason? Also what steps can be taken care for adding the statistics?
 
Note: The queries which are running on this table are taken longer time then al the other queries.
 
 
Thanks,
Nimesh.
------=_Part_72521_23897737.1181551827784--