Friday, July 11, 2008

Re: [GENERAL] 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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: