{"Entry":{"collection":"metric","key":"pg_stat_database_conflicts-confl_snapshot","name":"pg_stat_database_conflicts.confl_snapshot","aliases":["confl_snapshot","pg_stat_database_conflicts"],"metadata":{"aliases":["confl_snapshot","pg_stat_database_conflicts"],"category":"pg_stat_database_conflicts","content_hash":"d493a7537af61c1355137e26682a95ed020a1ecaaf700533771110f930d325a8","derived_content_hash":"d30b62c733f04d96560d5193475c3600b2b004865c39289f9f3c358bb7f6d04a","imported_at":"2026-09-30T00:40:45.62572+08:00","name":"pg_stat_database_conflicts.confl_snapshot","name_zh":"","slug":"pg_stat_database_conflicts-confl_snapshot","summary":"Number of queries in this database that have been canceled due to old snapshots"}},"Definition":{"Collection":"metric","Key":"pg_stat_database_conflicts-confl_snapshot","SourceDatabase":"center","Version":"18","SourceTable":"statistics_metric","SourceKey":"pg_stat_database_conflicts-confl_snapshot","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"field":"confl_snapshot","sql_type":"bigint","units_mentioned":[],"view":"pg_stat_database_conflicts"},"comparison_hash":"f30451b4bdf4c1e1f5262a58e9d6fdbc2a5dd1feeb9aba638ac5fca1815f4b4b","description":["Number of queries in this database that have been canceled due to old snapshots"],"description_zh":"此数据库中由于旧快照而取消的查询数","description_zh_html":"\u003cp\u003epg_stat_database_conflicts.confl_snapshot 统计字段。\u003c/p\u003e\u003cdl\u003e\u003cdt\u003e视图\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003epg_stat_database_conflicts\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e字段\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003econfl_snapshot\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003eSQL 类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003ebigint\u003c/code\u003e\u003c/dd\u003e\u003c/dl\u003e\u003ch3\u003e同版本中文手册定义\u003c/h3\u003e\u003cp\u003e此数据库中由于旧快照而取消的查询数\u003c/p\u003e\u003cp\u003e\u003ca href=\"/zh/docs/18/monitoring-stats.html#\"\u003e查看完整中文手册与上下文\u003c/a\u003e。\u003c/p\u003e","documented":true,"facts":[{"label":"View","value":"pg_stat_database_conflicts"},{"label":"Field","value":"confl_snapshot"},{"label":"SQL type","value":"bigint"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"facts_zh":[{"label":"视图","value":"pg_stat_database_conflicts"},{"label":"字段","value":"confl_snapshot"},{"label":"SQL 类型","value":"bigint"},{"label":"字段定义记载的单位","value":"未指定"},{"label":"重置条件","value":"手册未为此视图记载 stats_reset 字段"}],"field":"confl_snapshot","manual_html":"","manual_path":"/docs/18/monitoring-stats.html","related":[{"label":"pg_stat_database_conflicts columns","url":"/wiki/catalog/pg_stat_database_conflicts/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["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."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT confl_snapshot FROM pg_catalog.pg_stat_database_conflicts;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"sections_zh":[{"paragraphs":["pg_stat_database_conflicts 视图为每个数据库包含一行，用来显示数据库范围内因与备库上的恢复过程冲突而被取消的查询统计信息。该视图只包含备库上的信息，因为这类冲突不会发生在主库上。"],"title":"视图语义"},{"paragraphs":["重置范围和可见性请参阅下方同版本的统计信息收集与视图文档。不根据字段名称推断各字段的重置规则。"],"title":"采集与重置语义"},{"code":"SELECT confl_snapshot FROM pg_catalog.pg_stat_database_conflicts;","paragraphs":["示例查询；不表示已执行，也不提供实测值。"],"title":"查看此字段"}],"signature":"SELECT confl_snapshot FROM pg_catalog.pg_stat_database_conflicts;","source_only":false,"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-DATABASE-CONFLICTS-VIEW"}],"sql_type":"bigint","tables":[],"tables_zh":[],"units_mentioned":[],"view":"pg_stat_database_conflicts","zh_from":{"authored_translation":"source-derived-structured-summary","body_sha256":"c17331a7456288fac6e6cfe933a90dcc93920d8f7c49a90986e091f64f7a690c","kind":"same-version-chinese-manual-with-source-derived-structured-summary","manual":{"anchor":"","build_id":107,"column":"confl_snapshot","extraction":"exact-catalog-field","locale":"zh-Hans","page_key":"monitoring-stats.html","source_hash":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","url":"/zh/docs/18/monitoring-stats.html#","version":"18"},"runtime_rerun":false,"source_facts_revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}},"ManualEvidence":{"manual_path":"/docs/18/monitoring-stats.html","release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-DATABASE-CONFLICTS-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_database_conflicts-confl_snapshot","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_database_conflicts.confl_snapshot","Summary":"Number of queries in this database that have been canceled due to old snapshots","BodyHTML":"\u003cp\u003eNumber of queries in this database that have been canceled due to old snapshots\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"7964773e84b089a3d3fcbf8509e0af716e08c9b897f6b513414cb1928c709c60","Payload":{"description":["Number of queries in this database that have been canceled due to old snapshots"],"manual_html":"","related":[{"label":"pg_stat_database_conflicts columns","url":"/wiki/catalog/pg_stat_database_conflicts/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"sections":[{"paragraphs":["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."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT confl_snapshot FROM pg_catalog.pg_stat_database_conflicts;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"tables":[]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}