Skip site navigation (1) Skip section navigation (2)

Re: Table Statistics with pgAdmin III

From: Jean-Max Reymond <jmreymond(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Table Statistics with pgAdmin III
Date: 2007-07-24 17:23:53
Message-ID: f85ciu$k3j$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Dave PageDate: 2007-07-24 17:49:47
Subject: Re: Table Statistics with pgAdmin III
Previous:From: Campbell, LanceDate: 2007-07-24 17:06:13
Subject: Table Statistics with pgAdmin III

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group