Programming, Sql, Postgresql, Performance, Data Engineering.
that not only was this operation expensive, it ran multiple times. I then verified it by isolating the clause SELECT 1 FROM acc_{account_id}.urls as recordings_urls, acc_{account_id}.recording_data_30 as recording_data_30, acc_{account_id}.sessions_30 as sessions_30 WHERE urls && array( select id