News for hackers. Stuff that matters.

A comment on The surprising impact of medium-size texts on PostgreSQL performance. Parent comment

Re:The surprising impact of medium-size texts on PostgreSQL ... by rolls-reus on Tuesday October 20, 2020 @01:32PM (#24840131)
How do you find out that the optimiser inlined the subquery? Is this visible in the explain output?
[ Parent | on HN ]
Re:The surprising impact of medium-size texts on PostgreSQL ... by malisper on Tuesday October 20, 2020 @01:47PM (#24840308)
IIRC, EXPLAIN VERBOSE will show you the columns being selected by each step of the plan. The inlining showed up there.
[ Parent | on HN ]
Re:The surprising impact of medium-size texts on PostgreSQL ... by jerrysievert on Tuesday October 20, 2020 @11:41PM (#24844555)
or better yet: EXPLAIN ANALYZE VERBOSE - that will give you a little bit better picture.
[ Parent | on HN ]