{"Entry":{"collection":"func","key":"pg-last-wal-receive-lsn","name":"pg_last_wal_receive_lsn","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.6","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"10"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"e83543f989bcacefa549be6d75117fea0fb605f46248a32a695ae86ea32adcfa","first_version":"10","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.535081+08:00","last_version":"20","name":"pg_last_wal_receive_lsn","name_key":"pg_last_wal_receive_lsn","position":29049,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_last_wal_receive_lsn () → pg_lsn","signature_count":1,"slug":"pg-last-wal-receive-lsn","source_rev":"b7bd9cda","summary":"Returns the last write-ahead log location that has been received and synced to disk by streaming replication.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-last-wal-receive-lsn","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-last-wal-receive-lsn","SourceRevision":"b7bd9cda","Facts":{"description":"Returns the last write-ahead log location that has been received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed then this will remain static at the location of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_html":"Returns the last write-ahead log location that has been received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed then this will remain static at the location of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-RECOVERY-INFO-TABLE","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Returns the last write-ahead log location that has been received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed then this will remain static at the location of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_html":"Returns the last write-ahead log location that has been received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed then this will remain static at the location of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_last_wal_receive_lsn\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_last_wal_receive_lsn () → pg_lsn","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-RECOVERY-INFO-TABLE","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-last-wal-receive-lsn","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_last_wal_receive_lsn","Summary":"返回流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","BodyHTML":"返回流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 \u003ccode\u003eNULL\u003c/code\u003e。\u003cpre\u003epg_last_wal_receive_lsn () → pg_lsn\u003c/pre\u003e返回流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 \u003ccode\u003eNULL\u003c/code\u003e。","SourceRevision":"ca936764","ContentHash":"0c832dca1215dccb7243c2a496e8dba6baabcb334fc4834ce95826286e42e14d","Payload":{"description_zh":"返回流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","description_zh_html":"返回流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","signatures":[{"description_zh":"返回流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","description_zh_html":"返回流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","returns":"pg_lsn","text":"pg_last_wal_receive_lsn () → pg_lsn","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"6a9ae4a344020b0d4274fc1b4d18adf2a647250e9b758e6195a3f3b7116672ca","Text":"pg_last_wal_receive_lsn () → pg_lsn","Returns":"pg_lsn","Payload":{"description":"Returns the last write-ahead log location that has been received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed then this will remain static at the location of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_html":"Returns the last write-ahead log location that has been received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed then this will remain static at the location of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_last_wal_receive_lsn\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_last_wal_receive_lsn () → pg_lsn","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}