Help Center/ GaussDB/ Centralized_8.x/ Schemas/ DBE_PERF Schema/ Object/ GLOBAL_STAT_BAD_BLOCK

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

View PDF

GLOBAL_STAT_BAD_BLOCK

Obtains the table and index read failure information of each database node, as shown in Table 1. 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	Database OID.
tablespaceid	integer	Tablespace OID.
relfilenode	integer	Relationship file node.
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.