Postgres Pro
Downloads
Home   >   mailing lists

Re: idle in transaction - Mailing list pgsql-admin

From David G. Johnston
Subject Re: idle in transaction
Date
Msg-id CAKFQuwZeRA0wg+yxW=6111Fnirq-gHS64bPuZMsSfh6jDa5RSQ@mail.gmail.com
Whole thread Raw
In response to idle in transaction  (Nikhil Ingale <niks.bgm@gmail.com>)
Responses Re: idle in transaction
List pgsql-admin
Tree view
On Monday, November 27, 2023, Nikhil Ingale <niks.bgm@gmail.com> wrote:
How do I find out what query is it running?

SAVEPOINT _per_query_svp_;DEALLOCATE "_PLAN0x7fdd58004550";RELEASE _per_query_svp_

That is the last command (multi-statement though it is) that was executed before the transaction/session went idle.

David J.

pgsql-admin by date:

Previous
From: Nikhil Ingale
Date:
Subject: idle in transaction
Next
From: Laurenz Albe
Date:
Subject: Re: idle in transaction