Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ Schemas/ DBE_PERF Schema/ Object/ GLOBAL_STAT_BAD_BLOCK
Updated on 2025-05-29 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. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

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