25th May 2023: PostgreSQL 16 Beta 1 Released!
Supported Versions: Current (15) / 14
Development Versions: 16 / devel
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
F.24. old_snapshot — inspect old_snapshot_threshold state
Prev  Up Appendix F. Additional Supplied Modules and Extensions Home  Next

F.24. old_snapshot — inspect old_snapshot_threshold state #

F.24.1. Functions

The old_snapshot module allows inspection of the server state that is used to implement old_snapshot_threshold.

F.24.1. Functions #

pg_old_snapshot_time_mapping(array_offset OUT int4, end_timestamp OUT timestamptz, newest_xmin OUT xid) returns setof record

Returns all of the entries in the server's timestamp to XID mapping. Each entry represents the newest xmin of any snapshot taken in the corresponding minute.

Prev  Up  Next
F.23. ltree — hierarchical tree-like data type  Home  F.25. pageinspect — low-level inspection of database pages