Contents
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
References
- PostgreSQL documentation: pg_control_checkpoint()