Как упростить запрос?

SELECT DATE_TRUNC('day', dates)::DATE AS DATE,
SUM(CASE WHEN t2.id IS NOT NULL THEN t1.field1 ELSE 0 END) AS clicks,
SUM(CASE WHEN t2.id IS NOT NULL THEN t1.field2 ELSE 0 END) AS real_referrals,
SUM(CASE WHEN t2.id IS NOT NULL THEN t1.field3 ELSE 0 END) AS demo_referrals,
SUM(CASE WHEN t2.id IS NOT NULL THEN t1.field4 ELSE 0 END) AS deposits,
SUM(CASE WHEN t2.id IS NOT NULL THEN t1.field5 ELSE 0 END) AS commission
FROM GENERATE_SERIES('2023-05-01'::TIMESTAMP, '2023-05-31'::TIMESTAMP, '1 day'::INTERVAL) dates
LEFT JOIN table1 AS t1 ON DATE_TRUNC('day', t1.date)::DATE = dates
LEFT JOIN table2 AS t2 ON t1.t2_id = t2.id AND t2.user_id = '193491' AND t2.is_old = FALSE AND t2.banner_id IS NULL
GROUP BY DATE_TRUNC('day', dates)::DATE
ORDER BY 1;

CREATE INDEX ix__table2__user_id ON table2(user_id);
CREATE INDEX ix__table1__date ON table1(DATE);

WITH filtered_t2 AS (
    SELECT id 
    FROM table2 
    WHERE user_id = '193491' 
        AND is_old = FALSE 
        AND banner_id IS NULL
),
date_series AS (
    SELECT DATE_TRUNC('day', dt) AS DATE
    FROM GENERATE_SERIES('2023-05-01'::TIMESTAMP, '2023-05-31'::TIMESTAMP, '1 day'::INTERVAL) dt
)
SELECT 
    ds.date,
    SUM(CASE WHEN ft.id IS NOT NULL THEN t1.field1 ELSE 0 END) AS clicks,
    SUM(CASE WHEN ft.id IS NOT NULL THEN t1.field2 ELSE 0 END) AS real_referrals,
    SUM(CASE WHEN ft.id IS NOT NULL THEN t1.field3 ELSE 0 END) AS demo_referrals,
    SUM(CASE WHEN ft.id IS NOT NULL THEN t1.field4 ELSE 0 END) AS deposits,
    SUM(CASE WHEN ft.id IS NOT NULL THEN t1.field5 ELSE 0 END) AS commission
FROM date_series ds
LEFT JOIN table1 t1 ON DATE(t1.date) = ds.date
LEFT JOIN filtered_t2 ft ON t1.t2_id = ft.id
GROUP BY ds.date
ORDER BY ds.date;

SELECT DATE_TRUNC('day', dates):ATE AS DATE, и GROUP BY DATE_TRUNC('day', dates)::DATE

LEFT JOIN table1 AS t1 ON DATE_TRUNC('day', t1.date)::DATE = dates

ON t1.date >= dates AND t1.date < dates + 1

SELECT 
    dates::DATE AS DATE,
    SUM(t1.field1) FILTER (WHERE t2.id IS NOT NULL) AS clicks,
    SUM(t1.field2) FILTER (WHERE t2.id IS NOT NULL) AS real_referrals,
    SUM(t1.field3) FILTER (WHERE t2.id IS NOT NULL) AS demo_referrals,
    SUM(t1.field4) FILTER (WHERE t2.id IS NOT NULL) AS deposits,
    SUM(t1.field5) FILTER (WHERE t2.id IS NOT NULL) AS commission
FROM GENERATE_SERIES('2023-05-01'::DATE, '2023-05-31'::DATE, '1 day') dates
LEFT JOIN table1 t1 ON t1.date::DATE = dates
LEFT JOIN table2 t2 ON t1.t2_id = t2.id 
    AND t2.user_id = '193491' 
    AND t2.is_old = FALSE 
    AND t2.banner_id IS NULL
GROUP BY dates
ORDER BY DATE;

SELECT 
    dates.date,
    COALESCE(SUM(t1.field1), 0) AS clicks,
    COALESCE(SUM(t1.field1), 0) AS real_referrals,
    COALESCE(SUM(t1.field3), 0) AS demo_referrals,
    COALESCE(SUM(t1.field4), 0) AS deposits,
    COALESCE(SUM(t1.field5), 0) AS commission
FROM (
    SELECT GENERATE_SERIES('2023-05-01'::DATE, '2023-05-31'::DATE, '1 day') AS DATE
) dates
LEFT JOIN (
    SELECT t1.* 
    FROM table1 t1
    WHERE EXISTS (
        SELECT 1 FROM table2 t2 
        WHERE t2.id = t1.t2_id 
        AND t2.user_id = '193491' 
        AND t2.is_old = FALSE 
        AND t2.banner_id IS NULL
    )
    AND t1.date >= '2023-05-01' AND t1.date < '2023-06-01'
) t1 ON t1.date::DATE = dates.date
GROUP BY dates.date
ORDER BY dates.date;