If you need to know what is happening on your PostgreSQL server right now and do not have a PostgreSQL monitoring tool available.  pgNow is a quick, free alternative.  It is a simple tool to install and can help you diagnose and monitor what is going on within your postgreSQL databases.  pgNow allows you to see: -

• The workload that is running on the instance and which queries are taking the longest time to execute
• The users sessions that could be caused by expensive operations taking place
• Indexes which are not improving search performance
• Tables which are not vacuumed and leaving dead tuples bloating tables
• Configuration settings which are are not optimised based on best practise