Re: Connections Increasing Slowly

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Connections Increasing Slowly
Дата
Msg-id CAKFQuwZijyuu0_OSZ8d0P5Fry_XGazPU59mki1fEDMXUStUffQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Connections Increasing Slowly  ("Bee.Lists" <bee.lists@gmail.com>)
Список pgsql-novice
On Tue, Jun 23, 2020 at 10:25 AM Bee.Lists <bee.lists@gmail.com> wrote:
I have one simple query that’s in my activity (currently active) that’s in there 5 times.  It should have closed very quickly, yet there’s 5 instances idling.  I have two other queries, that should have operated quickly, then closed, but they are idling. 

Queries don't idle.  Only sessions can be idle - either normally or while holding an open transaction.  An idle session will have a "last executed query" which may be confusing you.  You should probably post the actual results of pg_stat_activity along with your comments so as to help rule out mis-identification.

David J.

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Bee.Lists"
Дата:
Сообщение: Re: Connections Increasing Slowly
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Connections Increasing Slowly