Re: How to find a number of connections

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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461