Andrea Gnemmi looks at a pair of extensions:
We all know the importance of monitoring our RDBMS to ensure the performance and availability. Are there any tools that provide functionality to better to monitor PostgreSQL databases? In this article we will explore pg_stat_activity and pg_locks.
Click through for an overview of these two extensions and some of the functionality available in them.