Skip to content
← Catalog atlas / pg_stat_wal_receiver

STATISTICS VIEW · Statistics view

pg_stat_wal_receiver

PostgreSQL documentation ↗Source definition ↗

The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server.

First seen PG 9.6Last seen PG 19Columns 15
9.09.19.29.39.49.59.610111213141516171819β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_stat_wal_receiver
COLUMNTYPEDESCRIPTION
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.

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type
PresentAdded / type or attribute changeRemoved
COLUMN9.09.19.29.39.49.59.610111213141516171819
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 – – – – – – – – – –

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 19 ← 18

1 column description updates

PostgreSQL 13 ← 12

+ written_lsn+ flushed_lsn− received_lsnCatalog description updated

PostgreSQL 12 ← 11

Catalog description updated

PostgreSQL 11 ← 10

+ sender_host+ sender_port

PostgreSQL 10 ← 9.6

5 column description updatesCatalog description updated

PostgreSQL 9.6 ← 9.5Catalog added

+ 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

Compare any two versions

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.