How do you find out that the optimiser inlined the subquery? Is this visible in ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		rolls-reus on Oct 20, 2020 \| parent \| context \| favorite \| on: The surprising impact of medium-size texts on Post... How do you find out that the optimiser inlined the subquery? Is this visible in the explain output?

malisper on Oct 20, 2020 [–]

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

jerrysievert on Oct 21, 2020 | [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact