Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 46BB4DDBC27
	for <pgsql-admin@postgresql.org>; Fri,  2 Dec 2011 06:09:10 -0400 (AST)
Received: from [2001:4d88:1ffc:463::1] (helo=uvena.de)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <frank@frank.uvena.de>) id 1RWQ3J-0000mY-PF
	for pgsql-admin@postgresql.org; Fri, 02 Dec 2011 10:09:10 +0000
Received: from [141.35.39.175] (c319808.zuv.uni-jena.de [141.35.39.175])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by uvena.de (Postfix) with ESMTPSA id 175CA254015
	for <pgsql-admin@postgresql.org>; Fri,  2 Dec 2011 10:10:29 +0000 (UTC)
Message-ID: <4ED8A3BA.3030401@frank.uvena.de>
Date: Fri, 02 Dec 2011 11:08:58 +0100
From: Frank Lanitz <frank@frank.uvena.de>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Number of established connections since postmaster start
References: <82aa7b8f5c.fsf@mid.bfk.de>
In-Reply-To: <82aa7b8f5c.fsf@mid.bfk.de>
X-Enigmail-Version: 1.3.3
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Host-Lookup-Failed: Reverse DNS lookup failed for 2001:4d88:1ffc:463::1
	(failed)
X-Pg-Spam-Score: 0.3 (/)
X-Archive-Number: 201112/8
X-Sequence-Number: 38766

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?
> 
> 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.

Cheers,
Frank