These two types of node are used for shuffling rows around between nodes in some types of UNION and sub-select queries. They have little performance impact and have also become rare in current PostgreSQL versions due to the HashAggregate optimizations.
Subquery scan and subplan
Get PostgreSQL 10 High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
