Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ Schemas/ DBE_PERF Schema/ Object/ STAT_BAD_BLOCK
Updated on 2025-08-19 GMT+08:00
View PDF

STAT_BAD_BLOCK

Obtains the information about table and index read failures on the current node, as shown in Table 1. 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 STAT_BAD_BLOCK columns

Name

Type

Description

nodename

text

Node name.

databaseid

integer

Database OID.

tablespaceid

integer

Tablespace OID.

relfilenode

integer

Relationship file node.

bucketid

smallint

ID of the bucket for consistent hashing.

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