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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot