From: Dave Page <dpage@postgresql.org>
To: Jean-Max Reymond <jmreymond@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Table Statistics with pgAdmin III
Date: Tue, 24 Jul 2007 18:49:47 +0100
Message-ID: <200707241849470000@1125126500> (raw)
> ------- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dpage@postgresql.org, jmreymond@gmail.com
Subject: Re: Table Statistics with pgAdmin III
In-Reply-To: <200707241849470000@1125126500>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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