Re: Vaccum and analyze counters in pgstat - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Vaccum and analyze counters in pgstat
Date
Msg-id AANLkTikvG+P70ChCNzMjSeP9ky-Chrj9_OjoBhUKhRCc@mail.gmail.com
Whole thread Raw
In response to Re: Vaccum and analyze counters in pgstat  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Aug 20, 2010 at 15:49, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Magnus Hagander <magnus@hagander.net> 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 included
>> the counts of regular vacuum and analyze as well for completeness.
>
>> Comments?
>
> Looks reasonably sane in a quick read-through.

Applied with suggested documentation changes.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Version Numbering
Next
From: "David E. Wheeler"
Date:
Subject: Re: Version Numbering