SHOW TABLE STATUS

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.

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)