Обсуждение: Number of established connections since postmaster start
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
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
* 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