Log Analytics
Local-First
← Back to analyzer

Troubleshooting

PostgreSQL deadlock detected

Two or more transactions locked each other causing an abort.

SQL Lens

Run this query locally to surface offenders.

SELECT timestamp, message FROM logs WHERE message ILIKE '%deadlock%' ORDER BY timestamp DESC
Investigate in HUD

Playbook

  1. Capture pg_locks output around the timestamp for blocking chains.
  2. Add explicit ordering to conflicting DML statements.
  3. Shorten transaction scope or reduce isolation level to READ COMMITTED.