Re: idle in transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Nikhil Ingale <niks.bgm@xxxxxxxxx>
Subject: Re: idle in transaction
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Mon, 27 Nov 2023 21:07:36 -0700
Cc: "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CALXkTpxX+P1qB+FPc-bHYEF2ZkHWqdBeTh4kUyfOkeJwggaZvQ@mail.gmail.com>
References: <CALXkTpxX+P1qB+FPc-bHYEF2ZkHWqdBeTh4kUyfOkeJwggaZvQ@mail.gmail.com>

On Monday, November 27, 2023, Nikhil Ingale <niks.bgm@xxxxxxxxx> 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.

Follow-Ups:
- Re: idle in transaction
  - From: Laurenz Albe

References:
- idle in transaction
  - From: Nikhil Ingale

Prev by Date: idle in transaction
Next by Date: Re: idle in transaction
Previous by thread: idle in transaction
Next by thread: Re: idle in transaction
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux