Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ Schemas/ DBE_PERF Schema/ Object/ SUMMARY_STAT_BAD_BLOCK
Updated on 2024-06-03 GMT+08:00
View PDF
Share

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.
Parent topic: Object