Re: How to find a number of connections

Thank you, this is very handy.
I'd like to understand why the result of this query is different
from the number of Postgres processes reported by `ps`.
(The query returns 8, ps shows 11)

One process is really postmaster, the others seem to be doing some
house chores: stats buffer process and stats collector process.
Do they actually use connections, decrementing what's available from
the max_connections value?

Thank you

-----Original Message-----
From: pgsql-hackers-owner@postgresql On Behalf Of Bryan White
... ...

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