Monitoring checklist | Postgres.FM 007 |
[Please subscribe, like, and share the materials in your social networks and groups!] Nikolay takes us through a checklist of important things to monitor, while Michael tries to keep up.
Monitoring checklist (dashboard #1):
1. TPS and (optional but also desired) QPS
2. Latency (query duration) — at least average. Better: histogram, percentiles
3. Connections (sessions) — stacked graph of session counts by state (first of all: active and idle-in-transaction; also interesting: idle, others) and how far the sum is from max_connection (+pool size for PgBouncer).
4. Longest transactions (max transaction age or top-n transactions by age), excluding autovacuum activity
5. Commits vs rollbacks — how many transactions are rolled back
6. Transactions left till transaction ID wraparound
7. Replication lags / bytes in replication slot / unused replication slots
8. Count of WALs waiting to be archived (archiving lag)
9. WAL generation rates
10. Locks and deadlocks
11. Basic query analysis graph (top-n by total_time or by mean_time?)
12. Basic wait event analysis (a.k.a. “active session analysis” or “performance insights”)
And links to a few things we mentioned:
Postgres monitoring review checklist (community document) https://docs.google.com/document/d/1V...
PostgreSQL Troubleshooting & Monitoring – Checklist / Runbook https://docs.google.com/document/d/1K...
https://pgstats.dev
Improving Postgres Connection Scalability: Snapshots (blog post by Andres Freund) https://techcommunity.microsoft.com/t...
Transaction ID Wraparound in Postgres (blog post by David Cramer) https://blog.sentry.io/2015/07/23/tra...
Subtransactions Considered Harmful (blog post by Nikolay) https://postgres.ai/blog/20210831-pos...
datadoghq.com
pgwatch2 (Postgres.ai Edition) https://gitlab.com/postgres-ai/pgwatch2
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.