pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\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", "version": "10", "link_map": {"/zh/docs/10/monitoring-stats.html": "/docs/10/monitoring-stats.html"}, "body_html": "pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "bea3369ed7fb63d499b005055ba62bc9ce333f26e728dac8b4488f995258cf80", "content_hash": "66b799b6fe20c276e0b204c7a8af3d2d5838c7c448d26d23a39aa40b47453264", "source_database": "center", "source_revision": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "signature": "SELECT received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "tables_zh": [], "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", "sections_zh": [{"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"]}], "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", "canonical_center_text_hash": "66b799b6fe20c276e0b204c7a8af3d2d5838c7c448d26d23a39aa40b47453264"}, "description_zh": "\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", "comparison_data": {"view": "pg_stat_wal_receiver", "field": "received_lsn", "sql_type": "pg_lsn", "units_mentioned": []}, "comparison_hash": "5a3010b2bd8af1f4020a369cfa63c62e18125bc5d97f22db0618f5127875dcbd", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "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": "/docs/11/monitoring-stats.html#PG-STAT-WAL-RECEIVER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 11 English manual", "sha256": "8b7b421aabe5ecaae695cb42a270d7192bfe2bfbd1ac2aa756087c177f734600"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/11/monitoring-stats.html#", "anchor": "", "column": "received_lsn", "locale": "zh-Hans", "version": "11", "build_id": 64, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "2bd0ab0ada5d4a95c80dd511d5018532613c2753b6c2debc208355ba0cf80625", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "snapshot:sha256:ef5c7bc074acae9795db16e6b7482aea3b222bd4bcce0f76831332b97a21e8a1"}, "body_sha256": "e864bbdca8e60c3c96a44bb6573c8d70f774e46c7d27b4af7cc736815bf42b35", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "facts_zh": [{"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"}], "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", "center_zh": {"title": "pg_stat_wal_receiver.received_lsn", "locale": "zh-Hans", "source": {"key": "pg_stat_wal_receiver-received_lsn", "locale": "zh-Hans", "version": "11", "text_hash": "91d5fb4d8d5233af2c9dbcb2321b3c4ff9ae17f6c4dbaa07edf94ed04877241a", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "payload": {"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"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/11/monitoring-stats.html#", "anchor": "", "column": "received_lsn", "locale": "zh-Hans", "version": "11", "build_id": 64, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "2bd0ab0ada5d4a95c80dd511d5018532613c2753b6c2debc208355ba0cf80625", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "snapshot:sha256:ef5c7bc074acae9795db16e6b7482aea3b222bd4bcce0f76831332b97a21e8a1"}, "body_sha256": "e864bbdca8e60c3c96a44bb6573c8d70f774e46c7d27b4af7cc736815bf42b35", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "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"]}], "description_zh": "\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", "description_zh_html": "pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\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", "version": "11", "link_map": {"/zh/docs/11/monitoring-stats.html": "/docs/11/monitoring-stats.html"}, "body_html": "pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "1bedacc09f36d0f6c39e4347651443ff5b8355ab6b1064542a3711e0beefe511", "content_hash": "91d5fb4d8d5233af2c9dbcb2321b3c4ff9ae17f6c4dbaa07edf94ed04877241a", "source_database": "center", "source_revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "signature": "SELECT received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "tables_zh": [], "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", "sections_zh": [{"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"]}], "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", "canonical_center_text_hash": "91d5fb4d8d5233af2c9dbcb2321b3c4ff9ae17f6c4dbaa07edf94ed04877241a"}, "description_zh": "\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", "comparison_data": {"view": "pg_stat_wal_receiver", "field": "received_lsn", "sql_type": "pg_lsn", "units_mentioned": []}, "comparison_hash": "5a3010b2bd8af1f4020a369cfa63c62e18125bc5d97f22db0618f5127875dcbd", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "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": "/docs/12/monitoring-stats.html#PG-STAT-WAL-RECEIVER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 12 English manual", "sha256": "3a764eaa784efc0eed1081cdfc2bf313c91bd17122d66dd16055d8b640320699"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/12/monitoring-stats.html#", "anchor": "", "column": "received_lsn", "locale": "zh-Hans", "version": "12", "build_id": 65, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "1807d9852353a1af2b64d546fb3be93143b4831734c8d432737488e3037ac9f1", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "snapshot:sha256:86d2ff781f93e1de17122ebc514d5e64fcb63fed15941f496d7e146c6dcc7a49"}, "body_sha256": "25d198148b615001b403ed03a3a27c41a315cb2e5675ee77f80157208426bad0", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "facts_zh": [{"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"}], "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", "center_zh": {"title": "pg_stat_wal_receiver.received_lsn", "locale": "zh-Hans", "source": {"key": "pg_stat_wal_receiver-received_lsn", "locale": "zh-Hans", "version": "12", "text_hash": "abc639fc54ffbcf59010bec4495cd2ff59e8db717ae42cbaa8eb6f646bd3f34f", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "payload": {"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"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/12/monitoring-stats.html#", "anchor": "", "column": "received_lsn", "locale": "zh-Hans", "version": "12", "build_id": 65, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "1807d9852353a1af2b64d546fb3be93143b4831734c8d432737488e3037ac9f1", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "snapshot:sha256:86d2ff781f93e1de17122ebc514d5e64fcb63fed15941f496d7e146c6dcc7a49"}, "body_sha256": "25d198148b615001b403ed03a3a27c41a315cb2e5675ee77f80157208426bad0", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "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"]}], "description_zh": "\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", "description_zh_html": "pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\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", "version": "12", "link_map": {"/zh/docs/12/monitoring-stats.html": "/docs/12/monitoring-stats.html"}, "body_html": "pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "ef3a0dbd05654b854fcf54c5a798e01b4bdca82cb341aacbd13e46756d0fb536", "content_hash": "abc639fc54ffbcf59010bec4495cd2ff59e8db717ae42cbaa8eb6f646bd3f34f", "source_database": "center", "source_revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "signature": "SELECT received_lsn FROM pg_catalog.pg_stat_wal_receiver;", "tables_zh": [], "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", "sections_zh": [{"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"]}], "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", "canonical_center_text_hash": "abc639fc54ffbcf59010bec4495cd2ff59e8db717ae42cbaa8eb6f646bd3f34f"}, "description_zh": "\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", "comparison_data": {"view": "pg_stat_wal_receiver", "field": "received_lsn", "sql_type": "pg_lsn", "units_mentioned": []}, "comparison_hash": "5a3010b2bd8af1f4020a369cfa63c62e18125bc5d97f22db0618f5127875dcbd", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_wal_receiver.received_lsn \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_wal_receiverreceived_lsnpg_lsn\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
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}}}, "snapshot": null, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}