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

PGXC_STAT_BAD_BLOCK

PGXC_STAT_BAD_BLOCK shows statistics about Page or CU verification failures after all nodes in a cluster are started. This view can be viewed only by the SYSADMIN and MONADMIN users.

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 values 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: System Views