Updated on 2023-10-23 GMT+08:00

SUMMARY_STAT_BAD_BLOCK

SUMMARY_STAT_BAD_BLOCK displays the information about table and index read failures in the cluster.

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 first bad block occurred

last_time

timestamp with time zone

Time when the last bad block occurred