Programming, Sql, Postgresql, Performance, Data Engineering.
nothing else, I would simply do - SELECT urls.url FROM acc_{account_id}.urls as urls, ( SELECT unnest(recording_data.urls) AS id ) AS unrolled_urls WHERE urls.id = unrolled_urls.id AND urls.url ILIKE '%jobs%' Instead of the JOIN syntax, I just used a sub-query, and unrolled the recording_data.urls