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(at)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