Statistical information in system tables is gathered continuously, but committed in certain periods. Using this command, you can force this commit.
- 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.
FLUSH STATISTICS; COMMIT; SELECT * FROM EXA_USAGE_LAST_DAY ORDER BY MEASURE_TIME DESC LIMIT 10;