Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 1C437DDBC28 for ; Fri, 2 Dec 2011 06:15:20 -0400 (AST) Received: from mx01.bfk.de ([193.227.124.2]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RWQ9D-0000sU-El for pgsql-admin@postgresql.org; Fri, 02 Dec 2011 10:15:21 +0000 Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) id 1RWQ90-0002un-5M for pgsql-admin@postgresql.org; Fri, 02 Dec 2011 10:15:02 +0000 Received: by bfk.de with local id 1RWQ90-0000Fw-0D for pgsql-admin@postgresql.org; Fri, 02 Dec 2011 10:15:02 +0000 From: Florian Weimer To: pgsql-admin@postgresql.org Subject: Re: Number of established connections since postmaster start References: <82aa7b8f5c.fsf@mid.bfk.de> <4ED8A3BA.3030401@frank.uvena.de> Date: Fri, 02 Dec 2011 10:15:01 +0000 In-Reply-To: <4ED8A3BA.3030401@frank.uvena.de> (Frank Lanitz's message of "Fri, 02 Dec 2011 11:08:58 +0100") Message-ID: <8239d38el6.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -3.1 (---) X-Archive-Number: 201112/9 X-Sequence-Number: 38767 * Frank Lanitz: > Am 02.12.2011 11:02, schrieb Florian Weimer: >> Is there a way to monitor the number of connections which have been >> established so far? >>=20 >> I'd like to graph this value, as a rough indicator whether connection >> pooling is working properly. > > You could check pg_stat_activity table. Should include a bunch of infos > you might looking for. Sorry, I was unclear. I need the total number, not just the number of connections currently active. (I already monitor pg_stat_activity---it is very helpful.) --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99