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::=

Flush statistics statement

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;