One thing to note, if this is a query you would like to run on a replica,
temp tables are a non-starter.
I really wish that wasn't the case. I have quite a few analytical queries I
had to optimize with temp tables and indexes, and I really wish I could run
on my hot standby.
I in most cases I can't refactor them to use a CTE for performance reasons.
Anyways, my 2¢.
- Adam