# View Table Statistics (Continue...)
+ View metadata for a column:
```7
mysql> SHOW STATS_HISTOGRAMS WHERE db_name = 'tpcc' AND table_name = 'orders';
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+
| Db_name | Table_name | Partition_name | Column_name | Is_index | Update_time         | Distinct_count | Null_count | Avg_col_size | Correlation |
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+
| tpcc    | orders     |                | idx_order   |        1 | 2021-09-13 11:12:05 |         156000 |          0 |            0 |           0 |
| tpcc    | orders     |                | PRIMARY     |        1 | 2021-09-13 11:12:04 |         156000 |          0 |            0 |           0 |
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+
2 rows in set (0.00 sec)
```
------------------------------------------------------------
View statistics for a table
View various statistics for a table
- View the metadata of the table SHOW STATS_META [showLikeOrWhere];
- Check the health status of the table SHOW STATS_HEALTHY [showLikeOrWhere];
- View the metadata of the column SHOW STATS_HISTORWHERE [showLikeOrWhere];
View the information of the histogram SHOW STATS_BUCKETS [showLikeOrWhere];
```
mysql> SHOW STATS_HISTOGRAMS WHERE db_name = 'tpcc' AND table_name = 'orders';
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+
| Db_name | Table_name | Partition_name | Column_name | Is_index | Update_time         | Distinct_count | Null_count | Avg_col_size | Correlation |
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+
| tpcc    | orders     |                | idx_order   |        1 | 2021-09-13 11:12:05 |         156000 |          0 |            0 |           0 |
| tpcc    | orders     |                | PRIMARY     |        1 | 2021-09-13 11:12:04 |         156000 |          0 |            0 |           0 |
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+
2 rows in set (0.00 sec)
```
- You can view information such as the total number of rows in the table and the number of rows modify by SHOW STATS_META.
- You can check the health of the statistics by SHOW STAT_HEALTHY and coarse filter whether the statistics on the estimate table are accurate. When the health level falls below the automatic update threshold tidb_auto_analyze_ratio mentioned earlier, the optimizer automatically collects statistics within the window period
- You can view information such as the number of different values and the number of nulls in a column by SHOW STATS_HISTORIES. The statement outputs information such as the number of distinct values and the number of nulls for all columns.
- You can view information for each bucket in the histogram via STAT_BUCKETS. From this example, we can see that there is not only the histogram information for the table, but also the histogram information for the index.