PostgreSQL Tutorial: PostgreSQL Monitoring

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 check database bloat in PostgreSQL.
• Check B-tree index to rebuild – show you how to check B-tree index to rebuild 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