February 8, 2026
The PostgreSQL monitoring covers the most important PostgreSQL database server monitoring activities.
- Monitoring PostgreSQL with Prometheus and Grafana – show you how to setup Prometheus and Grafana Monitoring Platforms to monitor the PostgreSQL database server.
- Monitoring Linux Servers with Node Exporter – show you how to setup the Node Exporter in Prometheus to monitor the Linux servers.
- Create custom metrics in Prometheus – show you how to create custom PostgreSQL metrics in Prometheus.
- Check transaction commit ratio – show you how to check transaction commit ratio in PostgreSQL.
- Check recovery conflicts – show you how to check recovery conflicts in PostgreSQL.
- Check deadlocks – show you how to check deadlocks in PostgreSQL.
- Check uses of temporary files – show you how to check uses of temporary files in PostgreSQL.
- Check prepared transactions – show you how to check abandoned prepared transactions in PostgreSQL.
- Check long running transactions on standby – show you how to check long running transactions on standby in PostgreSQL.
- Check replication slots blocking VACUUM – show you how to check replication slots blocking VACUUM in PostgreSQL.
- Check uses of subtransactions – show you how to check uses of subtransactions in PostgreSQL.
- Check Transaction ID Exhaustion – show you how to check transaction id exhaustion in PostgreSQL.
- Check orphaned data files – show you how to check orphaned data files in PostgreSQL.
- Check data file integrity – show you how to check data file integrity in PostgreSQL.
- Check the column correlation of a table – show you how to check the column correlation of a table in PostgreSQL.
- Check Slow Functions – show you how to check slow functions in PostgreSQL.
- Check duplicate indexes – show you how to check duplicate indexes in PostgreSQL.
- Check unused indexes – show you how to check unused indexes in PostgreSQL.
- Monitoring large tables – show you how to monitor large tables in PostgreSQL.
- Monitoring WAL Files – show you how to monitor WAL files in PostgreSQL.
- Check sequences near to be exhausted – show you how to check sequences near to be exhausted in PostgreSQL.
- Check which indexes to rebuild – show you how to check which indexes to rebuild in PostgreSQL.
- Check cache hit ratio – show you how to check cache hit ratio in PostgreSQL.
- Calculate memory usage – show you how to calculate PostgreSQL memory usage.
- Check Blocked Queries – show you how to check blocked queries in PostgreSQL.
- Check long running transactions – show you how to check long running transactions in PostgreSQL.
- Check Database Bloat – show you how to how to check database bloat in PostgreSQL.
- Check Streaming Replication Delay – show you how to check the streaming replication delay in PostgreSQL.
- Check the lock level taken by operations – show you how to check the lock level taken by operations in PostgreSQL.
See more
- PostgreSQL Documentation: Monitoring Database Activity
- PostgreSQL Documentation: Monitoring Disk Usage