GLOBAL_CKPT_STATUS
GLOBAL_CKPT_STATUS displays the checkpoint information and log flushing information about all instances in openGauss.
Table 1 GLOBAL_CKPT_STATUS columns
Name
|
Type
|
Description
|
|---|
node_name
|
text
|
Node name
|
ckpt_redo_point
|
test
|
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
|