pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTable Statistics with pgAdmin III
5+ messages / 3 participants
[nested] [flat]
* Table Statistics with pgAdmin III
@ 2007-07-24 17:06 Campbell, Lance <lance@uiuc.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Campbell, Lance @ 2007-07-24 17:06 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Table Statistics with pgAdmin III
@ 2007-07-24 17:23 Jean-Max Reymond <jmreymond@gmail.com>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Jean-Max Reymond @ 2007-07-24 17:23 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Table Statistics with pgAdmin III
@ 2007-07-24 17:49 Dave Page <dpage@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: Dave Page @ 2007-07-24 17:49 UTC (permalink / raw)
To: Jean-Max Reymond <jmreymond@gmail.com>; +Cc: pgsql-performance
> ------- 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. What values are at zero?
Regards, Dave
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Table Statistics with pgAdmin III
@ 2007-07-24 18:41 Campbell, Lance <lance@uiuc.edu>
parent: Dave Page <dpage@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: Campbell, Lance @ 2007-07-24 18:41 UTC (permalink / raw)
To: Dave Page <dpage@postgresql.org>; Jean-Max Reymond <jmreymond@gmail.com>; +Cc: pgsql-performance
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. What values are at zero?
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Table Statistics with pgAdmin III
@ 2007-07-25 08:59 Dave Page <dpage@postgresql.org>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Dave Page @ 2007-07-25 08:59 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: Jean-Max Reymond <jmreymond@gmail.com>; pgsql-performance
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-07-25 08:59 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-24 17:06 Table Statistics with pgAdmin III Campbell, Lance <lance@uiuc.edu>
2007-07-24 17:23 ` Jean-Max Reymond <jmreymond@gmail.com>
2007-07-24 17:49 Re: Table Statistics with pgAdmin III Dave Page <dpage@postgresql.org>
2007-07-24 18:41 ` Campbell, Lance <lance@uiuc.edu>
2007-07-25 08:59 ` Dave Page <dpage@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox