SingleStore Managed Service

information_schema.TABLE_STATISTICS

This table contains information about table statistics. It contains one row per table, per partition.

This information can be useful for Detecting and Resolving Data Skew.

Column Name

Description

DATABASE_NAME

The name of the related database.

TABLE_NAME

The name of the related table.

ORDINAL

The partition ID number.

HOST

The hostname or IP address for the related node.

PORT

The port number of the related node.

NODE_TYPE

The type of the related node: leaf, master aggregator, or child aggregator.

PARTITION_TYPE

The type of partition: master or secondary.

ROWS

The number of rows in a given table and partition.

MEMORY_USE

The memory use, in bytes, of a given table and partition.

STORAGE_TYPE

The storage type of a given table and partition.

ROWS_IN_MEMORY

The number of rows stored in memory for a given table and partition.