Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

SHOW TABLE STATUS

Syntax

SHOW TABLE STATUS [{FROM | IN} db_name]

Remarks

db_name is the name of a SingleStore Helios database.
Shows how much memory this table is using for row data.
Memory for off-row data (such as VARCHARs) is not reported.

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