Updated on 2024-06-03 GMT+08:00

STAT_BAD_BLOCK

Obtains the information about table and index read failures on the current node, as described in Table 1.

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.

bucketid

smallint

ID of the bucket for consistent hashing.

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.