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

Copy

FLUSH STATISTICS;
COMMIT;
SELECT * FROM EXA_USAGE_LAST_DAY ORDER BY MEASURE_TIME DESC LIMIT 10;