System Catalogs / Statistics views
pg_stat_wal_receiver
Read the PG 18 manualThe pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server.
Reading PG 18current·documented in 12 of 24 versions, 9.6 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 15
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 15
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
pid | integer | Process ID of the WAL receiver process |
status | text | Activity status of the WAL receiver process |
receive_start_lsn | pg_lsn | First write-ahead log location used when WAL receiver is started |
receive_start_tli | integer | First timeline number used when WAL receiver is started |
written_lsn | pg_lsn | Last write-ahead log location already received and written to disk, but not flushed. This should not be used for data integrity checks. |
flushed_lsn | pg_lsn | 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 |
received_tli | integer | 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 |
last_msg_send_time | timestamp with time zone | Send time of last message received from origin WAL sender |
last_msg_receipt_time | timestamp with time zone | Receipt time of last message received from origin WAL sender |
latest_end_lsn | pg_lsn | Last write-ahead log location reported to origin WAL sender |
latest_end_time | timestamp with time zone | Time of last write-ahead log location reported to origin WAL sender |
slot_name | text | Replication slot name used by this WAL receiver |
sender_host | text | 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 /.) |
sender_port | integer | Port number of the PostgreSQL instance this WAL receiver is connected to. |
conninfo | text | Connection string used by this WAL receiver, with security-sensitive fields obfuscated. |
Column history across versions
Definition snapshot: english-manuals:2e548531e119e4038de1abbbf05… · English manual source