Help Center/ GaussDB/ Distributed_3.x/ Schemas/ DBE_PERF Schema/ Utility/ GLOBAL_SINGLE_FLUSH_DW_STATUS
Updated on 2024-05-07 GMT+08:00
View PDF

GLOBAL_SINGLE_FLUSH_DW_STATUS

The GLOBAL_SINGLE_FLUSH_DW_STATUS view displays the information about the eliminated doublewrite file on a single page of all instances in the entire cluster. The information before the slash (/) is the page refresh information of the first version of the doublewrite file, and that after the slash (/) is the page refresh information of the second version of the doublewrite file.

Table 1 GLOBAL_SINGLE_FLUSH_DW_STATUS columns

Name

Type

Description

node_name

text

Instance name.

curr_dwn

text

Sequence number of the doublewrite file.

curr_start_page

text

Start position of the current doublewrite file.

total_writes

text

Total number of data write pages in the current doublewrite file.

file_trunc_num

text

Number of times that the doublewrite file is reused.

file_reset_num

text

Number of reset times after the doublewrite file is full.
Parent topic: Utility