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@sss.pgh.pa.us]
Sent: Thursday, February 21, 2002 7:35 PM
To: Percy
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] number of connections to postmaster


"Percy" <percy_yip@yahoo.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