Hacker News Reader

How do you find out that the optimiser inlined the subquery? Is this visible in the explain output?

IIRC, EXPLAIN VERBOSE will show you the columns being selected by each step of the plan. The inlining showed up there.

or better yet: EXPLAIN ANALYZE VERBOSE - that will give you a little bit better picture.