↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

pg_last_committed_xact

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

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
info
group label
系统信息函数和操作符
lang
en
layout
table-new
pages
functions-info.html
prose only
false

Definition PG 18

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

Signatures and overloads

pg_last_committed_xact () → record ( xid xid, timestamp timestamp with time zone, roident oid ) → record
Returns the transaction ID, commit timestamp and replication origin of the latest committed transaction.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:d1c0a35b7eed5aa055b953054d482e4975547acdfa84726c3ecdeaf568b4d121

Text language: en · wiki-repair-20261023:d1c0a35b7eed5aa055b953054d482e4975547acdfa84726c3ecdeaf568b4d121