Technologies/PostgreSQL/postgresql.deadlocks
PostgreSQLPostgreSQLMetric

postgresql.deadlocks

Deadlocks detected
Dimensions:None
Available on:DatadogDatadog (1)Native (1)OpenTelemetryOpenTelemetry (1)PrometheusPrometheus (1)
Interface Metrics (4)
DatadogDatadog
The rate of deadlocks detected in this database. This metric is tagged with db.
Dimensions:None
Native
Number of deadlocks detected
Dimensions:None
OpenTelemetryOpenTelemetry
The number of deadlocks.
Dimensions:None
PrometheusPrometheus
Number of deadlocks detected in this database
Dimensions:None
Sources
postgresql.deadlocksgithub.com
deadlocksgithub.com
postgresql.deadlocksgithub.com
stat_database_deadlocksgithub.com

Technical Annotations (16)

Configuration Parameters (1)
statement_timeoutrecommended: 30s
prevents indefinite lock waits by canceling statements
Error Signatures (1)
deadlock detectedlog pattern
CLI Commands (5)
SET statement_timeout = '30s';remediation
SELECT pg_try_advisory_lock(table_id) FROM my_table;remediation
grep -A 20 "deadlock detected" /var/log/postgresql/*.logdiagnostic
SELECT deadlocks FROM pg_stat_database WHERE datname = 'myapp';monitoring
grep "deadlock detected" /var/log/postgresql/*.logdiagnostic
Technical References (9)
pg_lockscomponentpg_stat_activitycomponentcheck_postgrescomponentlock managercomponentlock contentionconcept/var/log/postgresql/*.logfile pathpg_stat_databasecomponentdeadlockconceptrow lockconcept
Related Insights (6)
Lock contention and deadlocks block transaction progresswarning
▸
Lock contention affects overall database performancewarning
▸
Deadlocks causing transaction failures and timeoutswarning
▸
Deadlocks cause transaction rollback and data operation failurecritical
▸
Deadlocks occurring but not tracked in metricsinfo
▸
Deadlocks from inconsistent row lock orderingcritical
▸