Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x

["Shoaib Mir" <shoaibmir@xxxxxxxxx>]

pg_stat_all_table view should help you:

select last_autovacuum, last_autoanalyze from pg_stat_all_tables;

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/9/07, Sic Transit Gloria Mundi < sitrglmu@xxxxxxxxx> wrote:

Hi,

I couldnt find this on google, the archives, or the manual.  But with the changes to what the autovacuum daemon logs, how can we verify it's doing its thing?  Is there a way to query the last time a table was vacuumed?  But I don't see that in the system catalog.

Thanks!

---

Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.