Important

Self-managed SingleStore will soon transition from version 9.1 RC to version 10. This new semantic versioning scheme will provide SingleStore with finer control over engine and feature releases that were not possible with the current versioning scheme.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10 prior to its general availability. Ahead of this transition, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.

SHOW TABLE STATUS

Syntax

SHOW TABLE STATUS [{FROM | IN} db_name]

Remarks

db_name is the name of a SingleStore database.
Shows how much memory this table is using for row data.
Memory for off-row data (such as VARCHARs) is not reported.
This command can be run on any SingleStore node (see Node Requirements for SingleStore Commands).

Output

Column	Description
`Check_time`	Default is null, used as a placeholder for MySQL compatibility
`Engine`	SingleStore engine image name
`Version`	Engine version
`Row_format`	Shows whether the table is a sparse compressed rowstore table
`Rows`	Number of rows in the table
`Avg_row_length`	Average memory used per row in the table and is calculated as Data_length / Rows
`Data_length`	Total memory used for a table
`Max_data_length`	Maximum data length. Default is null, used as a placeholder for MySQL compatibility.
`Index_length`	Index length. Default is null, used as a placeholder for MySQL compatibility.
`Data_free`	Data free. Default is null, used as a placeholder for MySQL compatibility.
`Auto_increment`	Default is null, used as a placeholder for MySQL compatibility.
`Create_time`	Table creation date and time
`Update_time`	Update time
`Check_time`	Default is null, used as a placeholder for MySQLcompatibility
`Collation`	Takes the default value as per the character set and collation engine variables. By default it is `utf8_general_ci`.
`Checksum`	Default is null, used as a placeholder for MySQL compatibility.
`Create_options`	Default is null, used as a placeholder for MySQL compatibility.
`Comment`	Comments
`BuffMgr Memory Use`	Buffer manager memory in use (in bytes)
`Average GC Duration (ms)`	Average duration of garbage collection (in milliseconds)

Example

show table status \G

*** 1. row ***
                    Name: x
                  Engine: MemSQL
                 Version: 10
              Row_format: Uncompressed
                    Rows: 130
          Avg_row_length: NULL
             Data_length: NULL
         Max_data_length: NULL
            Index_length: NULL
               Data_free: NULL
          Auto_increment: NULL
             Create_time: 2014-03-05 16:10:36
             Update_time: NULL
              Check_time: NULL
               Collation: utf8_general_ci
                Checksum: NULL
          Create_options: Not Available
                 Comment: Not Available
      BuffMgr Memory Use: 141472
Average GC Duration (ms): 0
1 row in set (0.00 sec)

Last modified: July 21, 2026

SHOW TABLE STATUS

On this page

Syntax

Remarks

Example

Was this article helpful?

On this page

Was this article helpful?