In Postgres, common table expressions are planned and executed separately. I think of it as each section builds a temp table. This can be a good or bad thing,

In Postgres, common table expressions are planned and executed separately. I think of it as each section builds a temp table. This can be a good or bad thing, but it's sometimes important to know that it's happening.