Postgres Pro
Downloads
Home   >   mailing lists

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

From paramjib baruah
Subject current_query='IDLE" in pg_stat_activity
Date
Msg-id CADoaqLn825d16HTbEdrHqbMKxQjntgjudsS8FZG=1vzccWn_GA@mail.gmail.com
Whole thread Raw
Responses Re: current_query='IDLE" in pg_stat_activity  (Chris Withers <chris@simplistix.co.uk>)
List pgsql-general
Tree view
Hi ,

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 .

Thanks
Paramjib Baruah

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: What could cause CREATE TEMP... "could not read block" error?
Next
From: Chris Withers
Date:
Subject: using a postgres table as a multi-writer multi-updater queue