Re: To monitor the number of PostgreSQL database connections?

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.

Bruce basically said this question while Brian answered the first question.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/To-monitor-the-number-of-PostgreSQL-database-connections-tp5797571p5797608.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.