Re: Connections Increasing Slowly - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Connections Increasing Slowly
Date
Msg-id CAKFQuwZijyuu0_OSZ8d0P5Fry_XGazPU59mki1fEDMXUStUffQ@mail.gmail.com
Whole thread Raw
In response to Re: Connections Increasing Slowly  ("Bee.Lists" <bee.lists@gmail.com>)
List 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 by date:

Previous
From: "Bee.Lists"
Date:
Subject: Re: Connections Increasing Slowly
Next
From: "David G. Johnston"
Date:
Subject: Re: Connections Increasing Slowly