I know this isn't exactly what you're looking for (a query or log), but we use this tool to monitor our connections and alert when they hit a particular threshold:
On Wed, Mar 26, 2014 at 12:31 AM, Nithya Soman <nithya@xxxxxxxxxxxxxxxxxxxx> wrote:
Hi
Could you please provide any method (query or any logfile) to check
max connections happened during a time interval in psql DB ?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general