Optimizing a PostgreSQL query from 24 mins down to 2 seconds

Using the platform, you can make arbitrarily complex queries on large data sets. The clause in the original query is:

Which means that we do pattern matching on our URLs, then take an intersection with all the urls common with the recordings. Simple check was to simple do a on both the slow and fast queries on many different sets of data.

Source: parallelthoughts.xyz