My site has a query that joins several tables, some with many thousands of rows. When the cache misses, this can leave users waiting for 10+ second queries, sometimes over 20 seconds.
The largest tables involved are
bookings, with approximately 50k rows each. You can view the full query + plan here: https://explain.dalibo.com/plan/1BE.
I added an additional index recently (to
event_occurrences.start_time), but the query is still very slow. Perhaps I should add a composite index with
blackout instead? Any other suggestions to speed this query up without a total schema redesign?