Help Center> GaussDB> Distributed_8.x> System Catalogs and System Views> System Views> Other System Views> PGXC_STAT_BAD_BLOCK
Updated on 2024-06-03 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. This view can be viewed only by the monitor admin and sysadmin users. 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