Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ Schemas/ DBE_PERF Schema/ Object/ GLOBAL_STAT_BAD_BLOCK
Updated on 2024-06-03 GMT+08:00
View PDF
Share

GLOBAL_STAT_BAD_BLOCK

Obtains the table and index read failure information of each database node, as shown in Table 1. The read failure information of different nodes is not summed up.

Table 1 GLOBAL_STAT_BAD_BLOCK columns

Name

Type

Description

node_name

text

Node name.

databaseid

integer

Database OID.

tablespaceid

integer

Tablespace OID.

relfilenode

integer

Relationship file node.

forknum

integer

Fork number.

error_count

integer

Number of errors.

first_time

timestamp with time zone

Time when the page damage occurs for the first time.

last_time

timestamp with time zone

Time when the page damage occurs for the last time.
Parent topic: Object