| replaceDistributeUnderJoinChild(Plan, Plan) |  | 0% | | 0% | 6 | 6 | 22 | 22 | 1 | 1 |
| tryPruneGlobalAgg(PhysicalHashAggregate, CascadesContext) |  | 66% | | 69% | 6 | 14 | 13 | 42 | 0 | 1 |
| maybePruneShuffleJoin(PhysicalHashJoin, CascadesContext) | | 59% | | 72% | 5 | 10 | 12 | 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 |
| processRoot(Plan, CascadesContext) | | 75% | | 50% | 2 | 3 | 2 | 6 | 0 | 1 |
| statisticsForShuffleKeyPruneBelowDistribute(PhysicalDistribute) | | 88% | | 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% | | 91% | 1 | 7 | 0 | 9 | 0 | 1 |
| deriveHashJoinChildAllowShuffleKeyPrune(PhysicalHashJoin, boolean) | | 100% | | 100% | 0 | 3 | 0 | 5 | 0 | 1 |
| ShuffleKeyPruner() | | 100% | | n/a | 0 | 1 | 0 | 1 | 0 | 1 |