Re: current_query='IDLE" in pg_stat_activity

From: Chris Withers <chris(at)simplistix(dot)co(dot)uk>
To: paramjib baruah <paramjibbaruah(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: current_query='IDLE" in pg_stat_activity
Date: 2015-11-23 10:42:04
Message-ID: 5652ED7C.3080803@simplistix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benedikt Grundmann 2015-11-23 11:12:25 Problems with pg_upgrade after change of unix user running db.
Previous Message Chris Withers 2015-11-23 10:41:06 using a postgres table as a multi-writer multi-updater queue