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

PGXC_STAT_BAD_BLOCK

PGXC_STAT_BAD_BLOCK displays statistics about page verification failures after all nodes in a cluster are started. Only users with the SYSADMIN and MONADMIN permissions can query this view. For details about the columns, see Table 1.

Table 1 PGXC_STAT_BAD_BLOCK columns

Name

Type

Description

nodename

text

Node name.

databaseid

integer

Database OID.

tablespaceid

integer

Tablespace OID.

relfilenode

integer

File object ID.

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