GLOBAL_PAGEWRITER_STATUS
GLOBAL_PAGEWRITER_STATUS displays the information about checkpoints and flushing pages of all instances in the entire cluster.
Name | Type | Description |
|---|---|---|
node_name | text | Instance 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
