# INDEX\_STATISTICS

This view contains statistics about indexes. Each row displays information about a given index on a given database partition.

| Column Name      | Description                                                                           |
| ---------------- | ------------------------------------------------------------------------------------- |
| `DATABASE_NAME`  | The name of the related database.                                                     |
| `TABLE_NAME`     | The name of the related table.                                                        |
| `INDEX_NAME`     | The name of a given index.                                                            |
| `ORDINAL`        | The partition ID number.                                                              |
| `HOST`           | The hostname or IP address of the related node.                                       |
| `PORT`           | The port number of the related node.                                                  |
| `NODE_TYPE`      | The type of node: master aggregator (MA), child aggregator (CA), or leaf node (LEAF). |
| `PARTITION_TYPE` | The type of partition: master or secondary.                                           |
| `MEMORY_USE`     | The amount of memory, in bytes, used by a given index.                                |

***

Modified at: December 12, 2023

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/index-statistics/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/index-statistics/)

(An index of the documentation is available at /llms.txt)