High-water Mark for number of sessions/connections reached inPostgres
am 07.08.2010 02:26:36 von htomeh --_000_F849E59B1BB96C42A849EBCD724513F515FC3CEF47ISCESNA01CX MB_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I was wondering if we can query/obtain the high-water mark of number of ses=
sions or connections reached in a Postgres database. Is there a view or com=
mand that can provide this information. The pg_stat_database shows the cur=
rent number of connections, but not the high-water mark a database had reac=
hed.
Thanks in advance.
Husam
Husam
************************************************************ ***************=
***************=20
This message may contain confidential or proprietary information intended o=
nly for the use of the=20
addressee(s) named above or may contain information that is legally privile=
ged. If you are=20
not the intended addressee, or the person responsible for delivering it to =
the intended addressee,=20
you are hereby notified that reading, disseminating, distributing or copyin=
g this message is strictly=20
prohibited. If you have received this message by mistake, please immediatel=
y notify us by =20
replying to the message and delete the original message and any copies imme=
diately thereafter.=20
Thank you.=20
************************************************************ ***************=
***************=20
CLLD
--_000_F849E59B1BB96C42A849EBCD724513F515FC3CEF47ISCESNA01CX MB_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
I was wondering if we can query/obtain the high-wat=
er
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
**********************************************************************=
********************=20
This message may contain confidential or proprietary information intended o=
nly for the use of the=20
addressee(s) named above or may contain information that is legally privile=
ged. If you are=20
not the intended addressee, or the person responsible for delivering it to =
the intended addressee,=20
you are hereby notified that reading, disseminating, distributing or copyin=
g this message is strictly=20
prohibited. If you have received this message by mistake, please immediatel=
y notify us by =20
replying to the message and delete the original message and any copies imme=
diately thereafter.=20
Thank you.=20
***************************************************************************=
***************=20
CLLD
--_000_F849E59B1BB96C42A849EBCD724513F515FC3CEF47ISCESNA01CX MB_--