FLUSH STATISTICS
Purpose
Statistical information in system tables is gathered continuously, but committed in certain periods. Using this statement, you can force this commit.
Prerequisite
None
Syntax
flush_statistics::=
Usage Notes
- To show the latest flushed statistics, you may need to open a new transaction.
- This command generates additional load for the DBMS and should be used with caution. The statistical information is updated every minute.
- The available statistical information is described in Statistical System Tables.
Example
FLUSH STATISTICS;
COMMIT;
SELECT * FROM EXA_USAGE_LAST_DAY ORDER BY MEASURE_TIME DESC LIMIT 10;