[rolls-reus]

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

[malisper]

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

[jerrysievert]

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