Help Center/ GaussDB/ Centralized_8.x/ Schemas/ DBE_PERF Schema/ Utility/ GLOBAL_PAGEWRITER_STATUS

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

View PDF

GLOBAL_PAGEWRITER_STATUS

GLOBAL_PAGEWRITER_STATUS displays the page flushing information and checkpoint information about all instances in the database, as described in Table 1.

**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 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 remaining dirty pages.
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