Re: Locks analyze

Поиск
Список
Период
Сортировка
От Rajesh Kumar
Тема Re: Locks analyze
Дата
Msg-id CAJk5AtbJXRcZ3oS_8u16LJmdd8bcn+YX7hZPnOS=o5Z0zoQYuQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Locks analyze  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Jean-Christophe Boggio
Дата:
Сообщение: Re: One PG process eating more than 40GB of RAM and getting killed by OOM
Следующее
От: Tom Lane
Дата:
Сообщение: Re: One PG process eating more than 40GB of RAM and getting killed by OOM