| tryPruneGlobalAgg(PhysicalHashAggregate, CascadesContext) |   | 66% | | 69% | 6 | 14 | 13 | 42 | 0 | 1 |
| maybePruneShuffleJoin(PhysicalHashJoin, CascadesContext) | | 60% | | 72% | 5 | 10 | 11 | 36 | 0 | 1 |
| rebuildDistribute(PhysicalDistribute, DistributionSpecHash, Plan) | | 0% | | n/a | 1 | 1 | 4 | 4 | 1 | 1 |
| sliceHashSpec(DistributionSpecHash, List) | | 0% | | n/a | 1 | 1 | 2 | 2 | 1 | 1 |
| replaceDistributeUnderJoinChild(Plan, Plan) | | 91% | | 70% | 3 | 6 | 3 | 22 | 0 | 1 |
| processRoot(Plan, CascadesContext) | | 81% | | 75% | 1 | 3 | 1 | 6 | 0 | 1 |
| asHashJoin(Plan) | | 0% | | n/a | 1 | 1 | 1 | 1 | 1 | 1 |
| asAgg(Plan) | | 0% | | n/a | 1 | 1 | 1 | 1 | 1 | 1 |
| findHashDistributeUnderJoinChild(Plan) | | 100% | | 100% | 0 | 7 | 0 | 9 | 0 | 1 |
| deriveHashJoinChildAllowShuffleKeyPrune(PhysicalHashJoin, boolean) | | 100% | | 100% | 0 | 3 | 0 | 5 | 0 | 1 |
| statisticsForShuffleKeyPruneBelowDistribute(PhysicalDistribute) | | 100% | | 100% | 0 | 3 | 0 | 6 | 0 | 1 |
| ShuffleKeyPruner() | | 100% | | n/a | 0 | 1 | 0 | 1 | 0 | 1 |