The infographic lists 10 key PostgreSQL monitoring metrics with Prometheus alert examples for Kubernetes and AWS RDS. It starts with availability checks (pg_up) and postmaster service uptime to detect unexpected restarts. It covers replication lag to avoid coherence issues, database size and available storage to prevent disk exhaustion, and available connections to catch connection saturation. For performance, it highlights latency via longest active transaction duration, cache hit rate to spot memory pressure and increased disk reads, memory available (Kubernetes limits versus usage, or RDS freeable memory), and requested buffer checkpoints to detect excessive checkpointing that can degrade performance.

Join for free to read