Postgres Pro
Downloads
Home   >   mailing lists

Re: Locks analyze - Mailing list pgsql-admin

From Rajesh Kumar
Subject Re: Locks analyze
Date
Msg-id CAJk5AtbJXRcZ3oS_8u16LJmdd8bcn+YX7hZPnOS=o5Z0zoQYuQ@mail.gmail.com
Whole thread Raw
In response to Re: Locks analyze  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
95% if times idle sessions spikes thus lead to spike in total sessions..active or idle in transaction increases less than 5 coñnectiins

On Fri, 13 Oct, 2023, 6:44 PM Scott Ribe, <scott_ribe@elevated-dev.com> wrote:
> On Oct 13, 2023, at 3:39 AM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
>
> I am often facing idle connection spike. That is why I am checking all these.

Do total sessions increase along with idle sessions? Or does the total remain the same, but more are idle?

pgsql-admin by date:

Previous
From: Jean-Christophe Boggio
Date:
Subject: Re: One PG process eating more than 40GB of RAM and getting killed by OOM
Next
From: Tom Lane
Date:
Subject: Re: One PG process eating more than 40GB of RAM and getting killed by OOM