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

Updated on 2024-06-03 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, as shown in Table 1. 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	Database OID.
tablespaceid	integer	Tablespace OID.
relfilenode	integer	Relationship file node.
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.