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

STAT_BAD_BLOCK

STAT_BAD_BLOCK displays the 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

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

last_time

timestamp with time zone

Time when the last bad block occurred