Thread: How do i know if a vacuum is running?

How do i know if a vacuum is running?

From
"Modumudi, Sireesha"
Date:

Hi Everybody,

 

I wanted to know if vacuum is already running in postgres?

 

Thank you,

Sireesha

Re: How do i know if a vacuum is running?

From
"David Johnston"
Date:

Run a query against the “pg_stat_activity” system view (you will need to be a super-user to view system queries, normal users can only view their own).

 

To get you started this is the query that I use to spot-check system query activity:

 

SELECT procpid, current_query, client_addr, xact_start, query_start

                FROM pg_stat_activity

                ORDER BY xact_start ASC;

 

HTH,

 

David J.

 

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Modumudi, Sireesha
Sent: Monday, October 08, 2012 7:22 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How do i know if a vacuum is running?

 

Hi Everybody,

 

I wanted to know if vacuum is already running in postgres?

 

Thank you,

Sireesha