{"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":"b37c37622f52394123d240070b25a8be99c2467655fb31bf6e6aec3e7bb2f68a","derived_content_hash":"c8fff30e541514a831d7f6864e28a6576780fe45eb5a88078ce138ebbe208f03","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:87a6bbaff8e894066d6eb03436331bc6139e95ecc56c100dd5c683f97ef9f2a2","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"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":"catalog-bilingual-repair:87a6bbaff8e894066d6eb03436331bc6139e95ecc56c100dd5c683f97ef9f2a2","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":"pg_stat_database_conflicts 视图为每个数据库包含一行，用来显示数据库范围内因与备库上的恢复过程冲突而被取消的查询统计信息。该视图只包含备库上的信息，因为这类冲突不会发生在主库上。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_database_conflicts","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_database_conflicts","SourceRevision":"catalog-bilingual-repair:87a6bbaff8e894066d6eb03436331bc6139e95ecc56c100dd5c683f97ef9f2a2","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a database","description_zh":"数据库的 OID","documented":true,"documented_name":"datid","hidden":false,"name":"datid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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":"此数据库中因旧快照或主库上的 wal_level 太低而被取消的逻辑槽使用次数","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,"zh_from":"same-version-manual"}],"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":"pg_stat_database_conflicts 视图为每个数据库包含一行，用来显示数据库范围内因与备库上的恢复过程冲突而被取消的查询统计信息。该视图只包含备库上的信息，因为这类冲突不会发生在主库上。","description_zh_html":"\u003cp\u003epg_stat_database_conflicts 视图为每个数据库包含一行，用来显示数据库范围内因与备库上的恢复过程冲突而被取消的查询统计信息。该视图只包含备库上的信息，因为这类冲突不会发生在主库上。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-DATABASE-CONFLICTS-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.28. \u003ccode class=\"structname\"\u003epg_stat_database_conflicts\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_database_conflicts 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003edatid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       数据库的 OID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003edatname\u003c/code\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       数据库的名称\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003econfl_tablespace\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       这个数据库中由于删除表空间而取消的查询的数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003econfl_lock\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       此数据库中由于锁定超时而被取消的查询数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003econfl_snapshot\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       此数据库中由于旧快照而取消的查询数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003econfl_bufferpin\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       此数据库中由于缓冲区被钉住而被取消的查询数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003econfl_deadlock\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       此数据库中由于死锁而被取消的查询数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003econfl_active_logicalslot\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       此数据库中因旧快照或主库上的 \u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-wal.html#GUC-WAL-LEVEL\"\u003ewal_level\u003c/a\u003e 太低而被取消的逻辑槽使用次数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STAT-DATABASE-CONFLICTS-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"documentation_revision":{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:a808e5e2061914a4a796a508c51ce8bc1237615726f602bb91d18b09d52f5a43","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-DATABASE-CONFLICTS-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:a808e5e2061914a4a796a508c51ce8bc1237615726f602bb91d18b09d52f5a43","version":"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":"center","Version":"18","Locale":"en","Title":"pg_stat_database_conflicts","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. This view will only contain information on standby servers, since conflicts do not occur on primary servers.","BodyHTML":"\u003cp\u003eThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:87a6bbaff8e894066d6eb03436331bc6139e95ecc56c100dd5c683f97ef9f2a2","ContentHash":"fa29829030d2015a28eeb1e8e452ddc07d3b0b281d82694af0e0bfbfaec82e35","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a database","description_zh":"数据库的 OID","documented":true,"documented_name":"datid","hidden":false,"name":"datid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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":"此数据库中因旧快照或主库上的 wal_level 太低而被取消的逻辑槽使用次数","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,"zh_from":"same-version-manual"}],"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."}},"RequestedLocale":"en","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}