It used to be like this (i remember in past postgres versions CTEs had worse performance than subqueries), but not anymore.