Thread: Table Statistics with pgAdmin III

Table Statistics with pgAdmin III

From
"Campbell, Lance"
Date:

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.

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

 

Re: Table Statistics with pgAdmin III

From
Jean-Max Reymond
Date:
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

Re: Table Statistics with pgAdmin III

From
"Dave Page"
Date:

> ------- Original Message -------
> From: Jean-Max Reymond <jmreymond@gmail.com>
> To: pgsql-performance@postgresql.org
> Sent: 24/07/07, 18:23:53
> Subject: Re: [PERFORM] Table Statistics with pgAdmin III
>
> 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

That'll allow you to see extra stats in 1.8, but won't alter what you already see, in fact 1.6 won't use it at all.
Whatvalues are at zero? 

Regards, Dave

Re: Table Statistics with pgAdmin III

From
"Campbell, Lance"
Date:
All of the fields are zero except for the three I listed in my posting.

Thanks,

Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu

-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Dave Page
Sent: Tuesday, July 24, 2007 12:50 PM
To: Jean-Max Reymond
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Table Statistics with pgAdmin III



> ------- Original Message -------
> From: Jean-Max Reymond <jmreymond@gmail.com>
> To: pgsql-performance@postgresql.org
> Sent: 24/07/07, 18:23:53
> Subject: Re: [PERFORM] Table Statistics with pgAdmin III
>
> 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

That'll allow you to see extra stats in 1.8, but won't alter what you already see, in fact 1.6 won't use it at all.
Whatvalues are at zero? 

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Table Statistics with pgAdmin III

From
Dave Page
Date:
Campbell, Lance wrote:
> All of the fields are zero except for the three I listed in my posting.

Do you have the stats collector enabled, and row & block level stats
turned on?

Regards, Dave.