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.
