Re: Number of connection - Mailing list pgsql-admin

From Tom Lane
Subject Re: Number of connection
Date
Msg-id 28902.1013616112@sss.pgh.pa.us
Whole thread Raw
In response to Number of connection  ("Nebojsa Pirocanac" <pirke@EUnet.yu>)
List pgsql-admin
"Nebojsa Pirocanac" <pirke@EUnet.yu> writes:
> How can I get number of current connections to the database and is there an=
> y way to identify connection. For example in Oracle I can get these informa=
> tion from dynamic view V$SESSION.

In 7.2, yes.  See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/monitoring.html
and read about pg_stat_activity.

            regards, tom lane

pgsql-admin by date:

Previous
From: "sreedhar" (by way of Jean-Michel POURE
Date:
Subject: Problem while connecting pgAdmin II v1.2
Next
From: Osamu Ninagi
Date:
Subject: About Redo