Re:Following a Select Statement Through Postgres Internals (...
by anarazel on Sunday April 10, 2016 @07:41PM
(#11468750)
That paper's definition of rewriting isn't the same as postgres' (they even say that: "The work presented here should not be confused with the query rewrite facility of POSTGRES [SJGP90]."). Flattening subqueries and views happens during planning in postgres.
Source: I'm a PostgreSQL Developer.