{"Entry":{"collection":"catalog","key":"pg_stat_database_conflicts","name":"pg_stat_database_conflicts","aliases":[],"metadata":{"changed_in":["16","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","order":false,"removed":[],"status":"added","to":"9.1","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":["confl_active_logicalslot"],"attributes":[],"description_changed":false,"descriptions":[],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]},{"added":["stats_reset"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":9,"content_hash":"63cd5ac4ad7a3d0ae6aac57955e852f13ed5391aeb61b8265e5bb014a618eadc","first_version":"9.1","imported_at":"2026-09-30T00:40:55.912222+08:00","kind":"statistics","last_version":"20","name":"pg_stat_database_conflicts","position":89,"present_in":["9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:a808e5e2061914a4a796a508c51ce8bc1237615726f602bb91d18b09d52f5a43","summary":"The pg_stat_database_conflicts view will contain one row per database, showing database-wide statistics about query cancels occurring due to conflicts with recovery on standby servers.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_database_conflicts","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_database_conflicts","SourceRevision":"english-manuals:a808e5e2061914a4a796a508c51ce8bc1237615726f602bb91d18b09d52f5a43","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a database","description_zh":"","documented":true,"documented_name":"datid","hidden":false,"name":"datid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"Name of this database","description_zh":"","documented":true,"documented_name":"datname","hidden":false,"name":"datname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":3,"description":"Number of queries in this database that have been canceled due to dropped tablespaces","description_zh":"","documented":true,"documented_name":"confl_tablespace","hidden":false,"name":"confl_tablespace","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"Number of queries in this database that have been canceled due to lock timeouts","description_zh":"","documented":true,"documented_name":"confl_lock","hidden":false,"name":"confl_lock","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":5,"description":"Number of queries in this database that have been canceled due to old snapshots","description_zh":"","documented":true,"documented_name":"confl_snapshot","hidden":false,"name":"confl_snapshot","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":6,"description":"Number of queries in this database that have been canceled due to pinned buffers","description_zh":"","documented":true,"documented_name":"confl_bufferpin","hidden":false,"name":"confl_bufferpin","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Number of queries in this database that have been canceled due to deadlocks","description_zh":"","documented":true,"documented_name":"confl_deadlock","hidden":false,"name":"confl_deadlock","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"Number of uses of logical slots in this database that have been canceled due to old snapshots or too low a wal_level on the primary","description_zh":"","documented":true,"documented_name":"confl_active_logicalslot","hidden":false,"name":"confl_active_logicalslot","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20}],"description":"The pg_stat_database_conflicts view will contain one row per database, showing database-wide statistics about query cancels occurring due to conflicts with recovery on standby servers. This view will only contain information on standby servers, since conflicts do not occur on primary servers.","description_zh":"","doc":{"anchor":"PG-STAT-DATABASE-CONFLICTS-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["datid","datname","confl_tablespace","confl_lock","confl_snapshot","confl_bufferpin","confl_deadlock","confl_active_logicalslot"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-DATABASE-CONFLICTS-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["datid","datname","confl_tablespace","confl_lock","confl_snapshot","confl_bufferpin","confl_deadlock","confl_active_logicalslot"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_database_conflicts","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_database_conflicts","Summary":"pg_stat_database_conflicts视图为每个数据库包含一行，用来显示数据库范围内因与备库上的恢复过程冲突而被取消的查询统计信息。该视图只包含备库上的信息，因为这类冲突不会发生在主库上。","BodyHTML":"\u003cp\u003epg_stat_database_conflicts视图为每个数据库包含一行，用来显示数据库范围内因与备库上的恢复过程冲突而被取消的查询统计信息。该视图只包含备库上的信息，因为这类冲突不会发生在主库上。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"65120b96e6f3a2a9e57e82c4f25f378a530277179ecbc625611e2333c3ffcd14","Payload":{"columns":[{"description_zh":"数据库的OID","name":"datid","type":"oid","zh_from":"doc"},{"description_zh":"数据库的名称","name":"datname","type":"name","zh_from":"doc"},{"description_zh":"这个数据库中由于删除表空间而取消的查询的数量","name":"confl_tablespace","type":"bigint","zh_from":"doc"},{"description_zh":"此数据库中由于锁定超时而被取消的查询数","name":"confl_lock","type":"bigint","zh_from":"doc"},{"description_zh":"此数据库中由于旧快照而取消的查询数","name":"confl_snapshot","type":"bigint","zh_from":"doc"},{"description_zh":"此数据库中由于缓冲区被钉住而被取消的查询数","name":"confl_bufferpin","type":"bigint","zh_from":"doc"},{"description_zh":"此数据库中由于死锁而被取消的查询数","name":"confl_deadlock","type":"bigint","zh_from":"doc"},{"description_zh":"此数据库中因旧快照或主库上的wal_level太低而被取消的逻辑槽使用次数","name":"confl_active_logicalslot","type":"bigint","zh_from":"doc"}],"description_zh":"pg_stat_database_conflicts视图为每个数据库包含一行，用来显示数据库范围内因与备库上的恢复过程冲突而被取消的查询统计信息。该视图只包含备库上的信息，因为这类冲突不会发生在主库上。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}