Updated on 2024-05-07 GMT+08:00

GLOBAL_PAGEWRITER_STATUS

GLOBAL_PAGEWRITER_STATUS displays the page flushing information and checkpoint information about all instances in the database.

Table 1 GLOBAL_PAGEWRITER_STATUS columns

Name

Type

Description

node_name

text

Node name.

pgwr_actual_flush_total_num

bigint

Total number of dirty pages flushed from the startup time to the current time

pgwr_last_flush_num

integer

Number of dirty pages flushed in the previous batch

remain_dirty_page_num

bigint

Estimated number of dirty pages that are not flushed

queue_head_page_rec_lsn

text

recovery_lsn of the first dirty page in the dirty page queue of the current instance

queue_rec_lsn

text

recovery_lsn of the dirty page queue of the current instance

current_xlog_insert_lsn

text

The write position of Xlogs in the current instance

ckpt_redo_point

text

Checkpoint of the current instance