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-04-29 07:43:02