Help Center> GaussDB> Centralized_3.x> Schemas> DBE_PERF Schema> Object> GLOBAL_STAT_BAD_BLOCK

Updated on 2024-05-07 GMT+08:00

View PDF

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.