pg_control_checkpoint()

A system function exposing a subset of pg_control data related to the current checkpoint state

pg_control_checkpoint() is a system function exposing a subset of pg_control data related to the current checkpoint state.

pg_control_checkpoint() was added in PostgreSQL 9.6 (commit dc7d70ea).

Examples

postgres=# SELECT * FROM pg_control_checkpoint();
-[ RECORD 1 ]--------+-------------------------
checkpoint_lsn       | 0/3475BE8
redo_lsn             | 0/2BF1DE8
redo_wal_file        | 000000010000000000000002
timeline_id          | 1
prev_timeline_id     | 1
full_page_writes     | t
next_xid             | 0:515
next_oid             | 24576
next_multixact_id    | 1
next_multi_offset    | 0
oldest_xid           | 485
oldest_xid_dbid      | 1
oldest_active_xid    | 515
oldest_multi_xid     | 1
oldest_multi_dbid    | 1
oldest_commit_ts_xid | 0
newest_commit_ts_xid | 0
checkpoint_time      | 2019-07-17 15:22:20+01

Categories

PostgreSQL internals, System function

See also

pg_controldata, pg_control_system(), pg_control_init(), pg_control_recovery()