Thread

1. Vaccum and analyze counters in pgstat

   Magnus Hagander <magnus@hagander.net> — 2010-08-20T12:45:56Z

   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?
   
   -- 
    Magnus Hagander
    Me: http://www.hagander.net/
    Work: http://www.redpill-linpro.com/
   

2. Re: Vaccum and analyze counters in pgstat

   Tom Lane <tgl@sss.pgh.pa.us> — 2010-08-20T13:49:50Z

   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.
   
   > --- 117,125 ----
   >      is a subsystem that supports collection and reporting of information about
   >      server activity.  Presently, the collector can count accesses to tables
   >      and indexes in both disk-block and individual-row terms.  It also tracks
   > !    the total number of rows in each table, and information about vacuum and
   > !    analyze for each table.  It can also count calls to user-defined functions
   > !    and the total time spent in each one.
   >     </para>
   
   "information about vacuum and analyze actions" might read better.
   
   > --- 318,325 ----
   >         <entry>Similar to <structname>pg_stat_all_tables</>, but counts actions
   >         taken so far within the current transaction (which are <emphasis>not</>
   >         yet included in <structname>pg_stat_all_tables</> and related views).
   > !       The columns for numbers of live and dead rows and vacuum and
   > !       analyze values are not present in this view.</entry>
   >        </row>
   
   Likewise values -> actions here.
   
   			regards, tom lane
   
   

3. Re: Vaccum and analyze counters in pgstat

   Magnus Hagander <magnus@hagander.net> — 2010-08-21T11:07:07Z

   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/