Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E99336500C5 for ; Mon, 10 Nov 2008 11:16:56 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 02402-08 for ; Mon, 10 Nov 2008 11:16:56 -0400 (AST) X-Greylist: delayed 00:06:16.460495 by SQLgrey-1.7.6 Received: from mail2.eaglepress.com (72-242-202-251.eaglepress.com [72.242.202.251]) by mail.postgresql.org (Postfix) with ESMTP id 8D5C465009C for ; Mon, 10 Nov 2008 11:16:56 -0400 (AST) Received: by mail2.eaglepress.com (Postfix, from userid 60001) id 895FD54; Mon, 10 Nov 2008 10:10:39 -0500 (EST) Received: from eaglepress.com (challenger.eaglepress.local [10.10.0.18]) by mail2.eaglepress.com (Postfix) with ESMTP id 3228E4D for ; Mon, 10 Nov 2008 10:10:39 -0500 (EST) Received: from 10.10.2.48 ([10.10.2.48]) by challenger.EaglePress.local ([10.10.0.18]) with Microsoft Exchange Server HTTP-DAV ; Mon, 10 Nov 2008 15:10:36 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-DxN9aR4ntC9bRF49zZxY" Received: from lin-it1.eaglepress.local by challenger.eaglepress.local; 10 Nov 2008 10:10:03 -0500 Content-class: urn:content-classes:message Subject: Number of Current Client Connections Date: Mon, 10 Nov 2008 10:10:03 -0500 Message-ID: <1226329803.26082.3.camel@lin-it1.eaglepress.local> X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Topic: Number of Current Client Connections Thread-Index: AclDRnvIf+ENAYiPSteIVNrW0S28LQ== From: "Sean Brown" To: X-Archive-Number: 200811/47 X-Sequence-Number: 30701 --=-DxN9aR4ntC9bRF49zZxY Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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 --=-DxN9aR4ntC9bRF49zZxY Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQBJGE7LHADH59cE9zIRAkoCAKCxQJYz+Jvp4UGNukTNw5R8J9+lTwCg7izF rjhlU4mK5z8RB5CjZIFLFLA= =koen -----END PGP SIGNATURE----- --=-DxN9aR4ntC9bRF49zZxY--