SHOW TABLE STATUS
On this page
The SHOW TABLE STATUS command shows status information on tables in a SingleStore database.
Syntax
SHOW TABLE STATUS [{FROM | IN} db_name]Remarks
-
{FROM | IN} db_specifies the name of a SingleStore database.name -
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 (refer to Node Requirements for SingleStore Commands).
Output
|
Column |
Description |
|---|---|
|
|
Default is null, used as a placeholder for MySQL compatibility. |
|
|
SingleStore engine image name. |
|
|
Engine version. |
|
|
Shows whether the table is a sparse compressed rowstore table. |
|
|
Number of rows in the table. |
|
|
Average memory used per row in the table and is calculated as Data_ |
|
|
Total memory used for a table. |
|
|
Maximum data length. |
|
|
Index length. |
|
|
Data free. |
|
|
Default is null, used as a placeholder for MySQL compatibility. |
|
|
Table creation date and time. |
|
|
Update time. |
|
|
Default is null, used as a placeholder for MySQL compatibility. |
|
|
Takes the default value as per the character set and collation engine variables. |
|
|
Default is null, used as a placeholder for MySQL compatibility. |
|
|
Default is null, used as a placeholder for MySQL compatibility. |
|
|
Comments. |
|
|
Buffer manager memory in use (in bytes). |
|
|
Average duration of garbage collection (in milliseconds). |
Example
SHOW TABLE STATUS \G Name: marketing_campaigns
Engine: MemSql
Version: 10
Row_Format: Uncompressed
Rows: 10000
Avg_row_length: 0
Data_length: 0
Max_data_length: NULL
Index_length: NULL
Data_free: NULL
Auto_increment: NULL
Create_time: 2026-11-02 19:43:59
Update_time: NULL
Check_time: NULL
Collation: utf8mb4_bin
Checksum: NULL
Create_options: Not Available
Comment: Not Available
BuffMgr Memory Use: 0
Average GC Duration (ms): 0
Rows_in_memory: 0Last modified: