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 | 
openGauss 2025-10-31 07:42:18