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