Postgres Pro
Downloads
Home   >   mailing lists

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

From Shoaib Mir
Subject Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x
Date
Msg-id bf54be870702122107r47588eeci1bc25b3bbe42e5d8@mail.gmail.com
Whole thread Raw
In response to Dumb question - how to tell if autovacuum is doing its job in 8.2.x  (Sic Transit Gloria Mundi <sitrglmu@yahoo.com>)
Responses Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x  (Walter Vaughan <wvaughan@steelerubber.com>)
List pgsql-general
Tree view
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@yahoo.com> 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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x
Next
From: Лохтин Константин Сергеевич
Date:
Subject: