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