Functions / System Administration Functions

pg_last_wal_replay_lsn

Returns the last write-ahead log location that has been replayed during recovery.

Reading PG 18current·documented in 11 of 27 versions, 10 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 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

Signatures & examples

pg_last_wal_replay_lsn () → pg_lsn

Returns the last write-ahead log location that has been replayed during recovery. If recovery is still in progress this will increase monotonically. If recovery has completed then this will remain static at the location of the last WAL record applied during recovery. When the server has been started normally without recovery, the function returns NULL.

Version history 2

12 → 13 changed
9.6 → 10 added

Definition snapshot: b7bd9cda · English manual source