Re: To monitor the number of PostgreSQL database connections?

From: Brian Cosgrove <brian(dot)cosgrove(at)getbraintree(dot)com>
To: Nithya Soman <nithya(at)quintetsolutions(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: To monitor the number of PostgreSQL database connections?
Date: 2014-03-26 19:42:31
Message-ID: CA+gbG9fS6FquXNaZAP-7yA6_OKfLKk9xmY66e2wMY+j0Kc=X+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2014-03-26 19:42:38 Auditing Code - Fortify
Previous Message Bruce Momjian 2014-03-26 19:39:41 Re: To monitor the number of PostgreSQL database connections?