pgAdmin Useful Tools
How do I find the current connections to my PostgreSQL database?
If you open pgAdmin and connect to your database you will then be able to select Server Status from the Tools menu.
This will display the current Activity and the Log e.g.