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.
