{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_database_conflicts-stats_reset", "name": "pg_stat_database_conflicts.stats_reset", "name_zh": "", "category": "pg_stat_database_conflicts", "summary": "\u6240\u9009\u7248\u672c\u672a\u6536\u5f55\u6b64\u6761\u76ee\u3002", "aliases": ["stats_reset", "pg_stat_database_conflicts"], "content_hash": "8d93ce5b2b7f48f5bab193896cd275ffa85f16f5c532afde91fad6e799952deb", "versions": {"19": {"view": "pg_stat_database_conflicts", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_database_conflicts"}, {"label": "\u5b57\u6bb5", "value": "stats_reset"}, {"label": "SQL \u7c7b\u578b", "value": "timestamp with time zone"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4e0a\u6b21\u91cd\u7f6e\u7684\u65f6\u95f4"}], "field": "stats_reset", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_database_conflicts/?v=19", "label": "pg_stat_database_conflicts \u5b57\u6bb5"}, {"url": "/docs/19/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/monitoring-stats.html#PG-STAT-DATABASE-CONFLICTS-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "26e1b6632bdf05ebe081987cb60ab4ded526eec7db73e41316fbd69466c494fe", "language": "en", "original_url": "/docs/19/monitoring-stats.html#PG-STAT-DATABASE-CONFLICTS-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_database_conflicts \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u6570\u636e\u5e93\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u6570\u636e\u5e93\u8303\u56f4\u5185\u56e0\u4e0e\u5907\u5e93\u4e0a\u7684\u6062\u590d\u8fc7\u7a0b\u51b2\u7a81\u800c\u88ab\u53d6\u6d88\u7684\u67e5\u8be2\u7edf\u8ba1\u4fe1\u606f\u3002\u8be5\u89c6\u56fe\u53ea\u5305\u542b\u5907\u5e93\u4e0a\u7684\u4fe1\u606f\uff0c\u56e0\u4e3a\u8fd9\u7c7b\u51b2\u7a81\u4e0d\u4f1a\u53d1\u751f\u5728\u4e3b\u5e93\u4e0a\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT stats_reset FROM pg_catalog.pg_stat_database_conflicts;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "timestamp with time zone", "signature": "SELECT stats_reset FROM pg_catalog.pg_stat_database_conflicts;", "documented": true, "description": ["\u8fd9\u4e9b\u7edf\u8ba1\u4e0a\u6b21\u91cd\u7f6e\u7684\u65f6\u95f4"], "manual_html": "", "manual_path": "/docs/19/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/19/monitoring-stats.html", "method": "same-major semantic node", "sha256": "024434288428f15560d48c78af2e836ca669a4217589cfaeb2f16b72123b501a", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[24]/p[2]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Time at which these statistics were last reset", "/versions/19/facts/0/label": "View", "/versions/19/facts/1/label": "Field", "/versions/19/facts/2/label": "SQL type", "/versions/19/facts/3/label": "Units named in the field definition", "/versions/19/facts/3/value": "Not specified", "/versions/19/facts/4/label": "Reset observation", "/versions/19/facts/4/value": "Time at which these statistics were last reset", "/versions/19/related/0/label": "pg_stat_database_conflicts columns", "/versions/19/related/1/label": "Statistics collection and reset functions", "/versions/19/sections/0/title": "View semantics", "/versions/19/sections/1/title": "Collection and reset context", "/versions/19/sections/2/title": "Inspect this field", "/versions/19/sections/0/paragraphs/0": "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.", "/versions/19/sections/1/paragraphs/0": "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.", "/versions/19/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "cb25fdeab3922eb6203ba84bb105cb6a198e75c693048af03c19d963186ac4bf"}, "comparison_data": {"view": "pg_stat_database_conflicts", "field": "stats_reset", "sql_type": "timestamp with time zone", "units_mentioned": []}, "comparison_hash": "b022465dd83d6104996566a3b7bc562e9288d737009c31ebbadb79f5fc435e9c", "units_mentioned": []}, "20": {"view": "pg_stat_database_conflicts", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_database_conflicts"}, {"label": "\u5b57\u6bb5", "value": "stats_reset"}, {"label": "SQL \u7c7b\u578b", "value": "timestamp with time zone"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4e0a\u6b21\u91cd\u7f6e\u7684\u65f6\u95f4"}], "field": "stats_reset", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_database_conflicts/?v=20", "label": "pg_stat_database_conflicts \u5b57\u6bb5"}, {"url": "/docs/devel/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/docs/devel/monitoring-stats.html#PG-STAT-DATABASE-CONFLICTS-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251", "language": "en", "original_url": "/docs/devel/monitoring-stats.html#PG-STAT-DATABASE-CONFLICTS-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_database_conflicts \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u6570\u636e\u5e93\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u6570\u636e\u5e93\u8303\u56f4\u5185\u56e0\u4e0e\u5907\u5e93\u4e0a\u7684\u6062\u590d\u8fc7\u7a0b\u51b2\u7a81\u800c\u88ab\u53d6\u6d88\u7684\u67e5\u8be2\u7edf\u8ba1\u4fe1\u606f\u3002\u8be5\u89c6\u56fe\u53ea\u5305\u542b\u5907\u5e93\u4e0a\u7684\u4fe1\u606f\uff0c\u56e0\u4e3a\u8fd9\u7c7b\u51b2\u7a81\u4e0d\u4f1a\u53d1\u751f\u5728\u4e3b\u5e93\u4e0a\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT stats_reset FROM pg_catalog.pg_stat_database_conflicts;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "timestamp with time zone", "signature": "SELECT stats_reset FROM pg_catalog.pg_stat_database_conflicts;", "documented": true, "description": ["\u8fd9\u4e9b\u7edf\u8ba1\u4e0a\u6b21\u91cd\u7f6e\u7684\u65f6\u95f4"], "manual_html": "", "manual_path": "/docs/devel/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/devel/monitoring-stats.html", "method": "same-major semantic node", "sha256": "1d9a086fb4c6fdd9a56d3a7a28e8c164354ef0bf50c402f06ebe174538f96a4f", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[25]/p[2]"]}], "language": "zh", "original_text": {"/summary": "Time at which these statistics were last reset", "/versions/20/description/0": "Time at which these statistics were last reset", "/versions/20/facts/0/label": "View", "/versions/20/facts/1/label": "Field", "/versions/20/facts/2/label": "SQL type", "/versions/20/facts/3/label": "Units named in the field definition", "/versions/20/facts/3/value": "Not specified", "/versions/20/facts/4/label": "Reset observation", "/versions/20/facts/4/value": "Time at which these statistics were last reset", "/versions/20/related/0/label": "pg_stat_database_conflicts columns", "/versions/20/related/1/label": "Statistics collection and reset functions", "/versions/20/sections/0/title": "View semantics", "/versions/20/sections/1/title": "Collection and reset context", "/versions/20/sections/2/title": "Inspect this field", "/versions/20/sections/0/paragraphs/0": "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.", "/versions/20/sections/1/paragraphs/0": "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.", "/versions/20/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d93a3390c4ac2a34cdae58b2ded9085ef544426b102aee196568b2095502db13"}, "comparison_data": {"view": "pg_stat_database_conflicts", "field": "stats_reset", "sql_type": "timestamp with time zone", "units_mentioned": []}, "comparison_hash": "b022465dd83d6104996566a3b7bc562e9288d737009c31ebbadb79f5fc435e9c", "units_mentioned": []}}}, "snapshot": null, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}