| From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
|---|---|
| To: | "Sic Transit Gloria Mundi" <sitrglmu(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x |
| Date: | 2007-02-13 05:07:58 |
| Message-ID: | bf54be870702122107r47588eeci1bc25b3bbe42e5d8@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)yahoo(dot)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<http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396546091>for great
> tips from Yahoo! Answers<http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396546091>users.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Лохтин Константин Сергеевич | 2007-02-13 05:11:27 | |
| Previous Message | Tom Lane | 2007-02-13 03:46:02 | Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x |