pg_stat_wal_receiver
The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- 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
Definition PG 18
The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| pid | integer | Nullable | Process ID of the WAL receiver process |
| status | text | Nullable | Activity status of the WAL receiver process |
| receive_start_lsn | pg_lsn | Nullable | First write-ahead log location used when WAL receiver is started |
| receive_start_tli | integer | Nullable | First timeline number used when WAL receiver is started |
| written_lsn | pg_lsn | Nullable | 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 | Nullable | 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 | Nullable | 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 | Nullable | Send time of last message received from origin WAL sender |
| last_msg_receipt_time | timestamp with time zone | Nullable | Receipt time of last message received from origin WAL sender |
| latest_end_lsn | pg_lsn | Nullable | Last write-ahead log location reported to origin WAL sender |
| latest_end_time | timestamp with time zone | Nullable | Time of last write-ahead log location reported to origin WAL sender |
| slot_name | text | Nullable | Replication slot name used by this WAL receiver |
| sender_host | text | Nullable | 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 | Nullable | Port number of the PostgreSQL instance this WAL receiver is connected to. |
| conninfo | text | Nullable | Connection string used by this WAL receiver, with security-sensitive fields obfuscated. |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:a8cc0a736ccd1d1de63395c29bbaf786c36e53ebccd4d3a7c4a0c8955b785c6f
Text language: en · catalog-bilingual-repair:a8cc0a736ccd1d1de63395c29bbaf786c36e53ebccd4d3a7c4a0c8955b785c6f