Help Center/ GaussDB/ Developer Guide(Distributed_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 information about table and index read failures on each node., as described in Table 1. It is used on CNs. The read failure information of DNs is displayed only, but 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