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.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
