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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 03:46:02
Message-ID: 22057.1171338362@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sic Transit Gloria Mundi <sitrglmu(at)yahoo(dot)com> writes:
> 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.

Try the pg_stat views.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2007-02-13 05:07:58 Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x
Previous Message Mike Harding 2007-02-13 03:38:29 Timestamp/Timezone - does this make sense?