Updated on 2025-08-19 GMT+08:00

GLOBAL_STAT_BAD_BLOCK

Obtains the table and index read failure information of each database node. The read failure information of different nodes is not summed up.

**Table 1** GLOBAL_STAT_BAD_BLOCK columns
Name	Type	Description
node_name	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 page damage occurs for the first time.
last_time	timestamp with time zone	Time when the page damage occurs for the last time.

Parent topic: Object