Postgres Pro
Downloads
Home   >   mailing lists

Re: Number of established connections since postmaster start - Mailing list pgsql-admin

From Florian Weimer
Subject Re: Number of established connections since postmaster start
Date
Msg-id 8239d38el6.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Number of established connections since postmaster start  (Frank Lanitz <frank@frank.uvena.de>)
List pgsql-admin
Tree view 
* 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?
>>
>> 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.)

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

pgsql-admin by date:

Previous
From: Frank Lanitz
Date:
Subject: Re: Number of established connections since postmaster start
Next
From: "Kevin Grittner"
Date:
Subject: Re: backup non-built-in tablespace