Re: How do I tell if a vacuum is currently running?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: How do I tell if a vacuum is currently running?
Дата
Msg-id 20080711210854.GM4110@alvh.no-ip.org
обсуждение исходный текст
Ответ на How do I tell if a vacuum is currently running?  (William Garrison <postgres@mobydisk.com>)
Список pgsql-general
William Garrison wrote:
> If the autovacuum is running, will that show somewhere?  I know there is
> a command to see currently running queries (not in front of me right
> now) but will that show vacuums or any other maintenance operations that
> might be running?

Yes, autovacuum appears in pg_stat_activity.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

В списке pgsql-general по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: recovery do not finish
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Default fill factor for tables?