Updated on 2023-10-23 GMT+08:00

PG_STAT_BAD_BLOCK

PG_STAT_BAD_BLOCK shows statistics about Page or CU verification failures after a node is started.

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 values are as follows:

0: main data file

1: FSM file

2: VM file

3: BCM file

If the value is greater than 4, it indicates a data file of each column in a column-store table.

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