SHOW STATS_META
You can use SHOW STATS_META to view how many rows are in a table and how many rows are changed in that table. When using this statement, you can filter the needed information by the ShowLikeOrWhere clause.
Currently, the SHOW STATS_META statement outputs 6 columns:
| Column name | Description |
|---|---|
| db_name | Database name |
| table_name | Table name |
| partition_name | Partition name |
| update_time | Last updated time |
| modify_count | The number of rows modified |
| row_count | The total row count |
Synopsis
- ShowStatsMetaStmt
- ShowLikeOrWhere
ShowStatsMetaStmt ::=
"SHOW" "STATS_META" ShowLikeOrWhere?
ShowLikeOrWhere ::=
"LIKE" SimpleExpr
| "WHERE" Expression
Examples
SHOW STATS_META;
+---------+------------+----------------+---------------------+--------------+-----------+
| Db_name | Table_name | Partition_name | Update_time | Modify_count | Row_count |
+---------+------------+----------------+---------------------+--------------+-----------+
| test | t0 | | 2020-05-15 16:58:00 | 0 | 0 |
| test | t1 | | 2020-05-15 16:58:04 | 0 | 0 |
| test | t2 | | 2020-05-15 16:58:11 | 0 | 0 |
| test | s | | 2020-05-22 19:46:43 | 0 | 0 |
| test | t | | 2020-05-25 12:04:21 | 0 | 0 |
+---------+------------+----------------+---------------------+--------------+-----------+
5 rows in set (0.00 sec)
SHOW STATS_META WHERE table_name = 't2';
+---------+------------+----------------+---------------------+--------------+-----------+
| Db_name | Table_name | Partition_name | Update_time | Modify_count | Row_count |
+---------+------------+----------------+---------------------+--------------+-----------+
| test | t2 | | 2020-05-15 16:58:11 | 0 | 0 |
+---------+------------+----------------+---------------------+--------------+-----------+
1 row in set (0.00 sec)
MySQL compatibility
This statement is a TiDB extension to MySQL syntax.