Re: [PERFORM] autovacuum on a -mostly- r/o table

Jim C. Nasby wrote:
> On Sun, Oct 15, 2006 at 04:52:12PM +0200, Tobias Brox wrote:
>> Are there any logs that can help me, and eventually, are there any
>> ready-made scripts for checking when autovacuum is running, and
>> eventually for how long it keeps its transactions?  I'll probably
>> write up something myself if not.
>
> 8.2 adds some stats on when autovac last ran, per-table. I don't
> remember if it reports how long it took to vacuum the table, but that
> would probably be useful info.

It does NOT.  It's just the timestamp of the END of the vacuum / analyze.

(I'm the author of the patch).


--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683             E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893