Postgres Partition Pruning

The slow phase is the planner, and the index you add makes it slower

EXPLAIN prints planning and execution time side by side. In a Timescale walkthrough of a 500-partition table, the planner touched 21 times more pages than the query did.