Message-ID: <f7d8b0bc16be17cc38d97ce90ad9060f7fb9d8f3.camel@cybertec.at>
Subject: Re: Locks analyze
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Fri, 13 Oct 2023 13:59:35 +0200
In-Reply-To: 
 <CAJk5AtZBhKzgu9KOMDxyC7FxTsULS2hWRJ=Zod+2kzmL+KEhnw@mail.gmail.com>
References: 
	<CAJk5AtaHsNNp-R3zmeeZ9G06LH_yHXEdCN7TpeR2HTO4Tde7Hw@mail.gmail.com>
	 <91d371667a3e27cb0da7001d048d1c417074b6ef.camel@cybertec.at>
	 <CAJk5AtZBhKzgu9KOMDxyC7FxTsULS2hWRJ=Zod+2kzmL+KEhnw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/f7d8b0bc16be17cc38d97ce90ad9060f7fb9d8f3.camel%40cybertec.at>
Precedence: bulk

On Fri, 2023-10-13 at 15:09 +0530, Rajesh Kumar wrote:
> How do I identify a session that is blocked?

See "wait_event_type" in "pg_stat_activity" (or see "pg_locks").

> Can blocking sessions increase idle sessions?

Only within certain limits, unless your applicaton is doing something wrong=
.

> I see something like waitdurarion in pg_locks..is that helpful anyway?

Yes, that means that the session has been waiting for the lock for a while.

Yours,
Laurenz Albe