Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 143B89FBABD for ; Tue, 24 Jul 2007 14:24:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 19506-09-2 for ; Tue, 24 Jul 2007 14:23:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 4A79C9FBA82 for ; Tue, 24 Jul 2007 14:23:56 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 342DB3141D; Tue, 24 Jul 2007 19:23:54 +0200 (MET DST) From: Jean-Max Reymond X-Newsgroups: pgsql.performance Subject: Re: Table Statistics with pgAdmin III Date: Tue, 24 Jul 2007 19:23:53 +0200 Organization: Hub.Org Networking Services Lines: 14 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5.0.12 (X11/20070604) In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200707/318 X-Sequence-Number: 26002 Campbell, Lance a écrit : > I have installed pgAdmin III 1.6. In the tool when you click on a > particular table you can select a tab called “Statistics”. This tab has > all kinds of info on your table. For some reason the only info I see is > for table size, toast table size and indexes size. Is there a reason > that the other 15 fields have zeros in them? I was thinking that maybe > I needed to turn on a setting within my database in order to get > statistics reported. it seems that the module pgstattuple is needed -- Jean-Max Reymond CKR Solutions http://www.ckr-solutions.com