Postgres Pro
Downloads
Home   >   mailing lists

Thread: Number of established connections since postmaster start

Number of established connections since postmaster start

From
Florian Weimer
Date:
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.

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

Re: Number of established connections since postmaster start

From
Frank Lanitz
Date:
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

Re: Number of established connections since postmaster start

From
Florian Weimer
Date:
* 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