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

1. 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 |
+--------------+-------------+-----------+---------------------+------------------------+---------+---------------+-------------+---------------------+---------------------+