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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate