{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_wal_receiver-received_lsn", "name": "pg_stat_wal_receiver.received_lsn", "name_zh": "", "category": "pg_stat_wal_receiver", "summary": "\u6240\u9009\u7248\u672c\u672a\u6536\u5f55\u6b64\u6761\u76ee\u3002", "aliases": ["received_lsn", "pg_stat_wal_receiver"], "content_hash": "989a2645e903f4f15d20047abbeefdf49ec0c251e650834b579cb8490f026c76", "versions": {"10": {"view": "pg_stat_wal_receiver", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_wal_receiver"}, {"label": "\u5b57\u6bb5", "value": "received_lsn"}, {"label": "SQL \u7c7b\u578b", "value": "pg_lsn"}, {"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": "received_lsn", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_wal_receiver/?v=10", "label": "pg_stat_wal_receiver \u5b57\u6bb5"}, {"url": "/docs/10/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "10.23", "major": "10", "channel": "stable", "revision": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "sources": [{"url": "https://pg.center/docs/10/monitoring-stats.html#PG-STAT-WAL-RECEIVER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 10 English manual", "sha256": "8b88457ddc21d8cbc59bc88fb9e07a79090419ef77c3d7f05b03e0f66a2bac3f", "language": "en", "original_url": "/docs/10/monitoring-stats.html#PG-STAT-WAL-RECEIVER-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u53ea\u6709\u4e00\u884c\uff0c\u663e\u793a WAL \u63a5\u6536\u8fdb\u7a0b\u4ece\u5176\u6240\u8fde\u63a5\u670d\u52a1\u5668\u63a5\u6536\u6570\u636e\u7684\u7edf\u8ba1\u4fe1\u606f\u3002\u8be6\u89c1 pg_stat_wal_receiver \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 received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "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": "pg_lsn", "signature": "SELECT received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "documented": true, "description": ["\u5df2\u7ecf\u63a5\u6536\u5e76\u5237\u5165\u5230\u78c1\u76d8\u7684\u6700\u540e\u4e00\u4e2a\u9884\u5199\u5f0f\u65e5\u5fd7\u4f4d\u7f6e\uff0c\u8be5\u5b57\u6bb5\u7684\u521d\u59cb\u503c\u662f\u542f\u52a8 WAL \u63a5\u6536\u8fdb\u7a0b\u65f6\u4f7f\u7528\u7684\u7b2c\u4e00\u4e2a\u65e5\u5fd7\u4f4d\u7f6e"], "manual_html": "", "manual_path": "/docs/10/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/10/monitoring-stats.html", "method": "same-major semantic node", "sha256": "881c50196a1774b6cbfd40977523b79f34cd079195f91024d1e3c322c763a8b5", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[6]/div[26]/div[1]/table[0]/tbody[2]/tr[4]/td[2]", "#MONITORING-STATS/div[6]/div[5]/div[1]/table[0]/tbody[2]/tr[2]/td[1]"]}], "language": "zh", "original_text": {"/versions/10/description/0": "Last write-ahead log location already received and flushed to disk, the initial value of this field being the first log location used when WAL receiver is started", "/versions/10/facts/0/label": "View", "/versions/10/facts/1/label": "Field", "/versions/10/facts/2/label": "SQL type", "/versions/10/facts/3/label": "Units named in the field definition", "/versions/10/facts/3/value": "Not specified", "/versions/10/facts/4/label": "Reset observation", "/versions/10/facts/4/value": "No stats_reset field is documented for this view", "/versions/10/related/0/label": "pg_stat_wal_receiver columns", "/versions/10/related/1/label": "Statistics collection and reset functions", "/versions/10/sections/0/title": "View semantics", "/versions/10/sections/1/title": "Collection and reset context", "/versions/10/sections/2/title": "Inspect this field", "/versions/10/sections/0/paragraphs/0": "Only one row, showing statistics about the WAL receiver from that receiver's connected server. See pg_stat_wal_receiver for details.", "/versions/10/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/10/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "a1f45700a728de7fa975a0423bb3f0f0893bb93c3a89c51aa4cb48b07549d2df"}, "comparison_data": {"view": "pg_stat_wal_receiver", "field": "received_lsn", "sql_type": "pg_lsn", "units_mentioned": []}, "comparison_hash": "5a3010b2bd8af1f4020a369cfa63c62e18125bc5d97f22db0618f5127875dcbd", "units_mentioned": []}, "11": {"view": "pg_stat_wal_receiver", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_wal_receiver"}, {"label": "\u5b57\u6bb5", "value": "received_lsn"}, {"label": "SQL \u7c7b\u578b", "value": "pg_lsn"}, {"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": "received_lsn", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_wal_receiver/?v=11", "label": "pg_stat_wal_receiver \u5b57\u6bb5"}, {"url": "/docs/11/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "11.22", "major": "11", "channel": "stable", "revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "sources": [{"url": "https://pg.center/docs/11/monitoring-stats.html#PG-STAT-WAL-RECEIVER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 11 English manual", "sha256": "8b7b421aabe5ecaae695cb42a270d7192bfe2bfbd1ac2aa756087c177f734600", "language": "en", "original_url": "/docs/11/monitoring-stats.html#PG-STAT-WAL-RECEIVER-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u53ea\u6709\u4e00\u884c\uff0c\u663e\u793a WAL \u63a5\u6536\u8fdb\u7a0b\u4ece\u5176\u6240\u8fde\u63a5\u670d\u52a1\u5668\u63a5\u6536\u6570\u636e\u7684\u7edf\u8ba1\u4fe1\u606f\u3002\u8be6\u89c1 pg_stat_wal_receiver \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 received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "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": "pg_lsn", "signature": "SELECT received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "documented": true, "description": ["\u5df2\u7ecf\u63a5\u6536\u5e76\u5237\u5165\u5230\u78c1\u76d8\u7684\u6700\u540e\u4e00\u4e2a\u9884\u5199\u5f0f\u65e5\u5fd7\u4f4d\u7f6e\uff0c\u8be5\u5b57\u6bb5\u7684\u521d\u59cb\u503c\u662f\u542f\u52a8 WAL \u63a5\u6536\u8fdb\u7a0b\u65f6\u4f7f\u7528\u7684\u7b2c\u4e00\u4e2a\u65e5\u5fd7\u4f4d\u7f6e"], "manual_html": "", "manual_path": "/docs/11/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/11/monitoring-stats.html", "method": "same-major semantic node", "sha256": "0f94440120a340dbcbbfec4d9fd6ea8ad93b9671f759fe80a4f373ba248c864e", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[6]/div[26]/div[1]/table[0]/tbody[2]/tr[4]/td[2]", "#MONITORING-STATS/div[6]/div[5]/div[1]/table[0]/tbody[2]/tr[2]/td[1]"]}], "language": "zh", "original_text": {"/versions/11/description/0": "Last write-ahead log location already received and flushed to disk, the initial value of this field being the first log location used when WAL receiver is started", "/versions/11/facts/0/label": "View", "/versions/11/facts/1/label": "Field", "/versions/11/facts/2/label": "SQL type", "/versions/11/facts/3/label": "Units named in the field definition", "/versions/11/facts/3/value": "Not specified", "/versions/11/facts/4/label": "Reset observation", "/versions/11/facts/4/value": "No stats_reset field is documented for this view", "/versions/11/related/0/label": "pg_stat_wal_receiver columns", "/versions/11/related/1/label": "Statistics collection and reset functions", "/versions/11/sections/0/title": "View semantics", "/versions/11/sections/1/title": "Collection and reset context", "/versions/11/sections/2/title": "Inspect this field", "/versions/11/sections/0/paragraphs/0": "Only one row, showing statistics about the WAL receiver from that receiver's connected server. See pg_stat_wal_receiver for details.", "/versions/11/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/11/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "0acc89c0468ef5c3cfb0e0eda078312cc99fcc57aacb6b0291198421cf6dd8be"}, "comparison_data": {"view": "pg_stat_wal_receiver", "field": "received_lsn", "sql_type": "pg_lsn", "units_mentioned": []}, "comparison_hash": "5a3010b2bd8af1f4020a369cfa63c62e18125bc5d97f22db0618f5127875dcbd", "units_mentioned": []}, "12": {"view": "pg_stat_wal_receiver", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_wal_receiver"}, {"label": "\u5b57\u6bb5", "value": "received_lsn"}, {"label": "SQL \u7c7b\u578b", "value": "pg_lsn"}, {"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": "received_lsn", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_wal_receiver/?v=12", "label": "pg_stat_wal_receiver \u5b57\u6bb5"}, {"url": "/docs/12/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "stable", "revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "sources": [{"url": "https://pg.center/docs/12/monitoring-stats.html#PG-STAT-WAL-RECEIVER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 12 English manual", "sha256": "3a764eaa784efc0eed1081cdfc2bf313c91bd17122d66dd16055d8b640320699", "language": "en", "original_url": "/docs/12/monitoring-stats.html#PG-STAT-WAL-RECEIVER-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u53ea\u6709\u4e00\u884c\uff0c\u663e\u793a WAL \u63a5\u6536\u8fdb\u7a0b\u4ece\u5176\u6240\u8fde\u63a5\u670d\u52a1\u5668\u63a5\u6536\u6570\u636e\u7684\u7edf\u8ba1\u4fe1\u606f\u3002\u8be6\u89c1 pg_stat_wal_receiver \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 received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "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": "pg_lsn", "signature": "SELECT received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "documented": true, "description": ["\u5df2\u7ecf\u63a5\u6536\u5e76\u5237\u5165\u5230\u78c1\u76d8\u7684\u6700\u540e\u4e00\u4e2a\u9884\u5199\u5f0f\u65e5\u5fd7\u4f4d\u7f6e\uff0c\u8be5\u5b57\u6bb5\u7684\u521d\u59cb\u503c\u662f\u542f\u52a8 WAL \u63a5\u6536\u8fdb\u7a0b\u65f6\u4f7f\u7528\u7684\u7b2c\u4e00\u4e2a\u65e5\u5fd7\u4f4d\u7f6e"], "manual_html": "", "manual_path": "/docs/12/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/12/monitoring-stats.html", "method": "same-major semantic node", "sha256": "d9fccd3a149dcb1b042346f59f216885cbd5a1cef552dae403a74da45af66cd0", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[6]/div[27]/div[1]/table[0]/tbody[2]/tr[4]/td[2]", "#MONITORING-STATS/div[6]/div[6]/div[1]/table[0]/tbody[2]/tr[2]/td[1]"]}], "language": "zh", "original_text": {"/summary": "Last write-ahead log location already received and flushed to disk, the initial value of this field being the first log location used when WAL receiver is started", "/versions/12/description/0": "Last write-ahead log location already received and flushed to disk, the initial value of this field being the first log location used when WAL receiver is started", "/versions/12/facts/0/label": "View", "/versions/12/facts/1/label": "Field", "/versions/12/facts/2/label": "SQL type", "/versions/12/facts/3/label": "Units named in the field definition", "/versions/12/facts/3/value": "Not specified", "/versions/12/facts/4/label": "Reset observation", "/versions/12/facts/4/value": "No stats_reset field is documented for this view", "/versions/12/related/0/label": "pg_stat_wal_receiver columns", "/versions/12/related/1/label": "Statistics collection and reset functions", "/versions/12/sections/0/title": "View semantics", "/versions/12/sections/1/title": "Collection and reset context", "/versions/12/sections/2/title": "Inspect this field", "/versions/12/sections/0/paragraphs/0": "Only one row, showing statistics about the WAL receiver from that receiver's connected server. See pg_stat_wal_receiver for details.", "/versions/12/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/12/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "27fd79f064769e3d51eaef254b24b90b322c9fd421d67ec9b19f197cf1815932"}, "comparison_data": {"view": "pg_stat_wal_receiver", "field": "received_lsn", "sql_type": "pg_lsn", "units_mentioned": []}, "comparison_hash": "5a3010b2bd8af1f4020a369cfa63c62e18125bc5d97f22db0618f5127875dcbd", "units_mentioned": []}}}, "snapshot": null, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}