pg_stat_wal_receiver — PostgreSQL statistics view

The PostgreSQL pg_stat_wal_receiver statistics view: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  3 min read

Summary

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

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_stat_wal_receiver statistics view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • pid integer
    Process ID of the WAL receiver process
  • status text
    Activity status of the WAL receiver process. Possible values are: restarting: 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.
  • 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.

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_stat_wal_receiver.