Thanks Christophe! I guess I had nothing to be worried about.
On Mon, Mar 8, 2021 at 9:46 AM Christophe Pettus <xof@xxxxxxxxxxxx> wrote:
> On Mar 7, 2021, at 17:34, Abdul Qoyyuum <aqoyyuum@xxxxxxxxxxxxxxxxx> wrote:
> Seems to get me worried. Should I be worried? Is this normal? If not, what should I do?
It's normal. Every connected client has an associated backend process, even if the client isn't doing anything. That's what the "idle" state means. You can consider using a pooler such as pgbouncer to reduce the number of connections the clients have open, although 200 open connections is nothing concerning.
--
-- Christophe Pettus
xof@xxxxxxxxxxxx
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043