top | item 24840131

(no title)

rolls-reus | 5 years ago

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

discuss

order

malisper|5 years ago

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

jerrysievert|5 years ago

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