Thread: Number of Connections ?

Number of Connections ?

From
Erwin Ambrosch
Date:
Hi,

is there a query to ask my PostgeSql backend how much connections are
currently open?

Thanks Erwin



Re: Number of Connections ?

From
Jan Wieck
Date:
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