{"Entry":{"collection":"func","key":"pg-log-standby-snapshot","name":"pg_log_standby_snapshot","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"15","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"16"}],"content_hash":"47c5fb37f4fabb5f61632b8b3e0d52810435cc16d8f5dd6cd28b38fea8107802","first_version":"16","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.551105+08:00","last_version":"20","name":"pg_log_standby_snapshot","name_key":"pg_log_standby_snapshot","position":29055,"present_in":["16","17","18","19","20"],"signature":"pg_log_standby_snapshot () → pg_lsn","signature_count":1,"slug":"pg-log-standby-snapshot","source_rev":"b7bd9cda","summary":"Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-log-standby-snapshot","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-log-standby-snapshot","SourceRevision":"b7bd9cda","Facts":{"description":"Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one. This is useful for logical decoding on standby, as logical slot creation has to wait until such a record is replayed on the standby.","description_html":"Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one. This is useful for logical decoding on standby, as logical slot creation has to wait until such a record is replayed on the standby.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-SNAPSHOT-SYNCHRONIZATION-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":"Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one. This is useful for logical decoding on standby, as logical slot creation has to wait until such a record is replayed on the standby.","description_html":"Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one. This is useful for logical decoding on standby, as logical slot creation has to wait until such a record is replayed on the standby.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_log_standby_snapshot\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_log_standby_snapshot () → pg_lsn","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-SNAPSHOT-SYNCHRONIZATION-TABLE","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-log-standby-snapshot","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_log_standby_snapshot","Summary":"为进行中的事务拍摄快照并将其写入 WAL，无须等待后台写入器或检查点进程记录快照。这对备用服务器上的逻辑解码很有用，因为创建逻辑复制槽必须等待此类记录在备用服务器上重放。","BodyHTML":"为进行中的事务拍摄快照并将其写入 WAL，无须等待后台写入器或检查点进程记录快照。这对备用服务器上的逻辑解码很有用，因为创建逻辑复制槽必须等待此类记录在备用服务器上重放。\u003cpre\u003epg_log_standby_snapshot () → pg_lsn\u003c/pre\u003e为进行中的事务拍摄快照并将其写入 WAL，无须等待后台写入器或检查点进程记录快照。这对备用服务器上的逻辑解码很有用，因为创建逻辑复制槽必须等待此类记录在备用服务器上重放。","SourceRevision":"ca936764","ContentHash":"52281fe042220f8da7ea45172587e4ca6a7c4854d6d78ae4aa3c18de174a8bcf","Payload":{"description_zh":"为进行中的事务拍摄快照并将其写入 WAL，无须等待后台写入器或检查点进程记录快照。这对备用服务器上的逻辑解码很有用，因为创建逻辑复制槽必须等待此类记录在备用服务器上重放。","description_zh_html":"为进行中的事务拍摄快照并将其写入 WAL，无须等待后台写入器或检查点进程记录快照。这对备用服务器上的逻辑解码很有用，因为创建逻辑复制槽必须等待此类记录在备用服务器上重放。","signatures":[{"description_zh":"为进行中的事务拍摄快照并将其写入 WAL，无须等待后台写入器或检查点进程记录快照。这对备用服务器上的逻辑解码很有用，因为创建逻辑复制槽必须等待此类记录在备用服务器上重放。","description_zh_html":"为进行中的事务拍摄快照并将其写入 WAL，无须等待后台写入器或检查点进程记录快照。这对备用服务器上的逻辑解码很有用，因为创建逻辑复制槽必须等待此类记录在备用服务器上重放。","returns":"pg_lsn","text":"pg_log_standby_snapshot () → pg_lsn","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"e844ca1276b831f708f9c68c691f5dfb4ed5b8f9b7815176fbd9dc96351a742c","Text":"pg_log_standby_snapshot () → pg_lsn","Returns":"pg_lsn","Payload":{"description":"Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one. This is useful for logical decoding on standby, as logical slot creation has to wait until such a record is replayed on the standby.","description_html":"Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one. This is useful for logical decoding on standby, as logical slot creation has to wait until such a record is replayed on the standby.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_log_standby_snapshot\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_log_standby_snapshot () → pg_lsn","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}