Updated on 2025-07-22 GMT+08:00

GLOBAL_STAT_BAD_BLOCK

Displays information about table and index read failures on each node.

Table 1 GLOBAL_STAT_BAD_BLOCK columns

Name

Type

Description

node_name

text

Node name.

databaseid

integer

OID of the database.

tablespaceid

integer

OID of the tablespace.

relfilenode

integer

File node of this relation.

forknum

integer

Fork number.

error_count

integer

Number of errors.

first_time

timestamp with time zone

Time when the page damage occurred for the first time.

last_time

timestamp with time zone

Time when the page damage occurred for the last time.