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
