PG_STATIO_ALL_INDEXES
PG_STATIO_ALL_INDEXES displays I/O statistics of all indexes in the current database.
Name |
Type |
Description |
---|---|---|
relid |
oid |
OID of the index table |
indexrelid |
oid |
OID of this index |
schemaname |
name |
Name of the schema this index is in |
relname |
name |
Name of the table for this index |
indexrelname |
name |
Name of this index |
idx_blks_read |
bigint |
Number of disk blocks read from the index |
idx_blks_hit |
bigint |
Number of buffer hits in this index |
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