Programming, Sql, Postgresql, Performance, Data Engineering.
'%enterprise_customer.com/jobs%')::text[] ) AND r_time > to_timestamp(1542585600) AND r_time < to_timestamp(1545177599) AND recording_data.duration >=5 AND recording_data.num_of_pages > 0; Here are the timings: Planning time: 1.480 ms Execution time: 1431924.650 ms It ran on around 150k rows. The