From: | "David Johnston" <polobo(at)yahoo(dot)com> |
---|---|
To: | "'Modumudi, Sireesha'" <Sireesha(dot)Modumudi(at)emc(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How do i know if a vacuum is running? |
Date: | 2012-10-08 23:58:46 |
Message-ID: | 001b01cda5b0$dbc0b880$93422980$@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Modumudi, Sireesha
Sent: Monday, October 08, 2012 7:22 PM
To: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-10-09 02:04:07 | Re: Dump/restore indexes and functions in public schema |
Previous Message | Modumudi, Sireesha | 2012-10-08 23:22:25 | How do i know if a vacuum is running? |