PG_STAT_SYS_INDEXES
PG_STAT_SYS_INDEXES displays the index status information about all the system catalogs in the pg_catalog and information_schema schemas.
Name |
Type |
Description |
---|---|---|
relid |
oid |
Table OID for the index |
indexrelid |
oid |
Index OID |
schemaname |
name |
Schema name for the index |
relname |
name |
Table name for the index |
indexrelname |
name |
Index name |
idx_scan |
bigint |
Number of index scans |
idx_tup_read |
bigint |
Number of index entries returned by scans on this index |
idx_tup_fetch |
bigint |
Number of rows that have live data fetched by index scans |
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