Updated on 2025-07-15 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 occurs for the first time.

last_time

timestamp with time zone

Time when the page damage occurred for the last time.