我想使用一个函数来按计划调用everyday来实现多个视图。它看起来像这样：

CREATE OR REPLACE FUNCTION refresh_my_views()
 RETURNS void
 LANGUAGE plpgsql
AS $function$
DECLARE
    -- Array of view names in the order they should be refreshed
    views text[] := ARRAY[
        'view1',
        'view2',
        'view3'
        -- ... add more view names here as needed
    ];
    view_name text;
    start_time timestamp;
    end_time timestamp;
BEGIN
    -- Iterate over each view name in the array
    FOREACH view_name IN ARRAY views LOOP
        -- Log the start of the refresh operation
        RAISE NOTICE 'Starting refresh of %', view_name;
        
        -- Start the timer
        start_time := current_timestamp;

        -- Refresh the materialized view
        EXECUTE format('REFRESH MATERIALIZED VIEW CONCURRENTLY %s', view_name);
        
        -- Stop the timer
        end_time := current_timestamp;

        -- Log the completion of the refresh operation and the time taken
        RAISE NOTICE 'Completed refresh of % (Time: %)', 
                      view_name, age(end_time, start_time);
    END LOOP;
END;
$function$;

字符串
但是这个函数运行时间超过了12个小时，似乎过了一段时间我不能通过它的PID事件pg_terminate_backend，我不能运行另一个命令来并行刷新任何这些视图。视图创建速度很快，即使是最长的一个刷新也不应该超过15分钟。我也没有看到RAISE NOTICE语句的消息。
它应该只是打印时间，最多需要大约30分钟，并完成它。