Overview
Displays the number of DML operations performed on each table in the current tenant since the last statistics collection, and indicates whether the current statistics have expired.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| DATABASE_NAME | varchar(128) | NO | The name of the database where the table is located. |
| TABLE_NAME | varchar(128) | NO | Table name |
| PARTITION_NAME | varchar(128) | YES | Partition name. When the value of this column in a partitioned table is NULL, it indicates that the current record is summarized at the table level. |
| SUBPARTITION_NAME | varchar(128) | YES | Subpartition name. When the value of this column in a subpartitioned table is NULL, it indicates that the current record is summarized at the table level or partition level. |
| LAST_ANALYZED_ROWS | bigint(20) | YES | Number of rows last time statistics were collected. A value of NULL indicates statistics have never been collected. |
| LAST_ANALYZED_TIME | timestamp(6) | YES | The time when statistics were last collected. A value of NULL indicates that statistics have never been collected. |
| INSERTS | bigint(21) | NO | How many rows were inserted since the last statistics collection? |
| UPDATES | bigint(21) | NO | How many rows have been updated since the last statistics collection? |
| DELETES | bigint(21) | NO | Number of rows deleted since the last statistics collection |
| STALE_PERCENT | bigint(21) | NO | Percentage of Aging Statistics |
| IS_STALE | varchar(3) | NO | Whether the statistics are expired.
|
Sample query
View the number of DML operations on the table t_subpart in this tenant since the last statistics collection and the expiration status of the statistics.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TABLE_STAT_STALE_INFO WHERE TABLE_NAME='t_subpart';
The query result is as follows:
+---------------+---------------+----------------+-------------------+--------------------+----------------------------+---------+---------+---------+---------------+----------+
| DATABASE_NAME | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | LAST_ANALYZED_ROWS | LAST_ANALYZED_TIME | INSERTS | UPDATES | DELETES | STALE_PERCENT | IS_STALE |
+---------------+---------------+----------------+-------------------+--------------------+----------------------------+---------+---------+---------+---------------+----------+
| test | t_subpart | NULL | NULL | 1000 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2023 | NULL | 635 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2024 | NULL | 365 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p_max | NULL | 0 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2023 | p2023sp0 | 127 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2023 | p2023sp1 | 190 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2023 | p2023sp2 | 127 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2023 | p2023sp3 | 191 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2024 | p2024sp0 | 73 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2024 | p2024sp1 | 110 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2024 | p2024sp2 | 73 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p2024 | p2024sp3 | 109 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p_max | p_maxsp0 | 0 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p_max | p_maxsp1 | 0 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p_max | p_maxsp2 | 0 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
| test | t_subpart | p_max | p_maxsp3 | 0 | 2025-03-21 16:21:09.846859 | 0 | 0 | 0 | 10 | NO |
+---------------+---------------+----------------+-------------------+--------------------+----------------------------+---------+---------+---------+---------------+----------+
16 rows in set