Programming, Sql, Postgresql, Performance, Data Engineering.
acc_{account_id}.sessions as sessions WHERE recording_data.usp_id = sessions.usp_id AND ( 1 = 1 ) AND sessions.referrer_id = recordings_urls.id AND (exists( select id from acc_{account_id}.urls where url ILIKE '%enterprise_customer.com/jobs%') ) AND r_time > to_timestamp(1547585600) AND r_time <