MIME-Version: 1.0
Content-class: 
Message-ID: <420101c94348$3d91b631$1a1ca8c0@ana.firstamdata.com>
From: "Tomeh, Husam" <HTomeh@facorelogic.com>
Subject: Re: Number of Current Client Connections
thread-topic: [ADMIN] Number of Current Client Connections
thread-index: AclDSD2R0EHUYZsOSCSNToflAtzRfw==
Date: Mon, 10 Nov 2008 07:23:20 -0800
Importance: normal
To: "Sean Brown" <sbrown@eaglepress.com>,
	<pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset="iso-8859-1"


Yes, you got it. A count on pg_stat_activity should do it.

Regards,
=20   Husam=20


-----Original Message-----
From: Sean Brown <sbrown@eaglepress.com>
Sent: Monday, November 10, 2008 7:10 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Number of Current Client Connections

Is there a query I can run against PostgreSQL to get the number of
current client connections to the database? I didn't expect trying to
track this down would be as difficult as it has been.

Would a simple count of pg_stat_activity be correct?

-Thanks
**********************************************************************
This message contains confidential information intended only for the use =
of the addressee(s) named above and may contain information that is legal=
ly privileged.  If you are not the addressee, or the person responsible f=
or delivering it to the addressee, you are hereby notified that reading, =
disseminating, distributing or copying this message is strictly prohibite=
d.  If you have received this message by mistake, please immediately noti=
fy us by replying to the message and delete the original message immediat=
ely thereafter.

Thank you.
=0D
=20                                  FADLD Tag
**********************************************************************