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

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

View PDF

SUMMARY_STAT_BAD_BLOCK

Obtains the summary of the table and index read failure information of each database node in a period specified by first_time and last_time. The value of first_time is the start time and the value of last_time is the end time.

**Table 1** SUMMARY_STAT_BAD_BLOCK columns
Name	Type	Description
databaseid	integer	OID of the database.
tablespaceid	integer	OID of the tablespace.
relfilenode	integer	File node of this relation.
forknum	bigint	Fork number.
error_count	bigint	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.