Feature · /deadlock-detection
死锁检测
当 Postgres 卡住时,10 秒内知道为什么。
In one line
捕获每一次死锁,附完整锁链上下文、调用栈和修复建议。
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.