Re: Vaccum and analyze counters in pgstat

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Vaccum and analyze counters in pgstat
Date: 2010-08-21 11:07:07
Message-ID: AANLkTikvG+P70ChCNzMjSeP9ky-Chrj9_OjoBhUKhRCc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 20, 2010 at 15:49, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Magnus Hagander <magnus(at)hagander(dot)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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2010-08-21 14:39:10 Re: Version Numbering
Previous Message Stefan Kaltenbrunner 2010-08-21 08:45:12 Re: Version Numbering