[Feature]: refresh_all_continuous_aggregates

[salisbury-espinosa]

What problem does the new feature solve?

CREATE OR REPLACE PROCEDURE "refresh_all_continuous_aggregates"() 
    LANGUAGE PLPGSQL 
    AS $$
    DECLARE
        "view_name_current" name;
        "view_name_list" name[];
    BEGIN
        "view_name_list" := ARRAY(
                SELECT 
                  "view_name"  
                FROM 
                  "timescaledb_information"."continuous_aggregates"
            );
        FOREACH "view_name_current" IN ARRAY "view_name_list" LOOP
          RAISE info 'refresh_continuous_aggregate for %', "view_name_current";
          CALL refresh_continuous_aggregate(
            format('"%s"', "view_name_current")::REGCLASS, 
            window_start := '-infinity'::timestamptz, 
            window_end := now() 
          );
        END LOOP;
    END;$$;

What does the feature do?

refresh all continuous aggregates