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

SUMMARY_STAT_BAD_BLOCK

Displays information about table and index read failures in the database.

Table 1 SUMMARY_STAT_BAD_BLOCK columns

Name

Type

Description

databaseid

integer

OID of the database.

tablespaceid

integer

OID of the tablespace.

relfilenode

integer

File node of this relation.

forknum

bigint

Fork number.

error_count

bigint

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.