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: [email protected]
[mailto:[email protected]] On Behalf Of Modumudi, Sireesha
Sent: Monday, October 08, 2012 7:22 PM
To: [email protected]
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
