Обсуждение: How do I tell if a vacuum is currently running?

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?

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