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
<nithya(at)quintetsolutions(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>