Number of Connections ?

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