Programming, Sql, Postgresql, Performance, Data Engineering.
to_timestamp(1549177599) AND recording_data.duration >=5 AND recording_data.num_of_pages > 0 ; count 32519 (1 row) Time: 1636.637 ms Yep. The subquery, when wrapped with EXISTS, makes the entire thing super-fast. The interesting question to ask therefore, is that Why were both the overall query