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

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x
Дата
Msg-id bf54be870702122107r47588eeci1bc25b3bbe42e5d8@mail.gmail.com
обсуждение исходный текст
Ответ на Dumb question - how to tell if autovacuum is doing its job in 8.2.x  (Sic Transit Gloria Mundi <sitrglmu@yahoo.com>)
Ответы Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x  (Walter Vaughan <wvaughan@steelerubber.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x
Следующее
От: Лохтин Константин Сергеевич
Дата:
Сообщение: