Re: number of connections to postmaster

Tom
When I try that, I get

template1=# select count(*) from pg_stat_activity;
ERROR: Relation 'pg_stat_activity' does not exist

thanks
Pam Wampler

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, February 21, 2002 7:35 PM
To: Percy
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] number of connections to postmaster

"Percy" <percy_yip(at)yahoo(dot)com> writes:
> Is there any way to find out the number of connections to postmaster?

In 7.2, "select count(*) from pg_stat_activity" should do it. See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/monitoring.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html