Updated on 2024-06-03 GMT+08:00

GLOBAL_GET_BGWRITER_STATUS

GLOBAL_GET_BGWRITER_STATUS displays the information about pages flushed by the bgwriter threads of all instances in the entire cluster, number of pages in the candidate buffer chain, and buffer eviction information, as described in Table 1.

Table 1 GLOBAL_GET_BGWRITER_STATUS columns

Name

Type

Description

node_name

text

Instance 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.