I need to find a way to determine how many concurrent connections are being
made to the database server at any given time. I'm coming from
administering a MySQL database and am familiar with the following command:
mysqladmin -uroot -p processlist
This lists something like this:
+-----+------+-----------+----+---------+------+------------------+
| Id | User | Host | db | Command | Time | Info |
+-----+------+-----------+----+---------+------+------------------+
| 307 | root | localhost | | Sleep | 0 | |
| 308 | root | localhost | | Sleep | 0 | |
| 309 | root | localhost | | Query | 0 | show processlist |
+-----+------+-----------+----+---------+------+------------------+
User's on the system can also get a listing of only their own process list
and not see anyone else's processes by simply using their own username and
password.
I've looked through the FAQ and manual, but have not been able to find an
answer to this. Is there some pgsql command that will provide this
information. I need both a Full Listing from an administrative viewpoint
and a Per User listing.
If there is not a tool to do this, how difficult would it be to build a tool
to obtain this information? Or is there simply no way to extract this
information from pgsql?
Thanks!
Tauren
