[ADMIN] Number of established connections since postmaster start

[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.
--
Florian Weimer <***@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: [phone]
D-76133 Karlsruhe fax: [phone]

[Frank Lanitz]

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

[Florian Weimer]

Post by Frank Lanitz

Post by 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 <***@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: [phone]
D-76133 Karlsruhe fax: [phone]