High-water Mark for number of sessions/connections reached inPostgres

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

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
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_--