Improve background statistics collection
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10600 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.0.1, Exasol 6.2.11 |
| Resolution Date | 2020-09-01 |
Background
EXA_*_LAST_DAY (EXA_MONITOR_LAST_DAY, EXA_USAGE_LAST_DAY) system tables contain data from last day only (last 24 hours to be more precise). To better observe long term trends on the system, this data is aggregated and made available in the EXA_HOURLY/DAILY/MONTHLY system tables. This aggregation process is done in the background mostly every 10 minutes.
Description
This process process may consume many resources, in particular CPU.
Fix
The process is executed more efficiently, reducing CPU footprint.
Workaround
There is no workaround.
