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:
http://bucardo.org/check_postgres/check_postgres.pl.html#backends On Wed, Mar 26, 2014 at 12:31 AM, Nithya Soman <nit...@quintetsolutions.com>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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >