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

STAT_BAD_BLOCK

Displays information about table and index read failures on the current node.

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.

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.