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@xxxxxxxxxx US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
