Runbook: DeadlockDetected Alert

Alert Details

  • Alert Name: DeadlockDetected
  • Expression: increase(pg_stat_database_deadlocks{datname!~"template.*"}[30m]) > 0

Description

This alert triggers when the deadlock counter of a database increases and stays active for 30 minutes.

Possible Causes

  • two or more transactions are waiting indefinitely for each other to release locks

Troubleshooting Steps

1. identify the transactions which are causing the deadlock

2. resolve