Help Center> GaussDB> Distributed_2.x> Schemas> DBE_PERF Schema> Utility> GLOBAL_DOUBLE_WRITE_STATUS

Updated on 2023-10-23 GMT+08:00

View PDF

GLOBAL_DOUBLE_WRITE_STATUS

GLOBAL_DOUBLE_WRITE_STATUS displays the information about doublewrite files of all instances in the entire cluster.

**Table 1** GLOBAL_DOUBLE_WRITE_STATUS columns
Name	Type	Description
node_name	text	Instance name
curr_dwn	bigint	Sequence number of the doublewrite file
curr_start_page	bigint	Start page for restoring the doublewrite file
file_trunc_num	bigint	Number of times that the doublewrite file is reused
file_reset_num	bigint	Number of reset times after the doublewrite file is full
total_writes	bigint	Total number of I/Os of the doublewrite file
low_threshold_writes	bigint	Number of I/Os for writing the doublewrite files with low efficiency (the number of I/O flushing pages at a time is less than 16.)
high_threshold_writes	bigint	Number of I/Os for writing the doublewrite files with high efficiency (the number of I/O flushing pages at a time is more than 421.)
total_pages	bigint	Total number of pages that are flushed to the doublewrite file area
low_threshold_pages	bigint	Number of pages that are flushed with low efficiency
high_threshold_pages	bigint	Number of pages that are flushed with high efficiency
file_id	bigint	ID of the current doublewrite file