TABLE_STATISTICS and INTERNAL_TABLE_STATISTICS
This view contains information about table statistics. It contains one row per table, per partition. INTERNAL_TABLE_STATICS (available starting with v7.8) contains the same columns, and shows information for SingleStoreDB internal metadata tables.
This information can be useful for Detecting and Resolving Data Skew.
Column Name | Description |
|---|---|
| The name of the related database. |
| The name of the related table. |
| The partition ID number. |
| The hostname or IP address for the related node. |
| The port number of the related node. |
| The type of the related node: leaf, master aggregator, or child aggregator. |
| The type of partition: master or secondary. |
| The number of rows in a given table and partition. |
| The memory use, in bytes, of a given table and partition. |
| The storage type of a given table and partition. |
| The number of rows stored in memory for a given table and partition. |