Functions / System Information Functions And Operators

pg_last_committed_xact

Returns the transaction ID, commit timestamp and replication origin of the latest committed transaction.

Reading PG 18current·documented in 13 of 27 versions, 9.5 to 20

Signatures & examples

pg_last_committed_xact () → record ( xid xid, timestamp timestamp with time zone, roident oid )

Returns the transaction ID, commit timestamp and replication origin of the latest committed transaction.

Version history 3

Definition snapshot: b7bd9cda · English manual source