Programming, Sql, Postgresql, Performance, Data Engineering.
) AS unrolled_urls WHERE urls.id = unrolled_urls.rec_url_id AND urls.url ILIKE '%enterprise_customer.com/jobs%' ); And the final query execution time: Time: 1898.717 ms Should we start celebrating?!? Not so fast! We still had to verify correctness. I was extremely suspicious of the EXISTS