Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ PG_STAT_BAD_BLOCK
Updated on 2025-08-19 GMT+08:00
View PDF

PG_STAT_BAD_BLOCK

PG_STAT_BAD_BLOCK displays statistics about page verification failures after a node is started. For details about the columns, see Table 1.

Table 1 PG_STAT_BAD_BLOCK columns

Name

Type

Description

nodename

text

Node name.

databaseid

integer

OID of a database.

tablespaceid

integer

Tablespace OID.

relfilenode

integer

File object ID.

bucketid

smallint

ID of the bucket for consistent hashing.

forknum

integer

File type. The options are as follows:

  • 0: main data file.
  • 1: FSM file.
  • 2: VM file.
  • 3: BCM file.

error_count

integer

Number of verification failures.

first_time

timestamp with time zone

Time of the first verification failure.

last_time

timestamp with time zone

Time of the latest verification failure.
Parent topic: Other System Views