April 27, 2024
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 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.