SHOW TABLE STATS
Description
This statement is used to view the overview statistics of a table.
Syntax
SHOW TABLE STATS <table_name>;
Required Parameters
1. <table_name>
Table name
Optional Parameters
None
Return Value
| Column | Note |
|---|---|
| updated_rows | table updated row count |
| query_times | table query times |
| row_count | table row count |
| updated_time | table last modified time |
| columns | analyzed column list |
| trigger | last analyze trigger method |
| new_partition | flag of new partition first loaded |
| user_inject | flag of user inject statistics |
| enable_auto_analyze | flag of auto analyzed enabled |
| last_analyze_time | last analyze time |
Access Control Requirements
The user who executes this SQL must have at least the following permissions:
| Privilege | Object | Notes |
|---|---|---|
| SELECT_PRIV | Table | When executing SHOW, the SELECT_PRIV privilege for the queried table is required. |
Examples
- Show the overview statistics of table test1.
SHOW TABLE STATS test1;
+--------------+-------------+-----------+---------------------+------------------------+---------+---------------+-------------+---------------------+---------------------+
| updated_rows | query_times | row_count | updated_time | columns | trigger | new_partition | user_inject | enable_auto_analyze | last_analyze_time |
+--------------+-------------+-----------+---------------------+------------------------+---------+---------------+-------------+---------------------+---------------------+
| 0 | 0 | 100000 | 2025-01-17 16:46:31 | [test1:name, test1:id] | MANUAL | false | false | true | 2025-02-05 12:17:41 |
+--------------+-------------+-----------+---------------------+------------------------+---------+---------------+-------------+---------------------+---------------------+
