Updated on 2025-05-29 GMT+08:00

PG_STAT_BAD_BLOCK

PG_STAT_BAD_BLOCK displays statistics about page verification failures after a node is started. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

Table 1 PG_STAT_BAD_BLOCK columns

Name

Type

Description

nodename

text

Node name.

databaseid

integer

Database OID.

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.

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.