Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I tell if a vacuum is currently running? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: How do I tell if a vacuum is currently running?
Date
Msg-id 20080711210854.GM4110@alvh.no-ip.org
Whole thread Raw
In response to How do I tell if a vacuum is currently running?  (William Garrison <postgres@mobydisk.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: recovery do not finish
Next
From: "Scott Marlowe"
Date:
Subject: Re: Default fill factor for tables?