Thread: How to find a number of connections

How to find a number of connections

From
"Brusser, Michael"
Date:
Is there a way to find a number of current connections on Postgres 7.3.x
?

Thank you,
Mike



Re: How to find a number of connections

From
Bruno Wolff III
Date:
On Fri, Nov 11, 2005 at 15:09:41 -0500, "Brusser, Michael" <Michael.Brusser@matrixone.com> wrote:
> Is there a way to find a number of current connections on Postgres 7.3.x
> ?

This might help you:
http://www.postgresql.org/docs/7.3/static/monitoring.html


Re: How to find a number of connections

From
Bryan White
Date:
Brusser, Michael wrote:
> Is there a way to find a number of current connections on Postgres 7.3.x
> ?

select count(*) from pg_stat_activity

-- 
Bryan White, ArcaMax Publishing Inc.

I never look back, darling. it distracts from the now. - Edna Mode