{"Entry":{"collection":"catalog","key":"pg_stat_wal_receiver","name":"pg_stat_wal_receiver","aliases":[],"metadata":{"changed_in":["11","13"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.5","order":false,"removed":[],"status":"added","to":"9.6","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Last transaction log position reported to origin WAL sender","name":"latest_end_lsn","to":"Last write-ahead log location reported to origin WAL sender"},{"from":"Time of last transaction log position reported to origin WAL sender","name":"latest_end_time","to":"Time of last write-ahead log location reported to origin WAL sender"},{"from":"First transaction log position used when WAL receiver is started","name":"receive_start_lsn","to":"First write-ahead log location used when WAL receiver is started"},{"from":"Last transaction log position already received and flushed to disk, the initial value of this field being the first log position used when WAL receiver is started","name":"received_lsn","to":"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"},{"from":"Timeline number of last transaction log position received and flushed to disk, the initial value of this field being the timeline number of the first log position used when WAL receiver is started","name":"received_tli","to":"Timeline number of last write-ahead log location received and flushed to disk, the initial value of this field being the timeline number of the first log location used when WAL receiver is started"}],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]},{"added":["sender_host","sender_port"],"attributes":[],"description_changed":false,"descriptions":[],"from":"10","listing":[],"order":false,"removed":[],"status":"changed","to":"11","types":[],"unlisted":[]},{"added":["written_lsn","flushed_lsn"],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":["received_lsn"],"status":"changed","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Activity status of the WAL receiver process","name":"status","to":"Activity status of the WAL receiver process. Possible values are:\n\nrestarting: WAL receiver has been asked to restart streaming. starting: WAL receiver process has been launched but is not yet initialized. connecting: WAL receiver is connecting to the upstream server, replication has not yet started. stopping: WAL receiver has been requested to stop. streaming: WAL receiver is streaming WAL data. waiting: WAL receiver has stopped streaming and is waiting for new instructions from the startup process."}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":15,"content_hash":"50ad84f5e06a5f8f462ed04069d81833eb3244c083f678d831948d08e549d0e6","first_version":"9.6","imported_at":"2026-09-30T00:40:56.045811+08:00","kind":"statistics","last_version":"20","name":"pg_stat_wal_receiver","position":116,"present_in":["9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:2e548531e119e4038de1abbbf051a9065492b4f546d89b0a667fd7115230008f","summary":"The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_wal_receiver","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_wal_receiver","SourceRevision":"english-manuals:2e548531e119e4038de1abbbf051a9065492b4f546d89b0a667fd7115230008f","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of the WAL receiver process","description_zh":"","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":2,"description":"Activity status of the WAL receiver process","description_zh":"","documented":true,"documented_name":"status","hidden":false,"name":"status","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":3,"description":"First write-ahead log location used when WAL receiver is started","description_zh":"","documented":true,"documented_name":"receive_start_lsn","hidden":false,"name":"receive_start_lsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220},{"array_dimensions":0,"attnum":4,"description":"First timeline number used when WAL receiver is started","description_zh":"","documented":true,"documented_name":"receive_start_tli","hidden":false,"name":"receive_start_tli","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":5,"description":"Last write-ahead log location already received and written to disk, but not flushed. This should not be used for data integrity checks.","description_zh":"","documented":true,"documented_name":"written_lsn","hidden":false,"name":"written_lsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220},{"array_dimensions":0,"attnum":6,"description":"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","description_zh":"","documented":true,"documented_name":"flushed_lsn","hidden":false,"name":"flushed_lsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220},{"array_dimensions":0,"attnum":7,"description":"Timeline number of last write-ahead log location received and flushed to disk, the initial value of this field being the timeline number of the first log location used when WAL receiver is started","description_zh":"","documented":true,"documented_name":"received_tli","hidden":false,"name":"received_tli","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":8,"description":"Send time of last message received from origin WAL sender","description_zh":"","documented":true,"documented_name":"last_msg_send_time","hidden":false,"name":"last_msg_send_time","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184},{"array_dimensions":0,"attnum":9,"description":"Receipt time of last message received from origin WAL sender","description_zh":"","documented":true,"documented_name":"last_msg_receipt_time","hidden":false,"name":"last_msg_receipt_time","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184},{"array_dimensions":0,"attnum":10,"description":"Last write-ahead log location reported to origin WAL sender","description_zh":"","documented":true,"documented_name":"latest_end_lsn","hidden":false,"name":"latest_end_lsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220},{"array_dimensions":0,"attnum":11,"description":"Time of last write-ahead log location reported to origin WAL sender","description_zh":"","documented":true,"documented_name":"latest_end_time","hidden":false,"name":"latest_end_time","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184},{"array_dimensions":0,"attnum":12,"description":"Replication slot name used by this WAL receiver","description_zh":"","documented":true,"documented_name":"slot_name","hidden":false,"name":"slot_name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":13,"description":"Host of the PostgreSQL instance this WAL receiver is connected to. This can be a host name, an IP address, or a directory path if the connection is via Unix socket. (The path case can be distinguished because it will always be an absolute path, beginning with /.)","description_zh":"","documented":true,"documented_name":"sender_host","hidden":false,"name":"sender_host","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":14,"description":"Port number of the PostgreSQL instance this WAL receiver is connected to.","description_zh":"","documented":true,"documented_name":"sender_port","hidden":false,"name":"sender_port","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":15,"description":"Connection string used by this WAL receiver, with security-sensitive fields obfuscated.","description_zh":"","documented":true,"documented_name":"conninfo","hidden":false,"name":"conninfo","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25}],"description":"The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server.","description_zh":"","doc":{"anchor":"PG-STAT-WAL-RECEIVER-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","status","receive_start_lsn","receive_start_tli","written_lsn","flushed_lsn","received_tli","last_msg_send_time","last_msg_receipt_time","latest_end_lsn","latest_end_time","slot_name","sender_host","sender_port","conninfo"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-WAL-RECEIVER-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","status","receive_start_lsn","receive_start_tli","written_lsn","flushed_lsn","received_tli","last_msg_send_time","last_msg_receipt_time","latest_end_lsn","latest_end_time","slot_name","sender_host","sender_port","conninfo"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_wal_receiver","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_wal_receiver","Summary":"pg_stat_wal_receiver视图只包含一行，显示 WAL 接收进程从其所连接服务器接收数据的统计信息。","BodyHTML":"\u003cp\u003epg_stat_wal_receiver视图只包含一行，显示 WAL 接收进程从其所连接服务器接收数据的统计信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"50d13ca98ce760a525b01949578ba3fefa41192291f9955784a5ee6547bc4edb","Payload":{"columns":[{"description_zh":"WAL 接收进程的进程 ID","name":"pid","type":"integer","zh_from":"doc"},{"description_zh":"WAL 接收进程的活动状态","name":"status","type":"text","zh_from":"doc"},{"description_zh":"WAL 接收进程启动时使用的第一个预写式日志位置","name":"receive_start_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"WAL 接收进程启动时使用的第一个时间线编号","name":"receive_start_tli","type":"integer","zh_from":"doc"},{"description_zh":"已经接收并写入磁盘的最后一个预写式日志位置，但尚未刷盘。此字段不应用于数据完整性检查。","name":"written_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"已经接收并刷入到磁盘的最后一个预写式日志位置，该字段的初始值是启动 WAL 接收进程时使用的第一个日志位置","name":"flushed_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"接收并刷入到磁盘的最后一个预写式日志位置的时间线编号，该字段的初始值为启动 WAL 接收进程时使用的第一个日志位置的时间线编号","name":"received_tli","type":"integer","zh_from":"doc"},{"description_zh":"从源 WAL 发送进程收到的最后一条消息的发送时间","name":"last_msg_send_time","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"从源 WAL 发送进程收到的最后一条消息的接收时间","name":"last_msg_receipt_time","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"向源 WAL 发送进程报告的最后一个预写式日志位置","name":"latest_end_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"向源 WAL 发送进程报告最后一个预写式日志位置的时间","name":"latest_end_time","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"这个 WAL 接收进程使用的复制槽的名称","name":"slot_name","type":"text","zh_from":"doc"},{"description_zh":"这个 WAL 接收进程连接到的PostgreSQL实例的主机。这可以是主机名或IP地址；如果通过Unix套接字连接，也可以是目录路径。（路径的情况可以区分，因为它总是以/开头的绝对路径。）","name":"sender_host","type":"text","zh_from":"doc"},{"description_zh":"这个 WAL 接收进程连接的PostgreSQL实例的端口号。","name":"sender_port","type":"integer","zh_from":"doc"},{"description_zh":"这个 WAL 接收进程使用的连接字符串，对安全敏感的字段进行了模糊处理。","name":"conninfo","type":"text","zh_from":"doc"}],"description_zh":"pg_stat_wal_receiver视图只包含一行，显示 WAL 接收进程从其所连接服务器接收数据的统计信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}