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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Modumudi, Sireesha Hi Everybody, I wanted to know if vacuum is already running in postgres? Thank you, Sireesha |
