Programming, Sql, Postgresql, Performance, Data Engineering.
recordings_urls, acc_{account_id}.recording_data as recording_data, acc_{account_id}.sessions as sessions WHERE recording_data.usp_id = sessions.usp_id AND sessions.referrer_id = recordings_urls.id AND ( urls && array( select id from acc_{account_id}.urls WHERE url ILIKE