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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2008-05-05 15:38:50 | Re: Statistics tab, "Tables" node |
Previous Message | Guillaume Lelarge | 2008-05-05 12:44:00 | Statistics tab, "Tables" node |