Re: Foreman query optimization

[Rick James]

`logs` is a lot larger than `sources`, so there must be a lot of duplicate `source_id` values, correct? So, let's dedup to make things smaller and hopefully faster:

CREATE TEMPORARY TABLE t (
    PRIMARY KEY (source_id)
)
SELECT DISTINCT source_id FROM logs;

DELETE
    FROM from sources as s
    left join t on s.id = t.source_id
    where t.source_id is NULL;