Refresh all buckets of a continuous aggregate in the refresh window
A continuous aggregate materializes aggregates in time buckets (for example,
min, max, average over 1 day worth of data), as determined by the
time_bucket interval specified when the continuous aggregate was
created. Therefore, when refreshing the continuous aggregate, only
buckets that completely fit within the refresh window are
refreshed. In other words, it is not possible to compute the aggregate
over, for example, half a bucket. Therefore, any buckets that do not
fit within the given refresh window are excluded.
The function expects the window parameter values to have a time type
that is compatible with the continuous aggregate's time bucket
expression—for example, if the time bucket is specified in
TIMESTAMP WITH TIME ZONE, then the start and end time should be a
date or timestamp type. Note that a continuous aggregate using the
TIMESTAMP WITH TIME ZONE type aligns with the UTC time zone, so, if
window_end is specified in the local time zone,
any time zone shift relative UTC needs to be accounted for when
refreshing in order to align with bucket boundaries.
|REGCLASS||The continuous aggregate to refresh.|
|INTERVAL||Start of the window to refresh, has to be before |
|INTERVAL||End of the window to refresh, has to be after |
Refresh the continuous aggregate
CALL refresh_continuous_aggregate('conditions', '2020-01-01', '2020-02-01');
Found an issue on this page?Report an issue!