Finding number of current connections
От | Tauren Mills |
---|---|
Тема | Finding number of current connections |
Дата | |
Msg-id | NBBBLBKDJMGDNPMDGAABAEBKBBAB.tauren@servlets.net обсуждение исходный текст |
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: