SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_wal_receiver
Read PG 18 manual ↗The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server.
- Kind
- Statistics views
- Columns in this snapshot
- 15
- Definition source
- English manual
Columns 15
| 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
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pid | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
status | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
receive_start_lsn | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
receive_start_tli | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
received_lsn | · | · | · | · | · | · | ● | ● | ● | ● | · | · | · | · | · | · | · | · |
received_tli | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
last_msg_send_time | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
last_msg_receipt_time | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
latest_end_lsn | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
latest_end_time | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
slot_name | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
conninfo | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
sender_host | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
sender_port | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
written_lsn | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● |
flushed_lsn | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● |
Version history 6
- PG 18 → 19changed
- PG 12 → 13changed
- PG 11 → 12changed
- PG 10 → 11changed
- PG 9.6 → 10changed
- PG 9.5 → 9.6added
Definition snapshot: english-manuals:46c47dc7aa199f4d417ac0f6005… · English manual source