SHOW ANALYZE STATUS

The SHOW ANALYZE STATUS statement shows the statistics collection tasks being executed by TiDB and a limited number of historical task records.

Synopsis

ShowStmt:

ShowStmt

ShowTargetFilterable:

ShowTargetFilterable

Examples

create table t(x int, index idx(x)) partition by hash(x) partition 4; analyze table t; show analyze status;
+--------------+------------+----------------+-------------------+----------------+---------------------+----------+ | Table_schema | Table_name | Partition_name | Job_info | Processed_rows | Start_time | State | +--------------+------------+----------------+-------------------+----------------+---------------------+----------+ | test | t | p1 | analyze columns | 0 | 2020-05-25 17:23:55 | finished | | test | t | p0 | analyze columns | 0 | 2020-05-25 17:23:55 | finished | | test | t | p0 | analyze index idx | 0 | 2020-05-25 17:23:55 | finished | | test | t | p1 | analyze index idx | 0 | 2020-05-25 17:23:55 | finished | | test | t | p2 | analyze index idx | 0 | 2020-05-25 17:23:55 | finished | | test | t | p3 | analyze index idx | 0 | 2020-05-25 17:23:55 | finished | | test | t | p3 | analyze columns | 0 | 2020-05-25 17:23:55 | finished | | test | t | p2 | analyze columns | 0 | 2020-05-25 17:23:55 | finished | +--------------+------------+----------------+-------------------+----------------+---------------------+----------+ 8 rows in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also