Programming, Sql, Postgresql, Performance, Data Engineering.
recordings_urls.id AND r_time > to_timestamp(1542585600) AND r_time < to_timestamp(1545177599) AND recording_data.duration >=5 AND recording_data.num_of_pages > 0 AND EXISTS( SELECT urls.url FROM acc_{account_id}.urls as urls, ( SELECT unnest(urls) AS rec_url_id FROM acc_{account_id}.recording_data