GLOBAL_GET_BGWRITER_STATUS

GLOBAL_GET_BGWRITER_STATUS displays the information about pages flushed by the bgwriter threads of all instances in the database, number of pages in the candidate buffer chain, and buffer eviction information.

Table 1 GLOBAL_GET_BGWRITER_STATUS columns

Name

Type

Description

node_name

text

Node name

bgwr_actual_flush_total_num

bigint

Total number of dirty pages flushed by the bgwriter thread from the startup time to the current time

bgwr_last_flush_num

integer

Number of dirty pages flushed by the bgwriter thread in the previous batch

candidate_slots

integer

Number of pages in the current candidate buffer chain.

get_buffer_from_list

bigint

Number of times that pages are obtained from the candidate buffer chain during buffer eviction.

get_buffer_clock_sweep

bigint

Number of times that pages are obtained from the original eviction solution during buffer eviction.

Feedback
编组 3备份
    openGauss 2024-04-21 00:47:23
    cancel