Date: Wed, 11 May 2022 14:09:12 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Sudhir Guna <sudhir.guna.sg@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: DB connection issue suggestions
Message-ID: <20220511190911.GO19626@telsasoft.com>
References: 
 <CAGedWvP=Mho1ayhmpXVQbaS3xxqu9ZgQOhKe-rF4kyxo=gYN0Q@mail.gmail.com>
 <20220510181540.GC19626@telsasoft.com>
 <CAGedWvMr1duwgbb5EshaFn8n71Nn_gd_c0QWEOTx-atHptA+cg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAGedWvMr1duwgbb5EshaFn8n71Nn_gd_c0QWEOTx-atHptA+cg@mail.gmail.com>
User-Agent: Mutt/1.9.4 (2018-02-28)
Archived-At: 
 <https://www.postgresql.org/message-id/20220511190911.GO19626%40telsasoft.com>
Precedence: bulk

On Wed, May 11, 2022 at 09:52:10AM +0800, Sudhir Guna wrote:
> Hi Justin,
> 
> Thank you for reviewing.
> 
> I have tried to run the below query and could see only less than 5
> connections active when I get this error. The total rows I see is only 10
> including idle and active sessions for this output.

That doesn't sound right.  Are you sure you're connecting to the correct
instance ?  Are there really only 5 postgres processes on the server, and fewer
than 5 connections to its network port or socket ?

You didn't provide any other info like what OS this is.

-- 
Justin