Re: Number of Connections ? - Mailing list pgsql-general

From Jan Wieck
Subject Re: Number of Connections ?
Date
Msg-id 200111281301.fASD1Ec04092@saturn.jw.home
Whole thread Raw
In response to Number of Connections ?  (Erwin Ambrosch <ambre@ebutec.com>)
List pgsql-general
Erwin Ambrosch wrote:
> Hi,
>
> is there a query to ask my PostgeSql backend how much connections are
> currently open?

    New functionality in v7.2. Given your configuration starts at
    least  the  collector  daemon  (defaults  to   get   started,
    configuration is in postgres.conf), you can

        SELECT count(*) from pg_stat_activity;


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-general by date:

Previous
From: "Khan"
Date:
Subject: PostgreSQL ODBC for Windows
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [HACKERS] How to turn off TOAST on a table/column