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,
Tom Lane wrote:
> "Brusser, Michael" <[EMAIL PROTECTED]> writes:
> > 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,
>
> No.
But note that in 8.1, autovacuum does.
--
Alv
"Brusser, Michael" <[EMAIL PROTECTED]> writes:
> 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,
No.
regards, tom lane
---(end
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
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
---(end of broadcast)---
Please disregard this duplicate
submission, my mistake.
Mike
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brusser, Michael
Sent: Friday, November 11, 2005
12:35 PM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] How to find a
number of connections
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
On Fri, Nov 11, 2005 at 15:09:41 -0500,
"Brusser, Michael" <[EMAIL PROTECTED]> 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
---(end of broadcast)--
Is there a way to find a number of current connections on Postgres 7.3.x
?
Thank you,
Mike
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
