Re: To monitor the number of PostgreSQL database connections?

On Wed, Mar 26, 2014 at 7:02 PM, David Johnston <polobo@yahoo.com> wrote:
> Nithya Soman wrote
>> Hi
>>
>> Could you please provide any method (query or any logfile) to check
>> max connections happened during a time interval in psql DB ?
>
> Only if the time interval desired in basically zero-width (i.e.,
> instantaneous).  The "pg_stat_activity" view is your friend in this.
>
> You have numerous options, including self-coding, for capturing and
> historically reviewing these snapshots and/or setting up monitoring on them.
>
> This presumes you are actually wondering "over any given time period how
> many open connections were there"?  If your question is actually "In the
> given time period did any clients get rejected because {max connections}
> were already in use." you can check the PostgreSQL logs for the relevant
> error.

There's also some useful high level statistics (including connection
count) in pg_stat_database.  For exact connection count over time
frame, I'd turn on log_connections in postgresql.conf and grep the
log.

merlin