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

Re: Statistics tab, "Tables" node

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Statistics tab, "Tables" node
Date: 2008-05-05 12:53:44
Message-ID: 20080505145344.37d79f8b@mha-laptop.hagander.net (view raw or flat)
Thread:
Lists: pgadmin-hackers
Guillaume Lelarge wrote:
> Hi,
> 
> When one clicks on the statistics tab with "Tables" node selected,
> very few statistics are shown :
>   * tuples inserted
>   * tuples updated
>   * tuples deleted
>   * size
> 
> I'm wondering if we could put all pg_stat_all_tables columns here. 
> That's a lot of informations, but at least some informations seem to
> be worth it : n_live_tup, n_dead_tup, last_vacuum, last_autovacuum, 
> last_analyze, last_autoanalyze. I would also like to add some other 
> stuff like the % of the table in cache (if pg_buffercache is
> available).
> 
> Comments, ideas ?

+1 on the stuff from pg_stat (but make sure to check which columns are
available in which version)

-1 on the pg_buffercache stuff. That one can be populated using a
special option I think, but since pg_buffercache takes out some fairly
heavy locking, we shouldn't do that by default.

//Magnus

In response to

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2008-05-05 15:38:50
Subject: Re: Statistics tab, "Tables" node
Previous:From: Guillaume LelargeDate: 2008-05-05 12:44:00
Subject: Statistics tab, "Tables" node

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