Postgres Pro
Downloads
Home   >   mailing lists

Re: current_query='IDLE" in pg_stat_activity - Mailing list pgsql-general

From Chris Withers
Subject Re: current_query='IDLE" in pg_stat_activity
Date
Msg-id 5652ED7C.3080803@simplistix.co.uk
Whole thread Raw
In response to current_query='IDLE" in pg_stat_activity  (paramjib baruah <paramjibbaruah@gmail.com>)
Responses Re: current_query='IDLE" in pg_stat_activity  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view 
On 23/11/2015 10:33, paramjib baruah wrote:
> I am trying to check current running sql queries in postgres through
> pg_stat_activity .However, in the current_query column I could see
> only "IDLE" . I am not able to see the query .
That would suggest no query is running, what suggests to you that there
are queries you should be expecting to see?

cheers,

Chris

pgsql-general by date:

Previous
From: Chris Withers
Date:
Subject: using a postgres table as a multi-writer multi-updater queue
Next
From: Benedikt Grundmann
Date:
Subject: Problems with pg_upgrade after change of unix user running db.