From: | "Bee(dot)Lists" <bee(dot)lists(at)gmail(dot)com> |
---|---|
To: | Submit Postgresql Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Connections Increasing Slowly |
Date: | 2020-06-22 19:43:09 |
Message-ID: | 8A1234E2-D4C3-451F-8F60-901D0D5E0CA5@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi folks. My PostgreSQL server has a growing number of connections.
Currently it’s at 115. max_connections set to 300. It’s being accessed from public (web application), server cron once a day, and two clients on the LAN, a handful of times a day.
I’m a bit surprised that the connection pool isn’t purged during this time.
datid | datname | numbackends | xact_commit | stats_reset
-------+--------------+-------------+-------------+-------------------------------
16385 | my_db_name | 115 | 128981 | 2020-05-17 06:48:18.191103-04
Is there any way I can troubleshoot this? Is this normal? I’m having connection issues in another client, so I’m sniffing out connection issues and monitoring this number grow over days.
Any help appreciated.
Cheers, Bee
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-06-22 20:11:48 | Re: Connections Increasing Slowly |
Previous Message | Richard Bernstein | 2020-06-20 01:45:03 | manual for syntax for pg Query Tool |