3 ms·
How do you find out that the optimiser inlined the subquery? Is this visible in the explain output?
by rolls-reus 6y ago
How do you find out that the optimiser inlined the subquery? Is this visible in the explain output?
- malisper 6y agoIIRC, EXPLAIN VERBOSE will show you the columns being selected by each step of the plan. The inlining showed up there.
- jerrysievert 6y agoor better yet: EXPLAIN ANALYZE VERBOSE - that will give you a little bit better picture.