select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS

pg_last_xact_replay_timestamp

Read PG 18 manual ↗

Returns the time stamp of the last transaction replayed during recovery.

Signatures & examples

pg_last_xact_replay_timestamp () → timestamp with time zone
Returns the time stamp of the last transaction replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary. If no transactions have been replayed during recovery, the function returns NULL. Otherwise, if recovery is still in progress this will increase monotonically. If recovery has completed then this will remain static at the time of the last transaction applied during recovery. When the server has been started normally without recovery, the function returns NULL.
Version history 2
  1. PG 12 → 13changed
  2. PG 9.0 → 9.1added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source