Updated on 2024-06-03 GMT+08:00

GLOBAL_CKPT_STATUS

GLOBAL_CKPT_STATUS displays the information about checkpoints and flushing pages of all instances in the entire cluster, as described in Table 1.

Table 1 GLOBAL_CKPT_STATUS columns

Name

Type

Description

node_name

text

Instance name.

ckpt_redo_point

text

Checkpoint of the current instance.

ckpt_clog_flush_num

bigint

Number of Clog flushing pages from the startup time to the current time.

ckpt_csnlog_flush_num

bigint

Number of CSN log flushing pages from the startup time to the current time.

ckpt_multixact_flush_num

bigint

Number of MultiXact flushing pages from the startup time to the current time.

ckpt_predicate_flush_num

bigint

Number of predicate flushing pages from the startup time to the current time.

ckpt_twophase_flush_num

bigint

Number of two-phase flushing pages from the startup time to the current time.