TABLE_ STATISTICS and INTERNAL_ TABLE_ STATISTICS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
This view contains information about table statistics.INTERNAL_
(an internal use-only table added in v7.
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 node: master aggregator (MA), child aggregator (CA), or leaf node (LEAF). |
|
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. |
|
Storage Id of the database. |
|
Compute Id of the database. |
Metadata Table Listing
The following metadata tables can be included in the INTERNAL_
column:
Component |
Table Name |
Description |
---|---|---|
Columnstore |
|
Stores file-level information about columnstore data files. |
Columnstore |
|
Stores information about columnstore data files that has been logically deleted. |
Columnstore |
|
Stores information about on-disk index blobs created for columnstore secondary hash indexes. |
Columnstore |
|
Stores more information about columnstore data files that have been logically deleted. |
Columnstore |
|
For each columnstore secondary index added through an alter table statement, stores whether the index has been fully built or not. |
Columnstore |
|
Stores information about all column segments in the columnstore tables. |
Columnstore |
|
Stores information about all row segments in the columnstore tables. |
Miscellaneous |
|
Stores information about unlimited storage GC deadlines used to support the unlimited storage retention period. |
Miscellaneous |
|
Tracks the states of the database partitions. |
Miscellaneous |
|
Stores a mapping from logical partitions to the actual partitions. |
Miscellaneous |
|
Deprecated. |
Miscellaneous |
|
Stores database-level attributes for internal use. |
Miscellaneous |
|
Tracks the states of ongoing distributed transactions. |
Miscellaneous |
|
A queue of pending internal maintence tasks. |
Miscellaneous |
|
For each auto increment column, stores an upper bound of previously generated auto increment values. |
Pipelines |
|
Deprecated. |
Pipelines |
|
For each auto increment column, stores an upper bound of previously generated auto increment values. |
Pipelines |
|
Contains information about a pipeline's offset ranges for every data source partition. |
Pipelines |
|
Deprecated. |
Pipelines |
|
Tracks on-disk files used for storing pipeline errors. |
Statistics |
|
Deprecated. |
Statistics |
|
Details all of the histograms that have been built in the cluster. |
Statistics |
|
Contains the cardinality stats for all user tables. |
User Objects |
|
Store the connection links created in the database. |
User Objects |
|
Stores the index definition for all tables. |
User Objects |
|
Lists parameter definitions for each function in |
User Objects |
|
Stores the list of columns contained in each index. |
User Objects |
|
Lists all user defined aggregate function definitions. |
User Objects |
|
Stores the list of columns contained in each foreign key. |
User Objects |
|
Stores the foreign key definition for all tables. |
User Objects |
|
Stores the column definition for all tables. |
User Objects |
|
Lists all scalar UDF and TVF definitions. |
User Objects |
|
Lists all routine names from |
User Objects |
|
Lists parameter definitions for each function in |
User Objects |
|
List all tables in a database. |
Last modified: May 28, 2024