{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_recovery-replay_end_tli", "name": "pg_stat_recovery.replay_end_tli", "name_zh": "", "category": "pg_stat_recovery", "summary": "\u6240\u9009\u7248\u672c\u672a\u6536\u5f55\u6b64\u6761\u76ee\u3002", "aliases": ["replay_end_tli", "pg_stat_recovery"], "content_hash": "4d6828501fbb61ba484965242b64257bc26f2d099f2d1bbd29ab7908b8806d13", "versions": {"19": {"view": "pg_stat_recovery", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_recovery"}, {"label": "\u5b57\u6bb5", "value": "replay_end_tli"}, {"label": "SQL \u7c7b\u578b", "value": "integer"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "replay_end_tli", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_recovery/?v=19", "label": "pg_stat_recovery \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-RECOVERY-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "26e1b6632bdf05ebe081987cb60ab4ded526eec7db73e41316fbd69466c494fe", "language": "en", "original_url": "/docs/19/monitoring-stats.html#PG-STAT-RECOVERY-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_recovery \u89c6\u56fe\u81f3\u591a\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u542f\u52a8\u8fdb\u7a0b\u7684\u6062\u590d\u72b6\u6001\u7edf\u8ba1\u4fe1\u606f\u3002\u5f53\u670d\u52a1\u5668\u4e0d\u5904\u4e8e\u6062\u590d\u72b6\u6001\uff0c\u6216\u8005\u7528\u6237\u6ca1\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\u65f6\uff0c\u8fd9\u4e2a\u89c6\u56fe\u4e0d\u8fd4\u56de\u4efb\u4f55\u884c\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 replay_end_tli FROM pg_catalog.pg_stat_recovery;", "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": "integer", "signature": "SELECT replay_end_tli FROM pg_catalog.pg_stat_recovery;", "documented": true, "description": ["\u5f53\u524d\u6b63\u5728\u91cd\u653e\u7684 WAL \u8bb0\u5f55\u7684\u65f6\u95f4\u7ebf\u3002\u5f53\u524d\u6ca1\u6709\u91cd\u653e\u8bb0\u5f55\u65f6\uff0c\u7b49\u4e8e last_replayed_tli\u3002"], "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[11]/p[2]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Timeline of the WAL record currently being replayed. When no record is being actively replayed, equals last_replayed_tli.", "/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": "No stats_reset field is documented for this view", "/versions/19/related/0/label": "pg_stat_recovery 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_recovery view will contain at most one row, showing statistics about the recovery state of the startup process. This view returns no rows when the server is not in recovery or the user does not have privileges of the pg_read_all_stats role.", "/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": "746bda0a92280ba25e2032a5d63e9784b37f005c03d5cc26cdc953c639ec3680"}, "comparison_data": {"view": "pg_stat_recovery", "field": "replay_end_tli", "sql_type": "integer", "units_mentioned": []}, "comparison_hash": "3a72036de2136bb8f9a08fbe30479605cc5eaea2658256bbba4785cb19056ca6", "units_mentioned": []}, "20": {"view": "pg_stat_recovery", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_recovery"}, {"label": "\u5b57\u6bb5", "value": "replay_end_tli"}, {"label": "SQL \u7c7b\u578b", "value": "integer"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "replay_end_tli", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_recovery/?v=20", "label": "pg_stat_recovery \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-RECOVERY-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251", "language": "en", "original_url": "/docs/devel/monitoring-stats.html#PG-STAT-RECOVERY-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_recovery \u89c6\u56fe\u81f3\u591a\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u542f\u52a8\u8fdb\u7a0b\u7684\u6062\u590d\u72b6\u6001\u7edf\u8ba1\u4fe1\u606f\u3002\u5f53\u670d\u52a1\u5668\u4e0d\u5904\u4e8e\u6062\u590d\u72b6\u6001\uff0c\u6216\u8005\u7528\u6237\u6ca1\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\u65f6\uff0c\u8fd9\u4e2a\u89c6\u56fe\u4e0d\u8fd4\u56de\u4efb\u4f55\u884c\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 replay_end_tli FROM pg_catalog.pg_stat_recovery;", "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": "integer", "signature": "SELECT replay_end_tli FROM pg_catalog.pg_stat_recovery;", "documented": true, "description": ["\u5f53\u524d\u6b63\u5728\u91cd\u653e\u7684 WAL \u8bb0\u5f55\u7684\u65f6\u95f4\u7ebf\u3002\u5f53\u524d\u6ca1\u6709\u91cd\u653e\u8bb0\u5f55\u65f6\uff0c\u7b49\u4e8e last_replayed_tli\u3002"], "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[11]/p[2]"]}], "language": "zh", "original_text": {"/summary": "Timeline of the WAL record currently being replayed. When no record is being actively replayed, equals last_replayed_tli.", "/versions/20/description/0": "Timeline of the WAL record currently being replayed. When no record is being actively replayed, equals last_replayed_tli.", "/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": "No stats_reset field is documented for this view", "/versions/20/related/0/label": "pg_stat_recovery 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_recovery view will contain at most one row, showing statistics about the recovery state of the startup process. This view returns no rows when the server is not in recovery or the user does not have privileges of the pg_read_all_stats role.", "/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": "39cd12c0d6603029c16ffa4c57568217c990e6ab3012eeaa6f2fee51e9acf684"}, "comparison_data": {"view": "pg_stat_recovery", "field": "replay_end_tli", "sql_type": "integer", "units_mentioned": []}, "comparison_hash": "3a72036de2136bb8f9a08fbe30479605cc5eaea2658256bbba4785cb19056ca6", "units_mentioned": []}}}, "snapshot": null, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}