| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Number of established connections since postmaster start |
| Date: | 2011-12-02 10:15:01 |
| Message-ID: | 8239d38el6.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
* 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(at)bfk(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-12-02 15:46:23 | Re: backup non-built-in tablespace |
| Previous Message | Frank Lanitz | 2011-12-02 10:08:58 | Re: Number of established connections since postmaster start |