Feature · /deadlock-detection
Deadlock-Erkennung
Wenn dein Postgres hängt, weißt du in 10 Sekunden warum.
In one line
Erfasse jeden Deadlock mit vollständigem Lock-Chain-Kontext, Stacks und Behebungsvorschlägen.
What you get
- Postgres: pg_locks + pg_stat_activity sampled at 1 Hz, deadlock_timeout messages parsed from logs
- MySQL: SHOW ENGINE INNODB STATUS deadlock section parsed
- MongoDB: deadlock-equivalent (write conflicts) detected via currentOp
- Lock chain visualization showing every session in the cycle
- Per-deadlock playbook: shortest-path remediation suggestions
- Alert webhook within 30s of detection
FAQ
How is this different from just reading the Postgres log?+
We correlate the deadlock log line with the live activity sample 1s before, so you see exactly what every session was doing — including queries from sessions not mentioned in the log line.
Related reading
Postgres
Postgres lock chains: how to find the session blocking yours
A practical walkthrough of pg_locks, pg_blocking_pids, and the recursive CTE that gives you the full chain — including the AccessExclusiveLocks that quietly take your DB down.
Postgres
Postgres slow queries: 12 causes and how to find each one
A field-tested playbook for diagnosing a slow Postgres query in production — from missing indexes to plan flips to bloated tables — with the SQL to find each cause and the fix.
· · ·
Überwache deine Datenbanken wie deine Services.
Buche eine 30-minütige Demo. Wir besprechen deine Flotte und erstellen ein 30-Tage-Angebot.