Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\))
Subject: Re: Handling idle connections
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAJk5AtZ5XNhvwJqE3MK1SZ5ufHraqtN7EsR4WgadXfvdrgyNOA@mail.gmail.com>
Date: Sun, 24 Sep 2023 07:19:44 -0600
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <FE25C43F-16C6-43B2-A2C6-C80347C9E6F3@elevated-dev.com>
References: 
 <CAJk5Ata=NXO46e7RcS-CxEXvroz=-fojS+XzpW-Bty+G-sx51A@mail.gmail.com>
 <CF42B9B4-89EC-4F5C-A49B-A3F9A48F24F2@elevated-dev.com>
 <CAJk5AtZ5XNhvwJqE3MK1SZ5ufHraqtN7EsR4WgadXfvdrgyNOA@mail.gmail.com>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/FE25C43F-16C6-43B2-A2C6-C80347C9E6F3%40elevated-dev.com>
Precedence: bulk

> On Sep 24, 2023, at 7:03 AM, Rajesh Kumar =
<rajeshkumar.dba09@gmail.com> wrote:
>=20
> Could u give me a tip on how to figure out where they are coming and =
what do u mean exactly by saying "fixing" them

Look at pg_stat_activity. There's the application_name column--if your =
apps are not setting that, the query column shows last/current query and =
that is sometimes a clue. (Also, if your clients are not setting =
application name, fix them.)

If you don't want client applications leaving connections idle, then =
clients should release connections when not using them.