I hit this recently too, where a complex query was taking ~300ms, and I decided to fold some sub queries into a CTE, and it promptly (pun intended) went down to

I hit this recently too, where a complex query was taking ~300ms, and I decided to fold some sub queries into a CTE, and it promptly (pun intended) went down to ~30ms. Plus point, it made my query easier to understand too!