| From: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Locks analyze |
| Date: | 2023-10-13 14:57:32 |
| Message-ID: | CAJk5AtbJXRcZ3oS_8u16LJmdd8bcn+YX7hZPnOS=o5Z0zoQYuQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)elevated-dev(dot)com>
wrote:
> > On Oct 13, 2023, at 3:39 AM, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-10-13 15:02:04 | Re: One PG process eating more than 40GB of RAM and getting killed by OOM |
| Previous Message | Jean-Christophe Boggio | 2023-10-13 14:31:21 | Re: One PG process eating more than 40GB of RAM and getting killed by OOM |