2026-04-17 — Database Administration — Find exactly who is blocking who in PostgreSQL — the blocking session, the waiting session, and the query that started the pile-up.
2026-04-17 — Database Administration — Track deadlock counts per database, identify tables with active lock contention, and surface the transactions involved.
2026-04-17 — Database Administration — Spot long-running queries and idle transactions in PostgreSQL before they block autovacuum, hold locks, and cause a cascade of timeouts.