How do I tell if a vacuum is currently running?
Started by William Garrisonover 17 years ago2 messagesgeneral
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?
Re: How do I tell if a vacuum is currently running?
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