Technologies/PostgreSQL/postgresql.conflicts
PostgreSQLPostgreSQLMetric

postgresql.conflicts

Recovery conflicts
Dimensions:None
Available on:Native (1)PrometheusPrometheus (1)
Interface Metrics (2)
Native
Number of queries canceled due to recovery conflicts
Dimensions:None
PrometheusPrometheus
Number of queries canceled due to conflicts with recovery in this database. (Conflicts occur only on standby servers; see pg_stat_database_conflicts for details.)
Dimensions:None
Sources
conflictsgithub.com
stat_database_conflictsgithub.com

Technical Annotations (11)

Configuration Parameters (1)
disable_on_error
Subscription option to automatically disable on errors before using pg_replication_origin_advance()
Error Signatures (2)
duplicate key value violates unique constraintlog pattern
CONTEXT: processing remote data for replication originlog pattern
CLI Commands (2)
ALTER SUBSCRIPTION ... SKIPremediation
ALTER SUBSCRIPTION ... DISABLEremediation
Technical References (6)
pg_replication_origin_advance()componentpg_replication_origin_statuscomponentfinish LSNconceptreplication originconceptrow-level securitycomponentsubscription ownerconcept
Related Insights (3)
Logical replication stops on constraint violations requiring manual resolutioncritical
▸
Row-level security on subscriber tables causes replication conflictswarning
▸
Permission failures on target tables halt logical replicationcritical
▸