Обсуждение: High-water Mark for number of sessions/connections reached in Postgres
I was wondering if we can query/obtain the high-water mark of number of sessions or connections reached in a Postgres database. Is there a view or command that can provide this information. The pg_stat_database shows the current number of connections, but not the high-water mark a database had reached.
Thanks in advance.
Husam
Husam
****************************************************************************************** This message may contain confidential or proprietary information intended only for the use of the addressee(s) named above or may contain information that is legally privileged. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message and any copies immediately thereafter. Thank you. ****************************************************************************************** CLLD
> I was wondering if we can query/obtain the high-water mark of number
> of sessions or connections reached in a Postgres database. Is there a
> view or command that can provide this information. The
> pg_stat_database shows the current number of connections, but not the
> high-water mark a database had reached.
Like "show max_connections"
Jesper
> of sessions or connections reached in a Postgres database. Is there a
> view or command that can provide this information. The
> pg_stat_database shows the current number of connections, but not the
> high-water mark a database had reached.
Like "show max_connections"
Jesper