2025-10-27 19:36:55.076 UTC [11401] LOG:  refresh window size (00:05:00) is smaller than or equal to batch size (00:05:00), falling back to single batch processing

SELECT add_continuous_aggregate_policy(
   continuous_aggregate => 'ltss_ha_metrics.cagg_energy_5mins',
   start_offset         => '15 minutes'::INTERVAL,
   end_offset           => '5 minutes'::INTERVAL,
   schedule_interval    => '2.5 minutes'::INTERVAL
);

SELECT _materialized_hypertable_24.bucket,
    _materialized_hypertable_24.entity_id,
    _materialized_hypertable_24.min_value,
    _materialized_hypertable_24.max_value,
    _materialized_hypertable_24.perc_agg
   FROM _timescaledb_internal._materialized_hypertable_24
  WHERE (_materialized_hypertable_24.bucket < COALESCE(_timescaledb_functions.to_timestamp(_timescaledb_functions.cagg_watermark(24)), '-infinity'::timestamp with time zone))
UNION ALL
 SELECT time_bucket('00:05:00'::interval, ltss."time", 'Europe/Prague'::text) AS bucket,
    ltss.entity_id,
    min((ltss.state)::text) AS min_value,
    max((ltss.state)::text) AS max_value,
    percentile_agg((ltss.state)::double precision) AS perc_agg
   FROM ltss
  WHERE ((((ltss.entity_id)::text = ANY (ltss_ha_metrics.get_entities_for_cagg_hametrics())) AND ((ltss.state)::text <> ALL ((ARRAY['unavailable'::character varying, 'unknown'::character varying])::text[]))) AND (ltss."time" >= COALESCE(_timescaledb_functions.to_timestamp(_timescaledb_functions.cagg_watermark(24)), '-infinity'::timestamp with time zone)))
  GROUP BY (time_bucket('00:05:00'::interval, ltss."time", 'Europe/Prague'::text)), ltss.entity_id;