| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | "Brusser, Michael" <Michael(dot)Brusser(at)matrixone(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: How to find a number of connections |
| Date: | 2005-11-14 19:27:36 |
| Message-ID: | 20051114192736.GF18570@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
It would be better to ask this on -general, but
SELECT count(*) FROM pg_stat_activity;
is what you want.
On Fri, Nov 11, 2005 at 12:35:28PM -0500, Brusser, Michael wrote:
> Is there a way to find a number of current connections on Postgres 7.3.x
> ?
>
> I looked at some system tables and views, but did not see anything
> obvious.
>
>
>
> Thank you,
>
> Mike
>
>
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2005-11-14 19:38:19 | Re: 8.0 -> 8.1 dump duplicate key problem? |
| Previous Message | Tino Wildenhain | 2005-11-14 19:16:04 | Re: functions marked STABLE not allowed to do INSERT |