| replaceDistributeUnderJoinChild(Plan, Plan) |   | 63% | | 60% | 3 | 6 | 8 | 22 | 0 | 1 |
| sliceHashSpec(DistributionSpecHash, List) | | 0% | | n/a | 1 | 1 | 2 | 2 | 1 | 1 |
| tryPruneGlobalAgg(PhysicalHashAggregate, CascadesContext) | | 96% | | 80% | 5 | 14 | 3 | 42 | 0 | 1 |
| maybePruneShuffleJoin(PhysicalHashJoin, CascadesContext) | | 98% | | 88% | 2 | 10 | 1 | 36 | 0 | 1 |
| findHashDistributeUnderJoinChild(Plan) | | 100% | | 91% | 1 | 7 | 0 | 9 | 0 | 1 |
| processRoot(Plan, CascadesContext) | | 100% | | 100% | 0 | 3 | 0 | 6 | 0 | 1 |
| deriveHashJoinChildAllowShuffleKeyPrune(PhysicalHashJoin, boolean) | | 100% | | 100% | 0 | 3 | 0 | 5 | 0 | 1 |
| statisticsForShuffleKeyPruneBelowDistribute(PhysicalDistribute) | | 100% | | 100% | 0 | 3 | 0 | 6 | 0 | 1 |
| rebuildDistribute(PhysicalDistribute, DistributionSpecHash, Plan) | | 100% | | n/a | 0 | 1 | 0 | 4 | 0 | 1 |
| ShuffleKeyPruner() | | 100% | | n/a | 0 | 1 | 0 | 1 | 0 | 1 |
| asHashJoin(Plan) | | 100% | | n/a | 0 | 1 | 0 | 1 | 0 | 1 |
| asAgg(Plan) | | 100% | | n/a | 0 | 1 | 0 | 1 | 0 | 1 |