GLOBAL_STAT_USER_INDEXES
Displays the index status information about user-defined ordinary tables in all schemas on each node. The information is about CNs and DNs. It is used on CNs and information is not summed up.
| Name | Type | Description |
|---|---|---|
| node_name | name | Node name |
| relid | oid | OID of the table that the index is created for |
| indexrelid | oid | OID of the index |
| schemaname | name | Name of the schema where the index is located. |
| relname | name | Name of the table for the index |
| indexrelname | name | Index name |
| idx_scan | bigint | Number of index scans performed on the index. |
| idx_tup_read | bigint | Number of index entries returned by scans on the index. |
| idx_tup_fetch | bigint | Number of live rows fetched in the original table by a simple index scan that uses the index. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
