[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] High-water Mark for number of sessions/connections reached
From:       Jesper Krogh <jesper () krogh ! cc>
Date:       2011-05-31 18:35:14
Message-ID: 4DE534E2.6000101 () krogh ! cc
[Download RAW message or body]

>  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


[Attachment #3 (text/html)]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    <span style="white-space: pre;">&gt; I was wondering if we can
      query/obtain the high-water mark of number<br>
      &gt; of sessions or connections reached in a Postgres database. Is
      there a<br>
      &gt; view or command that can provide this information. The<br>
      &gt; pg_stat_database shows the current number of connections, but
      not the<br>
      &gt; high-water mark a database had reached.<br>
    </span><br>
    Like "show max_connections"<br>
    <br>
    Jesper<br>
    <br>
  </body>
</html>


[prev in list] [next in list] [prev in thread] [next in thread]

Configure | About | News | Add a list | Sponsored by KoreLogic