Re: idle in transaction

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: idle in transaction
Date: 2023-11-28 04:07:36
Message-ID: CAKFQuwZeRA0wg+yxW=6111Fnirq-gHS64bPuZMsSfh6jDa5RSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Monday, November 27, 2023, Nikhil Ingale <niks(dot)bgm(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-11-28 06:53:02 Re: idle in transaction
Previous Message Nikhil Ingale 2023-11-28 04:00:20 idle in transaction