pg_last_xlog_replay_location ( ) → pg_lsnGet last transaction log location replayed during recovery. If recovery is still in progress this will increase monotonically. If recovery has completed then this value will remain static at the value of the last WAL record applied during that recovery. When the server has been started normally without recovery the function returns NULL.
FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS
pg_last_xlog_replay_location
Read PG 9.6 manual ↗Get last transaction log location replayed during recovery.
Historical documentation for a PostgreSQL version that is no longer supported.
Signatures & examples
Version history 2
- PG 9.6 → 10removed
- PG 9.3 → 9.4changed
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source