Technologies/PostgreSQL/confl_lock
PostgreSQLPostgreSQLMetric

confl_lock

Lock conflicts
Dimensions:None
Available on:DatadogDatadog (1)Native (1)
Interface Metrics (2)
DatadogDatadog
Number of queries in this database that have been canceled due to lock timeouts. This will occur when the walreceiver process tries to apply a change requiring an ACCESS EXCLUSIVE lock while a query on the replica is reading the table. The conflicting query will be killed after waiting up to max_standby_streaming_delay seconds. This metric is tagged with db.
Dimensions:None
Native
confl_lock statistic from pg_stat_database_conflicts
Dimensions:None

Technical Annotations (3)

Technical References (3)
pg_lockscomponentpg_stat_activitycomponentcheck_postgrescomponent
Related Insights (1)
Lock contention and deadlocks block transaction progresswarning