pg_stat_wal_receiver.written_lsn

Description

Last write-ahead log location already received and written to disk, but not flushed. This should not be used for data integrity checks.

View

pg_stat_wal_receiver

Field

written_lsn

SQL type

pg_lsn

Units named in the field definition

Not specified

Reset observation

No stats_reset field is documented for this view

Usage

SELECT written_lsn FROM pg_catalog.pg_stat_wal_receiver;

View semantics

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

Collection and reset context

Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name.

Inspect this field

Example query; no execution result or measured value is asserted.

SELECT written_lsn FROM pg_catalog.pg_stat_wal_receiver;

Related entries

• pg_stat_wal_receiver columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 12 → 13: added.

--- PostgreSQL 12
+++ PostgreSQL 13
@@ -1 +1,6 @@
-Not recorded in this version
+{
+  "field": "written_lsn",
+  "sql_type": "pg_lsn",
+  "units_mentioned": [],
+  "view": "pg_stat_wal_receiver"
+}

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

• pg_stat_wal_receiver.conninfo
• pg_stat_wal_receiver.flushed_lsn
• pg_stat_wal_receiver.last_msg_receipt_time
• pg_stat_wal_receiver.last_msg_send_time
• pg_stat_wal_receiver.latest_end_lsn
• pg_stat_wal_receiver.latest_end_time
• pg_stat_wal_receiver.pid
• pg_stat_wal_receiver.receive_start_lsn
• pg_stat_wal_receiver.receive_start_tli
• pg_stat_wal_receiver.received_tli
• pg_stat_wal_receiver.sender_host
• pg_stat_wal_receiver.sender_port