Partition query: prune or append

A and B are separate queries; conceptual flow, not timing

Partition query: prune or append A and B are separate queries; conceptual flow, not timing A: user + February range Plan: February scan only Index Scan: February One matching row A: one row B: user only; no date range Plan: Append of three scans Read Jan / Feb / Mar indexes Rows from each child B: Append streams three rows Client · Sequence participant Client Planner · Sequence participant Planner Executor · Sequence participant Executor Partitions · Sequence participant Partitions Legend return default message