Re: [HACKERS] Vaccum and analyze counters in pgstat

2010-08-21 Thread Magnus Hagander
On Fri, Aug 20, 2010 at 15:49, Tom Lane wrote: > Magnus Hagander writes: >> Attached is a patch that adds columns to pg_stat_*_tables for number >> of [auto]vacuum and [auto]analyze runs on a table, completing the >> current one that just had the last time these ran. It's particularly >> useful t

Re: [HACKERS] Vaccum and analyze counters in pgstat

2010-08-20 Thread Tom Lane
Magnus Hagander writes: > Attached is a patch that adds columns to pg_stat_*_tables for number > of [auto]vacuum and [auto]analyze runs on a table, completing the > current one that just had the last time these ran. It's particularly > useful to see how much autovac is doing on the tables, but I i

[HACKERS] Vaccum and analyze counters in pgstat

2010-08-20 Thread Magnus Hagander
Attached is a patch that adds columns to pg_stat_*_tables for number of [auto]vacuum and [auto]analyze runs on a table, completing the current one that just had the last time these ran. It's particularly useful to see how much autovac is doing on the tables, but I included the counts of regular vac