Created
April 17, 2020 04:28
-
-
Save yuzefovich/a4743518fb73c280464401ffdfc12751 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name old time/op new time/op delta | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=4-24 1.18ms ± 1% 0.88ms ± 1% -25.62% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=4-24 1.18ms ± 0% 0.88ms ± 0% -25.57% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=4-24 1.18ms ± 1% 0.88ms ± 1% -25.48% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=2-24 622µs ± 0% 473µs ± 0% -23.99% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=2-24 621µs ± 0% 472µs ± 1% -23.96% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=2-24 622µs ± 0% 474µs ± 1% -23.81% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=4-24 86.3µs ± 2% 66.3µs ± 1% -23.22% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=4-24 86.3µs ± 1% 66.3µs ± 1% -23.18% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=4-24 86.1µs ± 2% 66.5µs ± 1% -22.70% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=2-24 47.3µs ± 1% 37.5µs ± 2% -20.73% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=2-24 47.4µs ± 1% 37.6µs ± 1% -20.71% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=2-24 47.3µs ± 1% 37.6µs ± 2% -20.49% (p=0.008 n=5+5) | |
| Offset-24 1.71µs ± 1% 1.43µs ± 1% -16.75% (p=0.008 n=5+5) | |
| ProjPlusInt64Int64ConstOp/useSel=false,hasNulls=false-24 2.16µs ± 1% 1.80µs ± 1% -16.69% (p=0.008 n=5+5) | |
| OrderedSynchronizer-24 89.7µs ± 2% 75.8µs ± 1% -15.49% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=2/avgChunkSize=128-24 6.38ms ± 8% 5.69ms ± 3% -10.84% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=3/avgChunkSize=128-24 4.13ms ± 6% 3.79ms ± 7% -8.33% (p=0.032 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=128/spillForced=false-24 844ms ± 4% 776ms ± 5% -8.04% (p=0.016 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=3/avgChunkSize=8-24 2.96ms ± 2% 2.77ms ± 2% -6.16% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=0-24 7.56ms ± 0% 7.14ms ± 0% -5.58% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=0-24 8.62ms ± 2% 8.16ms ± 0% -5.36% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=0-24 7.64ms ± 1% 7.23ms ± 1% -5.32% (p=0.008 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/int_to_decimal-24 682µs ± 1% 649µs ± 2% -4.84% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=0-24 4.54ms ± 1% 4.32ms ± 0% -4.76% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=4/topK=false-24 415µs ± 4% 396µs ± 1% -4.72% (p=0.016 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=2/matchLen=1/avgChunkSize=8-24 1.99ms ± 6% 1.89ms ± 1% -4.72% (p=0.016 n=5+5) | |
| CastOp/useSel=false/hasNulls=true/int_to_decimal-24 666µs ± 1% 635µs ± 2% -4.56% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=128/spillForced=false-24 980ms ± 3% 937ms ± 3% -4.40% (p=0.032 n=5+5) | |
| CastOp/useSel=true/hasNulls=true/int_to_decimal-24 670µs ± 1% 640µs ± 2% -4.39% (p=0.008 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/int_to_decimal-24 680µs ± 1% 651µs ± 2% -4.26% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 520µs ± 1% 497µs ± 1% -4.25% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 740µs ± 1% 713µs ± 1% -3.73% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=4/spillForced=false-24 1.37ms ± 0% 1.33ms ± 0% -3.52% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=0-24 525µs ± 1% 507µs ± 1% -3.49% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 796µs ± 4% 769µs ± 1% -3.43% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=0-24 5.26ms ± 3% 5.09ms ± 2% -3.25% (p=0.016 n=5+5) | |
| ExternalSort/rows=262144/cols=4/spilled=true-24 81.8ms ± 3% 79.3ms ± 3% -3.03% (p=0.016 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=0-24 744µs ± 1% 725µs ± 1% -2.56% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=4/spillForced=false-24 1.51ms ± 1% 1.48ms ± 0% -2.02% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=3/avgChunkSize=8-24 10.4ms ± 1% 10.2ms ± 1% -1.81% (p=0.016 n=5+5) | |
| Sort/rows=262144/cols=1/topK=true-24 4.77ms ± 0% 4.72ms ± 0% -0.93% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=false,hasNulls=false-24 4.23µs ± 0% 4.19µs ± 3% ~ (p=0.730 n=4+5) | |
| BuiltinFunctions/useSel=true,hasNulls=true-24 196µs ± 2% 196µs ± 0% ~ (p=0.190 n=5+4) | |
| BuiltinFunctions/useSel=true,hasNulls=false-24 199µs ± 3% 199µs ± 6% ~ (p=1.000 n=5+5) | |
| BuiltinFunctions/useSel=false,hasNulls=true-24 195µs ± 1% 194µs ± 1% ~ (p=0.905 n=5+4) | |
| BuiltinFunctions/useSel=false,hasNulls=false-24 198µs ± 2% 196µs ± 2% ~ (p=0.421 n=5+5) | |
| CompareSpecializedOperators/DefaultBuiltinOperator-24 890µs ± 2% 882µs ± 1% ~ (p=0.421 n=5+5) | |
| CompareSpecializedOperators/SpecializedSubstringOperator-24 53.6µs ± 1% 53.7µs ± 0% ~ (p=0.151 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/int_to_float-24 1.18µs ± 4% 1.21µs ± 6% ~ (p=0.310 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/int_to_float-24 2.29µs ± 0% 2.29µs ± 1% ~ (p=0.310 n=5+5) | |
| CastOp/useSel=true/hasNulls=true/float_to_decimal-24 1.77ms ± 1% 1.77ms ± 1% ~ (p=1.000 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/float_to_decimal-24 1.90ms ± 1% 1.90ms ± 1% ~ (p=0.841 n=5+5) | |
| CastOp/useSel=false/hasNulls=true/float_to_decimal-24 1.76ms ± 1% 1.76ms ± 1% ~ (p=0.841 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/float_to_decimal-24 1.89ms ± 1% 1.90ms ± 0% ~ (p=0.222 n=5+5) | |
| Columnarize-24 772µs ± 2% 771µs ± 1% ~ (p=1.000 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 411µs ± 9% 407µs ± 6% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=1-24 221µs ± 5% 212µs ± 3% ~ (p=0.056 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 493µs ± 7% 498µs ± 6% ~ (p=0.222 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=2-24 305µs ± 2% 316µs ± 8% ~ (p=0.222 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=0-24 2.74ms ± 1% 2.76ms ± 0% ~ (p=0.095 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=1-24 2.52ms ± 4% 2.51ms ± 7% ~ (p=0.730 n=4+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=2-24 3.49ms ± 0% 3.56ms ±14% ~ (p=0.690 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=0-24 409µs ± 8% 408µs ± 6% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=1-24 270µs ±11% 285µs ±14% ~ (p=0.548 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=0-24 507µs ± 7% 499µs ± 2% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=2-24 439µs ±17% 416µs ± 8% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=1-24 3.64ms ±10% 3.74ms ±20% ~ (p=1.000 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=0-24 4.10ms ± 4% 4.14ms ± 2% ~ (p=0.222 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=2-24 5.23ms ±30% 5.20ms ±22% ~ (p=1.000 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 443µs ± 7% 438µs ± 8% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=1-24 941µs ±14% 842µs ±18% ~ (p=0.222 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 538µs ± 1% 537µs ± 2% ~ (p=0.905 n=4+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=2-24 1.45ms ±14% 1.43ms ±19% ~ (p=0.841 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=0-24 3.39ms ± 2% 3.39ms ± 2% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=1-24 13.5ms ±17% 13.5ms ±35% ~ (p=1.000 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=0-24 4.92ms ± 1% 4.95ms ± 3% ~ (p=1.000 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=2-24 21.3ms ± 8% 21.1ms ±14% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=1-24 284µs ± 8% 292µs ± 7% ~ (p=0.222 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=2-24 418µs ± 7% 453µs ± 5% ~ (p=0.056 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=1-24 3.70ms ±14% 3.87ms ±10% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=2-24 5.53ms ± 7% 6.12ms ±16% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=1-24 361µs ±10% 383µs ± 9% ~ (p=0.310 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=2-24 561µs ±10% 597µs ±17% ~ (p=0.421 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=0-24 4.60ms ± 2% 4.46ms ± 4% ~ (p=0.095 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=1-24 5.15ms ±11% 5.10ms ±12% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=2-24 7.40ms ±15% 8.01ms ±21% ~ (p=0.421 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 558µs ± 2% 550µs ± 3% ~ (p=0.095 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=1-24 1.00ms ±16% 1.03ms ±18% ~ (p=0.690 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=2-24 1.65ms ± 7% 1.71ms ±13% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=1-24 14.7ms ±14% 16.2ms ±22% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=2-24 22.8ms ±16% 24.6ms ±13% ~ (p=0.421 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=128/spillForced=false-24 699ms ± 3% 721ms ± 7% ~ (p=0.095 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=128/spillForced=true-24 415ms ± 1% 416ms ± 1% ~ (p=0.222 n=5+5) | |
| ExternalSort/rows=2048/cols=1/spilled=false-24 54.0µs ± 2% 54.3µs ± 1% ~ (p=0.222 n=5+5) | |
| ExternalSort/rows=2048/cols=1/spilled=true-24 417µs ± 1% 418µs ± 0% ~ (p=0.968 n=5+5) | |
| ExternalSort/rows=2048/cols=2/spilled=false-24 281µs ± 4% 283µs ± 3% ~ (p=0.841 n=5+5) | |
| ExternalSort/rows=2048/cols=2/spilled=true-24 789µs ± 2% 790µs ± 0% ~ (p=0.690 n=5+5) | |
| ExternalSort/rows=2048/cols=4/spilled=false-24 401µs ± 3% 401µs ± 2% ~ (p=1.000 n=5+5) | |
| ExternalSort/rows=2048/cols=4/spilled=true-24 1.10ms ± 1% 1.09ms ± 1% ~ (p=0.151 n=5+5) | |
| ExternalSort/rows=16384/cols=1/spilled=true-24 930µs ± 1% 936µs ± 1% ~ (p=0.222 n=5+5) | |
| ExternalSort/rows=16384/cols=2/spilled=false-24 2.34ms ± 7% 2.31ms ± 5% ~ (p=0.690 n=5+5) | |
| ExternalSort/rows=16384/cols=2/spilled=true-24 3.14ms ± 5% 3.10ms ± 4% ~ (p=0.690 n=5+5) | |
| ExternalSort/rows=16384/cols=4/spilled=false-24 3.25ms ± 5% 3.21ms ± 4% ~ (p=0.548 n=5+5) | |
| ExternalSort/rows=16384/cols=4/spilled=true-24 4.75ms ± 3% 4.81ms ± 1% ~ (p=0.690 n=5+5) | |
| ExternalSort/rows=262144/cols=2/spilled=false-24 41.7ms ± 5% 41.2ms ± 4% ~ (p=1.000 n=5+5) | |
| ExternalSort/rows=262144/cols=2/spilled=true-24 49.5ms ± 5% 48.7ms ± 5% ~ (p=0.548 n=5+5) | |
| ExternalSort/rows=262144/cols=4/spilled=false-24 64.5ms ± 3% 64.6ms ± 4% ~ (p=1.000 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=4194304-24 431ms ± 3% 441ms ± 1% ~ (p=0.095 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=262144-24 39.6ms ± 2% 40.8ms ± 4% ~ (p=0.095 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=4194304-24 1.04s ± 2% 1.06s ± 2% ~ (p=0.222 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=262144-24 42.5ms ± 3% 42.6ms ± 3% ~ (p=0.841 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=4194304-24 1.12s ± 2% 1.11s ± 4% ~ (p=0.310 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=2048-24 470µs ± 1% 475µs ± 1% ~ (p=0.222 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=262144-24 44.1ms ± 1% 44.2ms ± 1% ~ (p=0.690 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=4194304-24 701ms ± 1% 698ms ± 1% ~ (p=0.310 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=262144-24 55.3ms ± 2% 55.9ms ± 2% ~ (p=0.421 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=4194304-24 1.37s ± 3% 1.35s ± 2% ~ (p=0.421 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=4194304-24 731ms ± 1% 731ms ± 1% ~ (p=1.000 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=2048-24 505µs ± 1% 511µs ± 2% ~ (p=0.310 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=262144-24 58.8ms ± 3% 58.7ms ± 3% ~ (p=0.841 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=4194304-24 1.42s ± 2% 1.41s ± 3% ~ (p=0.690 n=5+5) | |
| LikeOps/selPrefixBytesBytesConstOp-24 13.2µs ± 0% 13.1µs ± 0% ~ (p=0.444 n=5+5) | |
| LikeOps/selSuffixBytesBytesConstOp-24 13.9µs ± 2% 13.8µs ± 0% ~ (p=0.056 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=1024-24 106µs ± 3% 106µs ± 0% ~ (p=0.151 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=4096-24 1.01ms ± 0% 1.01ms ± 0% ~ (p=0.151 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=16384-24 4.72ms ± 1% 4.73ms ± 0% ~ (p=0.222 n=5+5) | |
| Ordinality-24 3.35µs ± 1% 3.35µs ± 1% ~ (p=0.651 n=5+5) | |
| ParallelUnorderedSynchronizer-24 1.73µs ± 3% 1.72µs ± 4% ~ (p=0.643 n=5+5) | |
| ProjPlusInt64Int64ConstOp/useSel=true,hasNulls=false-24 3.22µs ± 1% 3.24µs ± 1% ~ (p=0.151 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=2-24 134µs ± 4% 133µs ± 2% ~ (p=0.690 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=4-24 246µs ± 4% 249µs ± 1% ~ (p=0.222 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=8-24 408µs ± 4% 422µs ± 4% ~ (p=0.222 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=16-24 684µs ± 3% 705µs ± 3% ~ (p=0.222 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=2-24 146µs ± 5% 146µs ± 6% ~ (p=0.548 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=4-24 256µs ± 3% 254µs ± 0% ~ (p=0.286 n=5+4) | |
| HashRouter/numOutputs=4/numInputBatches=8-24 419µs ± 2% 426µs ± 1% ~ (p=0.310 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=16-24 695µs ± 2% 704µs ± 3% ~ (p=0.151 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=2-24 157µs ± 2% 157µs ± 2% ~ (p=0.841 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=4-24 263µs ± 2% 264µs ± 1% ~ (p=1.000 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=8-24 428µs ± 4% 432µs ± 3% ~ (p=0.151 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=16-24 712µs ± 3% 728µs ± 3% ~ (p=0.095 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=2-24 176µs ± 1% 181µs ± 9% ~ (p=0.556 n=4+5) | |
| HashRouter/numOutputs=16/numInputBatches=4-24 272µs ± 1% 278µs ± 5% ~ (p=0.151 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=8-24 441µs ± 4% 450µs ± 6% ~ (p=0.095 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=16-24 726µs ± 4% 743µs ± 3% ~ (p=0.095 n=5+5) | |
| SelectInInt64/useSel=true,hasNulls=false-24 7.91µs ± 1% 7.87µs ± 0% ~ (p=0.421 n=5+5) | |
| SelectInInt64/useSel=false,hasNulls=false-24 6.44µs ± 1% 6.42µs ± 0% ~ (p=0.310 n=5+5) | |
| SelLTInt64Int64ConstOp/useSel=true,hasNulls=false-24 2.16µs ± 1% 2.14µs ± 1% ~ (p=0.056 n=5+5) | |
| SelLTInt64Int64ConstOp/useSel=false,hasNulls=false-24 2.16µs ± 0% 2.16µs ± 0% ~ (p=0.619 n=5+5) | |
| SelLTInt64Int64Op/useSel=true,hasNulls=false-24 3.20µs ± 0% 3.20µs ± 1% ~ (p=0.587 n=5+5) | |
| SelLTInt64Int64Op/useSel=false,hasNulls=false-24 1.72µs ± 0% 1.74µs ± 2% ~ (p=0.103 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=2/matchLen=1/avgChunkSize=8-24 170µs ± 3% 166µs ± 5% ~ (p=0.151 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=2/matchLen=1/avgChunkSize=128-24 324µs ±18% 308µs ±11% ~ (p=0.841 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=2/matchLen=1/avgChunkSize=128-24 491µs ± 9% 478µs ± 4% ~ (p=0.548 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=1/avgChunkSize=8-24 419µs ± 3% 415µs ± 1% ~ (p=0.548 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=1/avgChunkSize=8-24 677µs ± 4% 654µs ± 2% ~ (p=0.056 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=1/avgChunkSize=128-24 625µs ±12% 579µs ± 7% ~ (p=0.151 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=1/avgChunkSize=128-24 753µs ± 4% 756µs ± 6% ~ (p=0.841 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=2/avgChunkSize=8-24 322µs ± 2% 322µs ± 4% ~ (p=0.841 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=2/avgChunkSize=8-24 653µs ± 1% 651µs ± 4% ~ (p=0.548 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=2/avgChunkSize=128-24 469µs ±10% 440µs ± 7% ~ (p=0.222 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=2/avgChunkSize=128-24 695µs ± 1% 682µs ± 3% ~ (p=0.095 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=3/avgChunkSize=8-24 245µs ± 2% 239µs ± 4% ~ (p=0.095 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=3/avgChunkSize=8-24 625µs ± 5% 632µs ± 6% ~ (p=0.690 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=3/avgChunkSize=128-24 325µs ± 6% 307µs ± 4% ~ (p=0.151 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=3/avgChunkSize=128-24 627µs ± 2% 617µs ± 4% ~ (p=0.310 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=2/matchLen=1/avgChunkSize=8-24 7.27ms ± 2% 7.16ms ± 2% ~ (p=0.095 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=2/matchLen=1/avgChunkSize=128-24 4.17ms ±17% 3.88ms ± 9% ~ (p=0.421 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=2/matchLen=1/avgChunkSize=128-24 8.29ms ± 5% 8.35ms ± 8% ~ (p=1.000 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=1/avgChunkSize=8-24 5.48ms ± 7% 5.37ms ± 3% ~ (p=0.548 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=1/avgChunkSize=8-24 11.3ms ± 1% 11.3ms ± 1% ~ (p=1.000 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=1/avgChunkSize=128-24 8.12ms ± 5% 8.24ms ±10% ~ (p=1.000 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=1/avgChunkSize=128-24 12.9ms ± 4% 12.9ms ± 4% ~ (p=0.841 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=2/avgChunkSize=8-24 4.11ms ± 3% 4.01ms ± 4% ~ (p=0.151 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=2/avgChunkSize=8-24 11.0ms ± 2% 10.9ms ± 1% ~ (p=0.421 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=2/avgChunkSize=128-24 12.1ms ± 4% 11.7ms ± 5% ~ (p=0.151 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=3/avgChunkSize=128-24 10.5ms ± 2% 10.6ms ± 3% ~ (p=0.222 n=5+5) | |
| Sort/rows=2048/cols=2/topK=false-24 276µs ± 3% 282µs ± 3% ~ (p=0.421 n=5+5) | |
| Sort/rows=2048/cols=2/topK=true-24 291µs ± 4% 288µs ± 4% ~ (p=0.548 n=5+5) | |
| Sort/rows=2048/cols=4/topK=true-24 320µs ± 1% 325µs ± 1% ~ (p=0.056 n=5+5) | |
| Sort/rows=16384/cols=1/topK=true-24 329µs ± 0% 328µs ± 1% ~ (p=0.421 n=5+5) | |
| Sort/rows=16384/cols=2/topK=false-24 2.35ms ± 6% 2.41ms ± 6% ~ (p=0.690 n=5+5) | |
| Sort/rows=16384/cols=2/topK=true-24 796µs ± 1% 800µs ± 1% ~ (p=0.690 n=5+5) | |
| Sort/rows=16384/cols=4/topK=false-24 3.32ms ± 6% 3.45ms ± 5% ~ (p=0.151 n=5+5) | |
| Sort/rows=16384/cols=4/topK=true-24 873µs ± 1% 874µs ± 1% ~ (p=1.000 n=5+5) | |
| Sort/rows=262144/cols=1/topK=false-24 6.08ms ± 1% 6.21ms ± 2% ~ (p=0.056 n=5+5) | |
| Sort/rows=262144/cols=2/topK=false-24 42.9ms ± 5% 41.7ms ± 4% ~ (p=0.421 n=5+5) | |
| Sort/rows=262144/cols=2/topK=true-24 7.56ms ± 1% 7.63ms ± 2% ~ (p=0.151 n=5+5) | |
| Sort/rows=262144/cols=4/topK=false-24 64.8ms ± 4% 66.2ms ± 5% ~ (p=0.421 n=5+5) | |
| Sort/rows=262144/cols=4/topK=true-24 7.90ms ± 1% 7.89ms ± 1% ~ (p=0.548 n=5+5) | |
| AllSpooler/rows=16384/cols=4-24 566µs ± 2% 579µs ± 1% ~ (p=0.056 n=5+5) | |
| AllSpooler/rows=262144/cols=2-24 6.26ms ± 3% 6.34ms ± 2% ~ (p=0.421 n=5+5) | |
| AllSpooler/rows=262144/cols=4-24 13.0ms ± 1% 13.0ms ± 1% ~ (p=0.841 n=5+5) | |
| LikeOps/selRegexpBytesBytesConstOp-24 664µs ± 0% 669µs ± 1% +0.72% (p=0.032 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=262144-24 45.8ms ± 0% 46.2ms ± 0% +0.75% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=32768-24 12.2ms ± 1% 12.3ms ± 0% +0.88% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=1/topK=true-24 66.0µs ± 0% 66.9µs ± 1% +1.34% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=1/topK=false-24 353µs ± 1% 358µs ± 0% +1.38% (p=0.016 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=2048-24 483µs ± 1% 491µs ± 1% +1.55% (p=0.032 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=4/spillForced=true-24 6.53ms ± 1% 6.64ms ± 1% +1.68% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=128/spillForced=true-24 549ms ± 1% 559ms ± 1% +1.74% (p=0.008 n=5+5) | |
| MergeJoiner/rows=16384-24 1.44ms ± 0% 1.47ms ± 0% +1.74% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=0-24 3.98ms ± 0% 4.05ms ± 2% +1.78% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=4/spillForced=true-24 6.37ms ± 1% 6.49ms ± 1% +1.79% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=4/spillForced=true-24 6.17ms ± 1% 6.28ms ± 1% +1.80% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=1024-24 105µs ± 1% 107µs ± 1% +1.84% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=1/spilled=true-24 9.50ms ± 1% 9.68ms ± 2% +1.93% (p=0.016 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=16384-24 1.44ms ± 0% 1.47ms ± 0% +2.08% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=1048576-24 90.2ms ± 1% 92.1ms ± 0% +2.16% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=1/spilled=false-24 334µs ± 1% 341µs ± 1% +2.21% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=1/spilled=false-24 6.15ms ± 2% 6.29ms ± 2% +2.24% (p=0.032 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=4096-24 374µs ± 0% 382µs ± 1% +2.31% (p=0.008 n=5+5) | |
| SelectInInt64/useSel=false,hasNulls=true-24 12.6µs ± 1% 12.9µs ± 0% +2.31% (p=0.008 n=5+5) | |
| AllSpooler/rows=262144/cols=1-24 3.02ms ± 2% 3.09ms ± 2% +2.31% (p=0.016 n=5+5) | |
| MergeJoiner/rows=1048576-24 90.2ms ± 0% 92.3ms ± 0% +2.36% (p=0.008 n=5+5) | |
| ColumnarizeMaterialize-24 3.92ms ± 1% 4.01ms ± 4% +2.40% (p=0.032 n=5+5) | |
| MergeJoiner/rows=1024-24 105µs ± 1% 107µs ± 0% +2.59% (p=0.016 n=5+4) | |
| MergeJoiner/rows=4096-24 373µs ± 0% 383µs ± 0% +2.72% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=0-24 2.81ms ± 1% 2.89ms ± 6% +2.80% (p=0.008 n=5+5) | |
| AllSpooler/rows=16384/cols=2-24 285µs ± 2% 293µs ± 2% +2.82% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=4194304-24 462ms ± 2% 476ms ± 0% +2.91% (p=0.016 n=5+4) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=4/spillForced=true-24 6.37ms ± 1% 6.56ms ± 3% +2.95% (p=0.008 n=5+5) | |
| SelectInInt64/useSel=true,hasNulls=true-24 11.9µs ± 2% 12.3µs ± 1% +3.13% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=2048-24 484µs ± 1% 500µs ± 1% +3.40% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=false,hasNulls=true-24 11.0µs ± 1% 11.3µs ± 2% +3.55% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=128/spillForced=true-24 388ms ± 2% 402ms ± 0% +3.60% (p=0.016 n=5+4) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=2048-24 363µs ± 1% 377µs ± 3% +3.75% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=262144-24 28.5ms ± 2% 29.6ms ± 1% +3.81% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=2/matchLen=1/avgChunkSize=8-24 393µs ± 2% 408µs ± 3% +3.88% (p=0.016 n=5+5) | |
| LogicalProjOp/OR,useSel=true,hasNulls=true-24 12.0µs ± 1% 12.4µs ± 2% +4.02% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=true,hasNulls=true-24 12.7µs ± 2% 13.2µs ± 2% +4.08% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=262144-24 26.5ms ± 1% 27.6ms ± 2% +4.20% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=2048-24 336µs ± 1% 350µs ± 2% +4.21% (p=0.008 n=5+5) | |
| SelLTInt64Int64ConstOp/useSel=true,hasNulls=true-24 6.47µs ± 1% 6.74µs ± 1% +4.22% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=2048-24 351µs ± 1% 367µs ± 2% +4.50% (p=0.016 n=4+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=4/spillForced=false-24 947µs ± 1% 990µs ± 1% +4.52% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=1/topK=false-24 44.1µs ± 2% 46.1µs ± 1% +4.55% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=128/spillForced=false-24 550ms ± 2% 576ms ± 3% +4.63% (p=0.016 n=5+5) | |
| SelLTInt64Int64ConstOp/useSel=false,hasNulls=true-24 6.20µs ± 1% 6.49µs ± 1% +4.64% (p=0.008 n=5+5) | |
| AllSpooler/rows=16384/cols=1-24 144µs ± 3% 151µs ± 1% +4.78% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=2048-24 380µs ± 1% 398µs ± 0% +4.89% (p=0.016 n=5+4) | |
| SelLTInt64Int64Op/useSel=true,hasNulls=true-24 11.0µs ± 1% 11.6µs ± 1% +5.06% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=128/spillForced=true-24 524ms ± 0% 551ms ± 0% +5.19% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=4/spillForced=false-24 1.11ms ± 1% 1.17ms ± 3% +5.42% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=1-24 15.2µs ± 1% 16.0µs ± 3% +5.57% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=false,hasNulls=true-24 10.4µs ± 1% 11.0µs ± 1% +5.73% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=4-24 48.6µs ± 1% 51.7µs ± 0% +6.31% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=2-24 26.5µs ± 2% 28.3µs ± 2% +6.55% (p=0.008 n=5+5) | |
| SelLTInt64Int64Op/useSel=false,hasNulls=true-24 9.36µs ± 1% 9.99µs ± 1% +6.73% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=true,hasNulls=false-24 4.66µs ± 4% 5.04µs ± 2% +8.10% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=true,hasNulls=false-24 4.45µs ± 1% 4.90µs ± 1% +9.95% (p=0.008 n=5+5) | |
| ProjPlusInt64Int64ConstOp/useSel=true,hasNulls=true-24 7.16µs ± 1% 7.96µs ± 1% +11.13% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=2-24 74.5µs ± 0% 83.3µs ± 0% +11.89% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=2-24 74.6µs ± 1% 83.7µs ± 0% +12.14% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=false,hasNulls=false-24 5.96µs ± 4% 6.71µs ± 6% +12.54% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=2-24 74.5µs ± 1% 83.9µs ± 1% +12.66% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=4-24 140µs ± 1% 158µs ± 0% +13.06% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=2-24 1.06ms ± 0% 1.19ms ± 0% +13.23% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=4-24 140µs ± 0% 158µs ± 0% +13.26% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=4-24 140µs ± 1% 158µs ± 0% +13.30% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=2-24 1.06ms ± 0% 1.20ms ± 0% +13.46% (p=0.008 n=5+5) | |
| CastOp/useSel=true/hasNulls=true/int_to_float-24 4.57µs ± 4% 5.19µs ± 2% +13.63% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=2-24 1.05ms ± 0% 1.20ms ± 0% +13.74% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=4-24 2.04ms ± 0% 2.32ms ± 0% +13.97% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=4-24 2.03ms ± 0% 2.32ms ± 0% +14.16% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=4-24 2.03ms ± 0% 2.32ms ± 0% +14.28% (p=0.008 n=5+5) | |
| CastOp/useSel=false/hasNulls=true/int_to_float-24 6.19µs ± 1% 7.07µs ± 1% +14.35% (p=0.008 n=5+5) | |
| ProjPlusInt64Int64ConstOp/useSel=false,hasNulls=true-24 6.28µs ± 1% 7.71µs ± 1% +22.64% (p=0.008 n=5+5) | |
| name old speed new speed delta | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=4-24 1.78GB/s ± 1% 2.39GB/s ± 1% +34.45% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=4-24 1.78GB/s ± 0% 2.40GB/s ± 0% +34.35% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=4-24 1.78GB/s ± 1% 2.39GB/s ± 1% +34.20% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=2-24 1.69GB/s ± 0% 2.22GB/s ± 0% +31.56% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=2-24 1.69GB/s ± 0% 2.22GB/s ± 1% +31.51% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=2-24 1.69GB/s ± 0% 2.21GB/s ± 1% +31.26% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=4-24 1.52GB/s ± 2% 1.98GB/s ± 1% +30.25% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=4-24 1.52GB/s ± 1% 1.98GB/s ± 1% +30.18% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=4-24 1.52GB/s ± 2% 1.97GB/s ± 1% +29.35% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=2-24 1.38GB/s ± 1% 1.75GB/s ± 2% +26.16% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=2-24 1.38GB/s ± 1% 1.74GB/s ± 1% +26.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=2-24 1.39GB/s ± 1% 1.74GB/s ± 2% +25.77% (p=0.008 n=5+5) | |
| Offset-24 1.19GB/s ± 1% 1.44GB/s ± 1% +20.11% (p=0.008 n=5+5) | |
| ProjPlusInt64Int64ConstOp/useSel=false,hasNulls=false-24 3.79GB/s ± 1% 4.55GB/s ± 1% +20.04% (p=0.008 n=5+5) | |
| OrderedSynchronizer-24 274MB/s ± 2% 324MB/s ± 1% +18.33% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=2/avgChunkSize=128-24 329MB/s ± 7% 369MB/s ± 3% +11.93% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=3/avgChunkSize=128-24 508MB/s ± 6% 554MB/s ± 7% +9.17% (p=0.032 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=128/spillForced=false-24 9.95MB/s ± 4% 10.82MB/s ± 5% +8.79% (p=0.016 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=3/avgChunkSize=8-24 709MB/s ± 2% 756MB/s ± 2% +6.58% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=0-24 277MB/s ± 0% 294MB/s ± 0% +5.91% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=0-24 243MB/s ± 2% 257MB/s ± 0% +5.65% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=0-24 275MB/s ± 1% 290MB/s ± 1% +5.62% (p=0.008 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/int_to_decimal-24 12.0MB/s ± 1% 12.6MB/s ± 2% +5.10% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=0-24 231MB/s ± 1% 243MB/s ± 0% +4.99% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=4/topK=false-24 158MB/s ± 4% 166MB/s ± 1% +4.91% (p=0.016 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=2/matchLen=1/avgChunkSize=8-24 528MB/s ± 6% 554MB/s ± 1% +4.81% (p=0.016 n=5+5) | |
| CastOp/useSel=false/hasNulls=true/int_to_decimal-24 12.3MB/s ± 1% 12.9MB/s ± 2% +4.78% (p=0.008 n=5+5) | |
| CastOp/useSel=true/hasNulls=true/int_to_decimal-24 12.2MB/s ± 1% 12.8MB/s ± 2% +4.63% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=128/spillForced=false-24 8.56MB/s ± 3% 8.95MB/s ± 3% +4.58% (p=0.032 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/int_to_decimal-24 12.1MB/s ± 1% 12.6MB/s ± 2% +4.46% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 126MB/s ± 1% 132MB/s ± 1% +4.43% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 177MB/s ± 1% 184MB/s ± 1% +3.87% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=4/spillForced=false-24 191MB/s ± 0% 198MB/s ± 0% +3.65% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=0-24 125MB/s ± 1% 129MB/s ± 1% +3.62% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 165MB/s ± 4% 170MB/s ± 1% +3.51% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=0-24 199MB/s ± 3% 206MB/s ± 2% +3.35% (p=0.016 n=5+5) | |
| ExternalSort/rows=262144/cols=4/spilled=true-24 103MB/s ± 3% 106MB/s ± 2% +3.12% (p=0.016 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=0-24 176MB/s ± 1% 181MB/s ± 1% +2.62% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=4/spillForced=false-24 173MB/s ± 1% 177MB/s ± 0% +2.06% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=3/avgChunkSize=8-24 201MB/s ± 1% 205MB/s ± 1% +1.84% (p=0.016 n=5+5) | |
| Sort/rows=262144/cols=1/topK=true-24 440MB/s ± 0% 444MB/s ± 0% +0.94% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=false,hasNulls=false-24 1.94GB/s ± 0% 1.96GB/s ± 3% ~ (p=0.730 n=4+5) | |
| BuiltinFunctions/useSel=true,hasNulls=true-24 41.9MB/s ± 2% 41.7MB/s ± 0% ~ (p=0.159 n=5+4) | |
| BuiltinFunctions/useSel=true,hasNulls=false-24 41.2MB/s ± 3% 41.2MB/s ± 5% ~ (p=1.000 n=5+5) | |
| BuiltinFunctions/useSel=false,hasNulls=true-24 42.0MB/s ± 1% 42.3MB/s ± 1% ~ (p=0.762 n=5+4) | |
| BuiltinFunctions/useSel=false,hasNulls=false-24 41.4MB/s ± 2% 41.7MB/s ± 2% ~ (p=0.421 n=5+5) | |
| CompareSpecializedOperators/DefaultBuiltinOperator-24 12.7MB/s ± 2% 12.8MB/s ± 1% ~ (p=0.397 n=5+5) | |
| CompareSpecializedOperators/SpecializedSubstringOperator-24 210MB/s ± 1% 210MB/s ± 0% ~ (p=0.151 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/int_to_float-24 6.98GB/s ± 4% 6.77GB/s ± 6% ~ (p=0.310 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/int_to_float-24 3.57GB/s ± 0% 3.58GB/s ± 1% ~ (p=0.310 n=5+5) | |
| CastOp/useSel=true/hasNulls=true/float_to_decimal-24 4.62MB/s ± 1% 4.62MB/s ± 1% ~ (p=0.849 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/float_to_decimal-24 4.32MB/s ± 1% 4.31MB/s ± 1% ~ (p=0.825 n=5+5) | |
| CastOp/useSel=false/hasNulls=true/float_to_decimal-24 4.66MB/s ± 1% 4.66MB/s ± 1% ~ (p=0.889 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/float_to_decimal-24 4.32MB/s ± 1% 4.31MB/s ± 0% ~ (p=0.333 n=5+5) | |
| Columnarize-24 207MB/s ± 1% 208MB/s ± 1% ~ (p=1.000 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 160MB/s ± 9% 161MB/s ± 6% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=1-24 297MB/s ± 6% 309MB/s ± 3% ~ (p=0.056 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 266MB/s ± 7% 264MB/s ± 6% ~ (p=0.222 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=2-24 430MB/s ± 2% 416MB/s ± 8% ~ (p=0.222 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=0-24 382MB/s ± 1% 380MB/s ± 0% ~ (p=0.095 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=1-24 380MB/s ±40% 419MB/s ± 7% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=2-24 601MB/s ± 0% 593MB/s ±13% ~ (p=0.690 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=0-24 160MB/s ± 8% 161MB/s ± 5% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=1-24 244MB/s ±12% 233MB/s ±13% ~ (p=0.548 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=0-24 259MB/s ± 7% 263MB/s ± 2% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=2-24 302MB/s ±20% 316MB/s ± 8% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=1-24 290MB/s ±10% 283MB/s ±18% ~ (p=1.000 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=0-24 512MB/s ± 4% 507MB/s ± 1% ~ (p=0.222 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=2-24 414MB/s ±26% 410MB/s ±20% ~ (p=1.000 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 148MB/s ± 7% 150MB/s ± 8% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=1-24 70.3MB/s ±14% 78.6MB/s ±16% ~ (p=0.222 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 240MB/s ± 6% 244MB/s ± 2% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=2-24 91.4MB/s ±15% 92.8MB/s ±17% ~ (p=0.841 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=0-24 309MB/s ± 2% 309MB/s ± 2% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=1-24 78.4MB/s ±15% 81.0MB/s ±31% ~ (p=1.000 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=0-24 426MB/s ± 1% 424MB/s ± 3% ~ (p=1.000 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=2-24 98.6MB/s ± 8% 99.9MB/s ±13% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=1-24 232MB/s ± 8% 225MB/s ± 6% ~ (p=0.222 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=2-24 314MB/s ± 6% 290MB/s ± 5% ~ (p=0.056 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=1-24 286MB/s ±13% 273MB/s ±10% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=2-24 381MB/s ± 7% 347MB/s ±15% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=1-24 182MB/s ±10% 172MB/s ± 9% ~ (p=0.310 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=2-24 235MB/s ±11% 222MB/s ±19% ~ (p=0.421 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=0-24 228MB/s ± 2% 235MB/s ± 4% ~ (p=0.095 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=1-24 205MB/s ±12% 207MB/s ±13% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=2-24 286MB/s ±16% 267MB/s ±22% ~ (p=0.421 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 117MB/s ± 2% 119MB/s ± 3% ~ (p=0.095 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=1-24 66.5MB/s ±15% 64.4MB/s ±20% ~ (p=0.690 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=2-24 79.6MB/s ± 8% 77.3MB/s ±12% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=1-24 71.6MB/s ±13% 65.7MB/s ±19% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=2-24 93.0MB/s ±16% 86.3MB/s ±14% ~ (p=0.421 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=128/spillForced=false-24 12.0MB/s ± 3% 11.7MB/s ± 7% ~ (p=0.095 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=128/spillForced=true-24 20.2MB/s ± 1% 20.2MB/s ± 1% ~ (p=0.246 n=5+5) | |
| ExternalSort/rows=2048/cols=1/spilled=false-24 304MB/s ± 2% 302MB/s ± 1% ~ (p=0.222 n=5+5) | |
| ExternalSort/rows=2048/cols=1/spilled=true-24 39.3MB/s ± 1% 39.2MB/s ± 0% ~ (p=1.000 n=5+5) | |
| ExternalSort/rows=2048/cols=2/spilled=false-24 117MB/s ± 4% 116MB/s ± 3% ~ (p=0.841 n=5+5) | |
| ExternalSort/rows=2048/cols=2/spilled=true-24 41.5MB/s ± 2% 41.5MB/s ± 0% ~ (p=0.690 n=5+5) | |
| ExternalSort/rows=2048/cols=4/spilled=false-24 163MB/s ± 3% 163MB/s ± 2% ~ (p=1.000 n=5+5) | |
| ExternalSort/rows=2048/cols=4/spilled=true-24 59.4MB/s ± 1% 60.0MB/s ± 1% ~ (p=0.151 n=5+5) | |
| ExternalSort/rows=16384/cols=1/spilled=true-24 141MB/s ± 1% 140MB/s ± 1% ~ (p=0.222 n=5+5) | |
| ExternalSort/rows=16384/cols=2/spilled=false-24 112MB/s ± 7% 114MB/s ± 5% ~ (p=0.690 n=5+5) | |
| ExternalSort/rows=16384/cols=2/spilled=true-24 83.5MB/s ± 5% 84.6MB/s ± 4% ~ (p=0.690 n=5+5) | |
| ExternalSort/rows=16384/cols=4/spilled=false-24 161MB/s ± 5% 164MB/s ± 4% ~ (p=0.548 n=5+5) | |
| ExternalSort/rows=16384/cols=4/spilled=true-24 110MB/s ± 3% 109MB/s ± 1% ~ (p=0.690 n=5+5) | |
| ExternalSort/rows=262144/cols=2/spilled=false-24 101MB/s ± 5% 102MB/s ± 4% ~ (p=1.000 n=5+5) | |
| ExternalSort/rows=262144/cols=2/spilled=true-24 84.9MB/s ± 5% 86.2MB/s ± 5% ~ (p=0.548 n=5+5) | |
| ExternalSort/rows=262144/cols=4/spilled=false-24 130MB/s ± 3% 130MB/s ± 4% ~ (p=1.000 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=4194304-24 623MB/s ± 3% 608MB/s ± 1% ~ (p=0.095 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=262144-24 423MB/s ± 2% 412MB/s ± 4% ~ (p=0.095 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=4194304-24 258MB/s ± 2% 253MB/s ± 2% ~ (p=0.222 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=262144-24 395MB/s ± 4% 394MB/s ± 3% ~ (p=0.841 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=4194304-24 240MB/s ± 2% 243MB/s ± 4% ~ (p=0.310 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=2048-24 279MB/s ± 1% 276MB/s ± 1% ~ (p=0.222 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=262144-24 380MB/s ± 1% 380MB/s ± 1% ~ (p=0.690 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=4194304-24 383MB/s ± 1% 384MB/s ± 1% ~ (p=0.310 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=262144-24 304MB/s ± 2% 300MB/s ± 2% ~ (p=0.421 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=4194304-24 196MB/s ± 3% 198MB/s ± 2% ~ (p=0.421 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=4194304-24 367MB/s ± 1% 367MB/s ± 1% ~ (p=1.000 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=2048-24 259MB/s ± 1% 257MB/s ± 2% ~ (p=0.310 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=262144-24 285MB/s ± 3% 286MB/s ± 4% ~ (p=0.841 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=4194304-24 189MB/s ± 2% 191MB/s ± 3% ~ (p=0.690 n=5+5) | |
| LikeOps/selPrefixBytesBytesConstOp-24 4.98GB/s ± 0% 4.99GB/s ± 0% ~ (p=0.421 n=5+5) | |
| LikeOps/selSuffixBytesBytesConstOp-24 4.70GB/s ± 2% 4.74GB/s ± 0% ~ (p=0.056 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=1024-24 621MB/s ± 3% 618MB/s ± 0% ~ (p=0.151 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=4096-24 260MB/s ± 0% 260MB/s ± 0% ~ (p=0.135 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=16384-24 222MB/s ± 1% 222MB/s ± 0% ~ (p=0.222 n=5+5) | |
| Ordinality-24 2.45GB/s ± 1% 2.44GB/s ± 1% ~ (p=0.690 n=5+5) | |
| ParallelUnorderedSynchronizer-24 4.74GB/s ± 3% 4.76GB/s ± 4% ~ (p=0.690 n=5+5) | |
| ProjPlusInt64Int64ConstOp/useSel=true,hasNulls=false-24 2.54GB/s ± 1% 2.53GB/s ± 1% ~ (p=0.151 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=2-24 122MB/s ± 4% 123MB/s ± 2% ~ (p=0.651 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=4-24 133MB/s ± 3% 132MB/s ± 1% ~ (p=0.222 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=8-24 161MB/s ± 4% 155MB/s ± 4% ~ (p=0.222 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=16-24 192MB/s ± 3% 186MB/s ± 3% ~ (p=0.222 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=2-24 112MB/s ± 5% 113MB/s ± 6% ~ (p=0.548 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=4-24 128MB/s ± 3% 129MB/s ± 0% ~ (p=0.286 n=5+4) | |
| HashRouter/numOutputs=4/numInputBatches=8-24 156MB/s ± 2% 154MB/s ± 1% ~ (p=0.310 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=16-24 189MB/s ± 2% 186MB/s ± 3% ~ (p=0.135 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=2-24 105MB/s ± 2% 104MB/s ± 2% ~ (p=0.841 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=4-24 125MB/s ± 2% 124MB/s ± 1% ~ (p=1.000 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=8-24 153MB/s ± 4% 152MB/s ± 3% ~ (p=0.151 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=16-24 184MB/s ± 3% 180MB/s ± 3% ~ (p=0.095 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=2-24 91.4MB/s ± 8% 90.8MB/s ± 8% ~ (p=0.841 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=4-24 120MB/s ± 1% 118MB/s ± 5% ~ (p=0.151 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=8-24 149MB/s ± 4% 146MB/s ± 6% ~ (p=0.095 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=16-24 181MB/s ± 3% 176MB/s ± 3% ~ (p=0.095 n=5+5) | |
| SelectInInt64/useSel=true,hasNulls=false-24 1.04GB/s ± 1% 1.04GB/s ± 0% ~ (p=0.421 n=5+5) | |
| SelectInInt64/useSel=false,hasNulls=false-24 1.27GB/s ± 1% 1.28GB/s ± 0% ~ (p=0.310 n=5+5) | |
| SelLTInt64Int64ConstOp/useSel=true,hasNulls=false-24 3.80GB/s ± 1% 3.82GB/s ± 1% ~ (p=0.056 n=5+5) | |
| SelLTInt64Int64ConstOp/useSel=false,hasNulls=false-24 3.79GB/s ± 0% 3.79GB/s ± 0% ~ (p=0.690 n=5+5) | |
| SelLTInt64Int64Op/useSel=true,hasNulls=false-24 5.12GB/s ± 0% 5.11GB/s ± 1% ~ (p=0.548 n=5+5) | |
| SelLTInt64Int64Op/useSel=false,hasNulls=false-24 9.51GB/s ± 0% 9.43GB/s ± 2% ~ (p=0.095 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=2/matchLen=1/avgChunkSize=8-24 385MB/s ± 3% 396MB/s ± 5% ~ (p=0.151 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=2/matchLen=1/avgChunkSize=128-24 204MB/s ±16% 214MB/s ±12% ~ (p=0.841 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=2/matchLen=1/avgChunkSize=128-24 134MB/s ± 8% 137MB/s ± 3% ~ (p=0.548 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=1/avgChunkSize=8-24 313MB/s ± 3% 316MB/s ± 1% ~ (p=0.548 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=1/avgChunkSize=8-24 194MB/s ± 4% 201MB/s ± 2% ~ (p=0.056 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=1/avgChunkSize=128-24 211MB/s ±13% 227MB/s ± 7% ~ (p=0.151 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=1/avgChunkSize=128-24 174MB/s ± 4% 174MB/s ± 6% ~ (p=0.841 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=2/avgChunkSize=8-24 407MB/s ± 2% 407MB/s ± 4% ~ (p=0.841 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=2/avgChunkSize=8-24 201MB/s ± 1% 201MB/s ± 4% ~ (p=0.548 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=2/avgChunkSize=128-24 281MB/s ±11% 298MB/s ± 7% ~ (p=0.222 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=2/avgChunkSize=128-24 189MB/s ± 1% 192MB/s ± 3% ~ (p=0.095 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=3/avgChunkSize=8-24 536MB/s ± 2% 548MB/s ± 4% ~ (p=0.095 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=3/avgChunkSize=8-24 210MB/s ± 5% 208MB/s ± 6% ~ (p=0.690 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=3/avgChunkSize=128-24 404MB/s ± 6% 427MB/s ± 4% ~ (p=0.151 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=3/avgChunkSize=128-24 209MB/s ± 2% 213MB/s ± 3% ~ (p=0.310 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=2/matchLen=1/avgChunkSize=8-24 144MB/s ± 2% 146MB/s ± 2% ~ (p=0.095 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=2/matchLen=1/avgChunkSize=128-24 255MB/s ±18% 271MB/s ± 9% ~ (p=0.421 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=2/matchLen=1/avgChunkSize=128-24 127MB/s ± 5% 126MB/s ± 7% ~ (p=1.000 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=1/avgChunkSize=8-24 383MB/s ± 6% 390MB/s ± 3% ~ (p=0.548 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=1/avgChunkSize=8-24 186MB/s ± 1% 186MB/s ± 1% ~ (p=1.000 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=1/avgChunkSize=128-24 259MB/s ± 5% 256MB/s ± 9% ~ (p=1.000 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=1/avgChunkSize=128-24 163MB/s ± 4% 162MB/s ± 4% ~ (p=0.841 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=2/avgChunkSize=8-24 510MB/s ± 3% 523MB/s ± 4% ~ (p=0.151 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=2/avgChunkSize=8-24 191MB/s ± 2% 192MB/s ± 1% ~ (p=0.421 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=2/avgChunkSize=128-24 173MB/s ± 5% 179MB/s ± 5% ~ (p=0.151 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=3/avgChunkSize=128-24 200MB/s ± 2% 197MB/s ± 3% ~ (p=0.222 n=5+5) | |
| Sort/rows=2048/cols=2/topK=false-24 119MB/s ± 3% 116MB/s ± 3% ~ (p=0.421 n=5+5) | |
| Sort/rows=2048/cols=2/topK=true-24 113MB/s ± 4% 114MB/s ± 4% ~ (p=0.548 n=5+5) | |
| Sort/rows=2048/cols=4/topK=true-24 205MB/s ± 1% 202MB/s ± 1% ~ (p=0.056 n=5+5) | |
| Sort/rows=16384/cols=1/topK=true-24 399MB/s ± 0% 400MB/s ± 1% ~ (p=0.421 n=5+5) | |
| Sort/rows=16384/cols=2/topK=false-24 112MB/s ± 5% 109MB/s ± 6% ~ (p=0.690 n=5+5) | |
| Sort/rows=16384/cols=2/topK=true-24 329MB/s ± 1% 328MB/s ± 1% ~ (p=0.690 n=5+5) | |
| Sort/rows=16384/cols=4/topK=false-24 158MB/s ± 6% 152MB/s ± 5% ~ (p=0.151 n=5+5) | |
| Sort/rows=16384/cols=4/topK=true-24 600MB/s ± 1% 600MB/s ± 1% ~ (p=1.000 n=5+5) | |
| Sort/rows=262144/cols=1/topK=false-24 345MB/s ± 1% 338MB/s ± 2% ~ (p=0.056 n=5+5) | |
| Sort/rows=262144/cols=2/topK=false-24 98.0MB/s ± 5% 100.7MB/s ± 4% ~ (p=0.421 n=5+5) | |
| Sort/rows=262144/cols=2/topK=true-24 555MB/s ± 1% 550MB/s ± 1% ~ (p=0.151 n=5+5) | |
| Sort/rows=262144/cols=4/topK=false-24 129MB/s ± 4% 127MB/s ± 5% ~ (p=0.421 n=5+5) | |
| Sort/rows=262144/cols=4/topK=true-24 1.06GB/s ± 1% 1.06GB/s ± 1% ~ (p=0.548 n=5+5) | |
| AllSpooler/rows=16384/cols=4-24 927MB/s ± 2% 906MB/s ± 1% ~ (p=0.056 n=5+5) | |
| AllSpooler/rows=262144/cols=2-24 671MB/s ± 3% 661MB/s ± 2% ~ (p=0.421 n=5+5) | |
| AllSpooler/rows=262144/cols=4-24 646MB/s ± 1% 645MB/s ± 1% ~ (p=0.841 n=5+5) | |
| LikeOps/selRegexpBytesBytesConstOp-24 98.6MB/s ± 0% 97.9MB/s ± 1% -0.71% (p=0.032 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=262144-24 366MB/s ± 0% 363MB/s ± 0% -0.74% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=32768-24 172MB/s ± 1% 170MB/s ± 0% -0.87% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=1/topK=true-24 248MB/s ± 0% 245MB/s ± 1% -1.33% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=1/topK=false-24 371MB/s ± 1% 366MB/s ± 0% -1.37% (p=0.016 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=2048-24 271MB/s ± 1% 267MB/s ± 1% -1.52% (p=0.032 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=4/spillForced=true-24 40.1MB/s ± 1% 39.5MB/s ± 1% -1.64% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=128/spillForced=true-24 15.3MB/s ± 1% 15.0MB/s ± 1% -1.70% (p=0.008 n=5+5) | |
| MergeJoiner/rows=16384-24 728MB/s ± 0% 716MB/s ± 0% -1.71% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=0-24 526MB/s ± 0% 517MB/s ± 2% -1.74% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=4/spillForced=true-24 41.1MB/s ± 1% 40.4MB/s ± 1% -1.76% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=4/spillForced=true-24 42.5MB/s ± 1% 41.8MB/s ± 1% -1.78% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=1024-24 624MB/s ± 1% 613MB/s ± 1% -1.80% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=1/spilled=true-24 221MB/s ± 1% 217MB/s ± 2% -1.87% (p=0.016 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=16384-24 728MB/s ± 0% 714MB/s ± 0% -2.03% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=1048576-24 744MB/s ± 1% 728MB/s ± 0% -2.11% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=1/spilled=false-24 393MB/s ± 1% 384MB/s ± 1% -2.17% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=1/spilled=false-24 341MB/s ± 2% 333MB/s ± 2% -2.20% (p=0.032 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=4096-24 701MB/s ± 0% 685MB/s ± 1% -2.25% (p=0.008 n=5+5) | |
| AllSpooler/rows=262144/cols=1-24 694MB/s ± 2% 678MB/s ± 2% -2.26% (p=0.016 n=5+5) | |
| SelectInInt64/useSel=false,hasNulls=true-24 651MB/s ± 1% 637MB/s ± 0% -2.26% (p=0.008 n=5+5) | |
| ColumnarizeMaterialize-24 40.9MB/s ± 1% 39.9MB/s ± 4% -2.30% (p=0.032 n=5+5) | |
| MergeJoiner/rows=1048576-24 744MB/s ± 0% 727MB/s ± 0% -2.31% (p=0.008 n=5+5) | |
| MergeJoiner/rows=1024-24 627MB/s ± 1% 611MB/s ± 0% -2.53% (p=0.016 n=5+4) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=0-24 374MB/s ± 1% 364MB/s ± 6% -2.62% (p=0.008 n=5+5) | |
| MergeJoiner/rows=4096-24 704MB/s ± 0% 685MB/s ± 0% -2.65% (p=0.008 n=5+5) | |
| AllSpooler/rows=16384/cols=2-24 919MB/s ± 2% 894MB/s ± 2% -2.75% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=4/spillForced=true-24 41.2MB/s ± 1% 40.0MB/s ± 3% -2.84% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=4194304-24 581MB/s ± 2% 564MB/s ± 0% -2.84% (p=0.016 n=5+4) | |
| SelectInInt64/useSel=true,hasNulls=true-24 689MB/s ± 1% 668MB/s ± 1% -3.04% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=2048-24 271MB/s ± 1% 262MB/s ± 1% -3.29% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=false,hasNulls=true-24 748MB/s ± 1% 722MB/s ± 2% -3.43% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=128/spillForced=true-24 21.6MB/s ± 2% 20.9MB/s ± 0% -3.50% (p=0.016 n=5+4) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=2048-24 361MB/s ± 1% 348MB/s ± 3% -3.59% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=262144-24 588MB/s ± 2% 566MB/s ± 1% -3.67% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=2/matchLen=1/avgChunkSize=8-24 167MB/s ± 2% 161MB/s ± 3% -3.71% (p=0.016 n=5+5) | |
| LogicalProjOp/OR,useSel=true,hasNulls=true-24 686MB/s ± 1% 659MB/s ± 2% -3.85% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=true,hasNulls=true-24 645MB/s ± 2% 619MB/s ± 2% -3.93% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=262144-24 634MB/s ± 1% 608MB/s ± 2% -4.02% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=2048-24 390MB/s ± 1% 374MB/s ± 2% -4.04% (p=0.008 n=5+5) | |
| SelLTInt64Int64ConstOp/useSel=true,hasNulls=true-24 1.27GB/s ± 1% 1.22GB/s ± 1% -4.05% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=2048-24 373MB/s ± 1% 357MB/s ± 2% -4.29% (p=0.016 n=4+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=4/spillForced=false-24 277MB/s ± 1% 265MB/s ± 1% -4.33% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=1/topK=false-24 371MB/s ± 2% 355MB/s ± 1% -4.36% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=128/spillForced=false-24 15.2MB/s ± 2% 14.6MB/s ± 3% -4.42% (p=0.016 n=5+5) | |
| SelLTInt64Int64ConstOp/useSel=false,hasNulls=true-24 1.32GB/s ± 1% 1.26GB/s ± 1% -4.45% (p=0.008 n=5+5) | |
| AllSpooler/rows=16384/cols=1-24 911MB/s ± 3% 870MB/s ± 1% -4.58% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=2048-24 345MB/s ± 1% 329MB/s ± 0% -4.67% (p=0.016 n=5+4) | |
| SelLTInt64Int64Op/useSel=true,hasNulls=true-24 1.48GB/s ± 1% 1.41GB/s ± 1% -4.82% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=128/spillForced=true-24 16.0MB/s ± 0% 15.2MB/s ± 0% -4.94% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=4/spillForced=false-24 237MB/s ± 1% 224MB/s ± 3% -5.12% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=1-24 1.08GB/s ± 1% 1.02GB/s ± 3% -5.26% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=false,hasNulls=true-24 791MB/s ± 1% 748MB/s ± 1% -5.42% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=4-24 1.35GB/s ± 1% 1.27GB/s ± 0% -5.94% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=2-24 1.23GB/s ± 2% 1.16GB/s ± 2% -6.14% (p=0.008 n=5+5) | |
| SelLTInt64Int64Op/useSel=false,hasNulls=true-24 1.75GB/s ± 1% 1.64GB/s ± 1% -6.31% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=true,hasNulls=false-24 1.76GB/s ± 4% 1.63GB/s ± 2% -7.52% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=true,hasNulls=false-24 1.84GB/s ± 1% 1.67GB/s ± 1% -9.05% (p=0.008 n=5+5) | |
| ProjPlusInt64Int64ConstOp/useSel=true,hasNulls=true-24 1.14GB/s ± 1% 1.03GB/s ± 1% -10.01% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=2-24 880MB/s ± 0% 786MB/s ± 0% -10.62% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=2-24 878MB/s ± 1% 783MB/s ± 0% -10.83% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=false,hasNulls=false-24 1.37GB/s ± 4% 1.22GB/s ± 6% -11.15% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=2-24 880MB/s ± 1% 781MB/s ± 1% -11.24% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=4-24 937MB/s ± 1% 829MB/s ± 0% -11.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=2-24 994MB/s ± 0% 878MB/s ± 0% -11.68% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=4-24 938MB/s ± 0% 828MB/s ± 0% -11.71% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=4-24 939MB/s ± 1% 828MB/s ± 0% -11.74% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=2-24 994MB/s ± 0% 876MB/s ± 0% -11.86% (p=0.008 n=5+5) | |
| CastOp/useSel=true/hasNulls=true/int_to_float-24 1.79GB/s ± 4% 1.58GB/s ± 2% -12.01% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=2-24 1.00GB/s ± 0% 0.88GB/s ± 0% -12.08% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=4-24 1.03GB/s ± 0% 0.90GB/s ± 0% -12.26% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=4-24 1.03GB/s ± 0% 0.90GB/s ± 0% -12.40% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=4-24 1.03GB/s ± 0% 0.90GB/s ± 0% -12.49% (p=0.008 n=5+5) | |
| CastOp/useSel=false/hasNulls=true/int_to_float-24 1.32GB/s ± 1% 1.16GB/s ± 1% -12.55% (p=0.008 n=5+5) | |
| ProjPlusInt64Int64ConstOp/useSel=false,hasNulls=true-24 1.30GB/s ± 1% 1.06GB/s ± 1% -18.45% (p=0.008 n=5+5) | |
| name old alloc/op new alloc/op delta | |
| HashRouter/numOutputs=2/numInputBatches=4-24 242kB ± 2% 236kB ± 1% -2.19% (p=0.016 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=4-24 245kB ± 1% 241kB ± 1% -1.52% (p=0.008 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/int_to_decimal-24 246kB ± 0% 246kB ± 0% -0.00% (p=0.008 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/int_to_decimal-24 246kB ± 0% 246kB ± 0% -0.00% (p=0.016 n=5+5) | |
| BuiltinFunctions/useSel=true,hasNulls=true-24 129kB ± 1% 130kB ± 1% ~ (p=0.095 n=5+5) | |
| BuiltinFunctions/useSel=true,hasNulls=false-24 143kB ± 0% 143kB ± 0% ~ (all equal) | |
| BuiltinFunctions/useSel=false,hasNulls=true-24 128kB ± 1% 129kB ± 3% ~ (p=0.310 n=5+5) | |
| BuiltinFunctions/useSel=false,hasNulls=false-24 143kB ± 0% 143kB ± 0% ~ (all equal) | |
| CompareSpecializedOperators/DefaultBuiltinOperator-24 598kB ± 0% 598kB ± 0% ~ (p=1.000 n=5+5) | |
| CompareSpecializedOperators/SpecializedSubstringOperator-24 0.00B 0.00B ~ (all equal) | |
| CastOp/useSel=true/hasNulls=true/int_to_float-24 0.00B 0.00B ~ (all equal) | |
| CastOp/useSel=true/hasNulls=false/int_to_float-24 0.00B 0.00B ~ (all equal) | |
| CastOp/useSel=false/hasNulls=true/int_to_float-24 0.00B 0.00B ~ (all equal) | |
| CastOp/useSel=false/hasNulls=false/int_to_float-24 0.00B 0.00B ~ (all equal) | |
| CastOp/useSel=true/hasNulls=true/int_to_decimal-24 221kB ± 1% 220kB ± 1% ~ (p=0.421 n=5+5) | |
| CastOp/useSel=false/hasNulls=true/int_to_decimal-24 222kB ± 2% 222kB ± 1% ~ (p=0.841 n=5+5) | |
| CastOp/useSel=true/hasNulls=true/float_to_decimal-24 383kB ± 2% 380kB ± 1% ~ (p=0.548 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/float_to_decimal-24 422kB ± 0% 423kB ± 0% ~ (p=0.841 n=5+5) | |
| CastOp/useSel=false/hasNulls=true/float_to_decimal-24 379kB ± 1% 378kB ± 1% ~ (p=0.421 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/float_to_decimal-24 422kB ± 0% 423kB ± 0% ~ (p=0.421 n=5+5) | |
| Columnarize-24 163kB ± 0% 163kB ± 0% ~ (p=1.000 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=1-24 183kB ± 3% 182kB ± 6% ~ (p=0.492 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=2-24 247kB ± 6% 251kB ± 7% ~ (p=0.500 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=1-24 256kB ± 8% 267kB ± 7% ~ (p=0.143 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=1-24 183kB ± 3% 187kB ± 3% ~ (p=0.310 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=2-24 264kB ± 6% 261kB ± 3% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=1-24 434kB ±22% 464kB ±35% ~ (p=0.690 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=0-24 1.27MB ± 5% 1.31MB ± 0% ~ (p=0.159 n=5+4) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=2-24 795kB ±57% 777kB ±36% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=1-24 320kB ±10% 296kB ±11% ~ (p=0.151 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=2-24 538kB ±11% 520kB ±14% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=1-24 2.71MB ±19% 2.65MB ±39% ~ (p=0.548 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=2-24 5.42MB ± 9% 5.14MB ±17% ~ (p=0.310 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=1-24 188kB ± 0% 185kB ± 4% ~ (p=0.921 n=4+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=2-24 262kB ± 0% 259kB ± 3% ~ (p=0.667 n=4+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=1-24 298kB ±18% 314kB ±13% ~ (p=0.151 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=2-24 478kB ± 8% 439kB ± 0% ~ (p=0.683 n=5+4) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=0-24 1.16MB ± 0% 1.17MB ± 0% ~ (p=0.119 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=1-24 186kB ± 6% 189kB ± 4% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=2-24 262kB ± 5% 273kB ± 6% ~ (p=0.151 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=0-24 1.21MB ± 2% 1.22MB ± 0% ~ (p=0.730 n=5+4) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=1-24 516kB ±24% 468kB ±17% ~ (p=0.841 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=0-24 1.28MB ± 4% 1.31MB ± 5% ~ (p=0.095 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=2-24 780kB ±33% 907kB ±48% ~ (p=0.690 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=1-24 314kB ±11% 314kB ±12% ~ (p=0.841 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=2-24 548kB ± 6% 540kB ±10% ~ (p=0.690 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=1-24 2.68MB ±19% 2.91MB ±27% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=2-24 5.10MB ±21% 5.25MB ±16% ~ (p=0.841 n=5+5) | |
| LikeOps/selPrefixBytesBytesConstOp-24 0.00B 0.00B ~ (all equal) | |
| LikeOps/selSuffixBytesBytesConstOp-24 0.00B 0.00B ~ (all equal) | |
| LikeOps/selRegexpBytesBytesConstOp-24 22.0B ± 0% 22.0B ± 0% ~ (all equal) | |
| ColumnarizeMaterialize-24 2.73MB ± 0% 2.73MB ± 0% ~ (p=0.413 n=5+4) | |
| Offset-24 0.00B 0.00B ~ (all equal) | |
| OrderedSynchronizer-24 0.00B 0.00B ~ (all equal) | |
| Ordinality-24 0.00B 0.00B ~ (all equal) | |
| ParallelUnorderedSynchronizer-24 0.00B 0.00B ~ (all equal) | |
| ProjPlusInt64Int64ConstOp/useSel=true,hasNulls=true-24 160B ± 0% 160B ± 0% ~ (all equal) | |
| ProjPlusInt64Int64ConstOp/useSel=true,hasNulls=false-24 0.00B 0.00B ~ (all equal) | |
| ProjPlusInt64Int64ConstOp/useSel=false,hasNulls=true-24 160B ± 0% 160B ± 0% ~ (all equal) | |
| ProjPlusInt64Int64ConstOp/useSel=false,hasNulls=false-24 0.00B 0.00B ~ (all equal) | |
| HashRouter/numOutputs=2/numInputBatches=16-24 629kB ± 1% 637kB ± 2% ~ (p=0.421 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=4-24 242kB ± 3% 239kB ± 2% ~ (p=0.095 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=16-24 637kB ± 2% 650kB ± 2% ~ (p=0.095 n=5+5) | |
| SelectInInt64/useSel=true,hasNulls=true-24 0.00B 0.00B ~ (all equal) | |
| SelectInInt64/useSel=true,hasNulls=false-24 0.00B 0.00B ~ (all equal) | |
| SelectInInt64/useSel=false,hasNulls=true-24 0.00B 0.00B ~ (all equal) | |
| SelectInInt64/useSel=false,hasNulls=false-24 0.00B 0.00B ~ (all equal) | |
| SelLTInt64Int64ConstOp/useSel=true,hasNulls=true-24 0.00B 0.00B ~ (all equal) | |
| SelLTInt64Int64ConstOp/useSel=true,hasNulls=false-24 0.00B 0.00B ~ (all equal) | |
| SelLTInt64Int64ConstOp/useSel=false,hasNulls=true-24 0.00B 0.00B ~ (all equal) | |
| SelLTInt64Int64ConstOp/useSel=false,hasNulls=false-24 0.00B 0.00B ~ (all equal) | |
| SelLTInt64Int64Op/useSel=true,hasNulls=true-24 160B ± 0% 160B ± 0% ~ (all equal) | |
| SelLTInt64Int64Op/useSel=true,hasNulls=false-24 0.00B 0.00B ~ (all equal) | |
| SelLTInt64Int64Op/useSel=false,hasNulls=true-24 160B ± 0% 160B ± 0% ~ (all equal) | |
| SelLTInt64Int64Op/useSel=false,hasNulls=false-24 0.00B 0.00B ~ (all equal) | |
| SortChunks/ALL/rows=4096/cols=2/matchLen=1/avgChunkSize=8-24 297kB ± 2% 296kB ± 2% ~ (p=0.571 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=2/matchLen=1/avgChunkSize=128-24 285kB ± 0% 285kB ± 0% ~ (p=0.762 n=4+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=1/avgChunkSize=8-24 230kB ± 1% 230kB ± 1% ~ (p=0.810 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=1/avgChunkSize=128-24 248kB ±10% 239kB ±13% ~ (p=0.310 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=2/avgChunkSize=128-24 229kB ± 3% 231kB ± 3% ~ (p=0.841 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=3/avgChunkSize=8-24 195kB ± 0% 195kB ± 0% ~ (p=0.143 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=2/matchLen=1/avgChunkSize=8-24 299kB ± 0% 352kB ±23% ~ (p=0.413 n=4+5) | |
| SortChunks/CHUNKS/rows=65536/cols=2/matchLen=1/avgChunkSize=128-24 185kB ± 2% 185kB ± 1% ~ (p=0.841 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=2/matchLen=1/avgChunkSize=128-24 6.44MB ± 0% 6.45MB ± 0% ~ (p=0.278 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=1/avgChunkSize=8-24 1.43MB ± 0% 1.43MB ± 0% ~ (p=0.841 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=1/avgChunkSize=128-24 1.62MB ± 9% 1.62MB ± 5% ~ (p=0.690 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=2/avgChunkSize=8-24 1.38MB ± 0% 1.38MB ± 0% ~ (p=0.690 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=2/avgChunkSize=128-24 1.49MB ±10% 1.43MB ± 5% ~ (p=0.421 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=3/avgChunkSize=128-24 299kB ± 2% 298kB ± 1% ~ (p=0.952 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=3/avgChunkSize=128-24 12.3MB ± 0% 12.3MB ± 0% ~ (p=1.000 n=5+5) | |
| AllSpooler/rows=262144/cols=4-24 47.1MB ± 0% 47.1MB ± 0% +0.00% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=4/topK=false-24 49.5MB ± 0% 49.5MB ± 0% +0.00% (p=0.008 n=5+5) | |
| AllSpooler/rows=262144/cols=2-24 23.5MB ± 0% 23.5MB ± 0% +0.00% (p=0.008 n=5+5) | |
| AllSpooler/rows=262144/cols=1-24 11.8MB ± 0% 11.8MB ± 0% +0.00% (p=0.016 n=5+4) | |
| Sort/rows=262144/cols=1/topK=false-24 13.9MB ± 0% 13.9MB ± 0% +0.00% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=2/topK=false-24 25.9MB ± 0% 25.9MB ± 0% +0.00% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=1/avgChunkSize=128-24 15.2MB ± 0% 15.2MB ± 0% +0.00% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=1/avgChunkSize=8-24 15.2MB ± 0% 15.2MB ± 0% +0.00% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=2/avgChunkSize=128-24 15.2MB ± 0% 15.2MB ± 0% +0.00% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=2/avgChunkSize=8-24 15.2MB ± 0% 15.2MB ± 0% +0.00% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=3/avgChunkSize=8-24 13.1MB ± 0% 13.1MB ± 0% +0.00% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=2/matchLen=1/avgChunkSize=8-24 6.72MB ± 0% 6.72MB ± 0% +0.00% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=2/spilled=false-24 25.9MB ± 0% 25.9MB ± 0% +0.00% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=1/spilled=false-24 13.9MB ± 0% 13.9MB ± 0% +0.00% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=4/spilled=false-24 49.5MB ± 0% 49.5MB ± 0% +0.00% (p=0.008 n=5+5) | |
| AllSpooler/rows=16384/cols=4-24 2.49MB ± 0% 2.49MB ± 0% +0.00% (p=0.008 n=5+5) | |
| AllSpooler/rows=16384/cols=2-24 1.25MB ± 0% 1.25MB ± 0% +0.01% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=4/topK=false-24 2.70MB ± 0% 2.70MB ± 0% +0.01% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=2/topK=false-24 1.42MB ± 0% 1.42MB ± 0% +0.01% (p=0.029 n=4+4) | |
| Sort/rows=16384/cols=1/topK=false-24 778kB ± 0% 778kB ± 0% +0.01% (p=0.029 n=4+4) | |
| AllSpooler/rows=16384/cols=1-24 630kB ± 0% 630kB ± 0% +0.01% (p=0.016 n=4+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=1/avgChunkSize=128-24 630kB ± 0% 631kB ± 0% +0.02% (p=0.016 n=5+4) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=2/avgChunkSize=8-24 630kB ± 0% 631kB ± 0% +0.02% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=2/avgChunkSize=128-24 630kB ± 0% 631kB ± 0% +0.02% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=1/avgChunkSize=8-24 630kB ± 0% 631kB ± 0% +0.02% (p=0.016 n=4+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=3/avgChunkSize=8-24 794kB ± 0% 794kB ± 0% +0.03% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=3/avgChunkSize=8-24 555kB ± 0% 555kB ± 0% +0.03% (p=0.029 n=4+4) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=3/avgChunkSize=128-24 517kB ± 0% 517kB ± 0% +0.03% (p=0.029 n=4+4) | |
| ExternalSort/rows=16384/cols=2/spilled=false-24 1.43MB ± 0% 1.43MB ± 0% +0.03% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=4/spilled=false-24 2.70MB ± 0% 2.70MB ± 0% +0.03% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=1/topK=false-24 79.9kB ± 0% 79.9kB ± 0% +0.06% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=4/topK=false-24 237kB ± 0% 237kB ± 0% +0.06% (p=0.016 n=5+4) | |
| Sort/rows=2048/cols=2/topK=false-24 128kB ± 0% 128kB ± 0% +0.06% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=4-24 160kB ± 0% 160kB ± 0% +0.07% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=2-24 84.3kB ± 0% 84.3kB ± 0% +0.08% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=1-24 46.5kB ± 0% 46.5kB ± 0% +0.09% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 1.16MB ± 0% 1.16MB ± 0% +0.10% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 1.16MB ± 0% 1.16MB ± 0% +0.10% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=4-24 43.7kB ± 0% 43.8kB ± 0% +0.11% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=2-24 26.7kB ± 0% 26.7kB ± 0% +0.12% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 1.18MB ± 0% 1.18MB ± 0% +0.13% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 1.18MB ± 0% 1.18MB ± 0% +0.14% (p=0.016 n=4+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=2/avgChunkSize=8-24 228kB ± 0% 228kB ± 0% +0.14% (p=0.048 n=4+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=0-24 1.16MB ± 0% 1.17MB ± 0% +0.17% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=1/spilled=false-24 781kB ± 0% 783kB ± 0% +0.17% (p=0.029 n=4+4) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=0-24 1.20MB ± 0% 1.20MB ± 0% +0.22% (p=0.029 n=4+4) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=0-24 1.20MB ± 0% 1.20MB ± 0% +0.22% (p=0.016 n=5+4) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 1.20MB ± 0% 1.20MB ± 0% +0.22% (p=0.029 n=4+4) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 1.20MB ± 0% 1.20MB ± 0% +0.25% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=4/spilled=true-24 59.6MB ± 0% 59.8MB ± 0% +0.26% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 1.23MB ± 0% 1.23MB ± 0% +0.27% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 1.23MB ± 0% 1.23MB ± 0% +0.27% (p=0.016 n=4+5) | |
| Sort/rows=2048/cols=4/topK=true-24 101kB ± 0% 101kB ± 0% +0.27% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=4/topK=true-24 101kB ± 0% 101kB ± 0% +0.27% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=4/topK=true-24 101kB ± 0% 101kB ± 0% +0.27% (p=0.016 n=5+4) | |
| ExternalSort/rows=2048/cols=1/spilled=false-24 83.3kB ± 0% 83.6kB ± 0% +0.27% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=4/spilled=true-24 3.61MB ± 0% 3.62MB ± 0% +0.31% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=2/spilled=false-24 132kB ± 0% 133kB ± 0% +0.32% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=4/spilled=false-24 240kB ± 0% 241kB ± 0% +0.34% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=2/topK=true-24 64.8kB ± 0% 65.0kB ± 0% +0.35% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=2/topK=true-24 64.8kB ± 0% 65.0kB ± 0% +0.35% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=2/topK=true-24 64.8kB ± 0% 65.0kB ± 0% +0.35% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=2/spilled=true-24 28.9MB ± 0% 29.0MB ± 0% +0.35% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=2/spilled=true-24 1.85MB ± 0% 1.86MB ± 0% +0.40% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=1/topK=true-24 46.6kB ± 0% 46.8kB ± 0% +0.43% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=1/topK=true-24 46.6kB ± 0% 46.8kB ± 0% +0.43% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=1/topK=true-24 46.6kB ± 0% 46.8kB ± 0% +0.43% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=4/spilled=true-24 606kB ± 0% 609kB ± 0% +0.44% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=2/spilled=true-24 406kB ± 0% 408kB ± 0% +0.45% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=1/spilled=true-24 15.0MB ± 0% 15.0MB ± 0% +0.48% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=1/spilled=true-24 1.07MB ± 0% 1.07MB ± 0% +0.50% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=4-24 262kB ± 0% 263kB ± 0% +0.50% (p=0.016 n=5+4) | |
| ExternalSort/rows=2048/cols=1/spilled=true-24 218kB ± 0% 219kB ± 0% +0.54% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=2048-24 875kB ± 0% 880kB ± 0% +0.60% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=2048-24 875kB ± 0% 880kB ± 0% +0.60% (p=0.016 n=5+4) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=2048-24 872kB ± 0% 877kB ± 0% +0.60% (p=0.016 n=4+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=2048-24 872kB ± 0% 877kB ± 0% +0.60% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=262144-24 52.5MB ± 0% 52.9MB ± 0% +0.63% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=262144-24 52.5MB ± 0% 52.9MB ± 0% +0.63% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=262144-24 52.3MB ± 0% 52.6MB ± 0% +0.63% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=262144-24 52.3MB ± 0% 52.6MB ± 0% +0.63% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=2048-24 896kB ± 0% 902kB ± 0% +0.65% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=2048-24 896kB ± 0% 902kB ± 0% +0.65% (p=0.016 n=4+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=2048-24 893kB ± 0% 899kB ± 0% +0.66% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=2048-24 893kB ± 0% 899kB ± 0% +0.66% (p=0.016 n=5+4) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=262144-24 50.1MB ± 0% 50.5MB ± 0% +0.66% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=262144-24 50.1MB ± 0% 50.5MB ± 0% +0.66% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=262144-24 49.9MB ± 0% 50.2MB ± 0% +0.66% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=262144-24 49.9MB ± 0% 50.2MB ± 0% +0.66% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=4194304-24 781MB ± 0% 786MB ± 0% +0.67% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=4194304-24 781MB ± 0% 786MB ± 0% +0.67% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=4194304-24 777MB ± 0% 782MB ± 0% +0.68% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=4194304-24 777MB ± 0% 782MB ± 0% +0.68% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=4194304-24 743MB ± 0% 749MB ± 0% +0.71% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=4194304-24 743MB ± 0% 749MB ± 0% +0.71% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=4194304-24 739MB ± 0% 744MB ± 0% +0.71% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=4194304-24 739MB ± 0% 744MB ± 0% +0.71% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=8-24 398kB ± 0% 401kB ± 0% +0.77% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=8-24 396kB ± 0% 400kB ± 1% +0.95% (p=0.016 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=2-24 116kB ± 0% 117kB ± 0% +1.04% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=2-24 121kB ± 0% 122kB ± 0% +1.04% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=2-24 124kB ± 1% 125kB ± 1% +1.08% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=3/avgChunkSize=128-24 157kB ± 1% 159kB ± 1% +1.11% (p=0.048 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=2-24 123kB ± 0% 124kB ± 0% +1.11% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=4/spillForced=false-24 1.21MB ± 0% 1.23MB ± 0% +1.14% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=4/spillForced=false-24 1.21MB ± 0% 1.22MB ± 0% +1.16% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=4/spillForced=false-24 1.21MB ± 0% 1.22MB ± 0% +1.17% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=4/spillForced=false-24 1.21MB ± 0% 1.23MB ± 0% +1.22% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=128/spillForced=false-24 26.6MB ± 0% 26.9MB ± 0% +1.25% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=128/spillForced=false-24 26.6MB ± 0% 26.9MB ± 0% +1.25% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=128/spillForced=false-24 26.5MB ± 0% 26.8MB ± 0% +1.25% (p=0.016 n=4+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=128/spillForced=false-24 26.5MB ± 0% 26.8MB ± 0% +1.25% (p=0.016 n=5+4) | |
| HashRouter/numOutputs=4/numInputBatches=8-24 402kB ± 1% 407kB ± 0% +1.34% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=8-24 402kB ± 1% 407kB ± 0% +1.38% (p=0.016 n=5+4) | |
| HashRouter/numOutputs=16/numInputBatches=16-24 629kB ± 1% 640kB ± 1% +1.67% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=0-24 1.17MB ± 0% 1.20MB ± 0% +1.76% (p=0.029 n=4+4) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=0-24 1.20MB ± 0% 1.22MB ± 0% +1.81% (p=0.016 n=5+4) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=0-24 1.17MB ± 0% 1.19MB ± 0% +1.86% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=4/spillForced=true-24 3.94MB ± 0% 4.01MB ± 0% +1.91% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=4/spillForced=true-24 3.93MB ± 0% 4.01MB ± 0% +1.92% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=4/spillForced=true-24 3.94MB ± 0% 4.02MB ± 0% +1.98% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=16-24 637kB ± 1% 649kB ± 0% +1.98% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=4/spillForced=true-24 3.94MB ± 0% 4.02MB ± 0% +2.02% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=0-24 1.77MB ± 0% 1.81MB ± 0% +2.29% (p=0.016 n=5+4) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=0-24 1.77MB ± 0% 1.81MB ± 0% +2.33% (p=0.029 n=4+4) | |
| SortChunks/CHUNKS/rows=4096/cols=2/matchLen=1/avgChunkSize=8-24 110kB ± 0% 113kB ± 7% +2.37% (p=0.016 n=4+5) | |
| SortChunks/CHUNKS/rows=4096/cols=2/matchLen=1/avgChunkSize=128-24 102kB ± 0% 105kB ± 7% +3.19% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=0-24 1.22MB ± 0% 1.26MB ± 1% +3.51% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=0-24 2.24MB ± 0% 2.33MB ± 0% +3.64% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=0-24 1.21MB ± 0% 1.25MB ± 1% +3.75% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=0-24 2.24MB ± 0% 2.33MB ± 1% +3.99% (p=0.016 n=5+4) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=128/spillForced=true-24 22.9MB ± 1% 24.8MB ± 1% +8.50% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=128/spillForced=true-24 22.7MB ± 1% 24.7MB ± 1% +8.93% (p=0.008 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=2-24 381kB ± 0% 416kB ±22% +9.11% (p=0.016 n=4+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=128/spillForced=true-24 22.7MB ± 2% 24.8MB ± 1% +9.37% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=128/spillForced=true-24 22.7MB ± 2% 24.9MB ± 1% +9.67% (p=0.008 n=5+5) | |
| MergeJoiner/rows=1024-24 1.22kB ± 0% 1.61kB ± 0% +31.48% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=1024-24 1.22kB ± 0% 1.61kB ± 0% +31.48% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=1024-24 1.22kB ± 0% 1.61kB ± 0% +31.48% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=4096-24 5.14kB ± 0% 7.64kB ± 0% +48.59% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=32768-24 43.3kB ± 0% 65.5kB ± 0% +51.45% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=4096-24 4.85kB ± 0% 7.35kB ± 0% +51.60% (p=0.008 n=5+5) | |
| MergeJoiner/rows=4096-24 4.84kB ± 0% 7.35kB ± 0% +51.65% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=16384-24 20.9kB ± 0% 31.9kB ± 0% +52.41% (p=0.016 n=5+4) | |
| MergeJoiner/oneSideRepeat-rows=16384-24 19.4kB ± 0% 30.3kB ± 0% +56.60% (p=0.008 n=5+5) | |
| MergeJoiner/rows=16384-24 19.4kB ± 0% 30.3kB ± 0% +56.64% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=1048576-24 1.24MB ± 0% 1.96MB ± 0% +58.27% (p=0.008 n=5+5) | |
| MergeJoiner/rows=1048576-24 1.24MB ± 0% 1.96MB ± 0% +58.28% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=true,hasNulls=true-24 0.00B 160.00B ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=true,hasNulls=false-24 0.00B 160.00B ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=false,hasNulls=true-24 0.00B 160.00B ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=false,hasNulls=false-24 0.00B 160.00B ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=true,hasNulls=true-24 0.00B 160.00B ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=true,hasNulls=false-24 0.00B 160.00B ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=false,hasNulls=true-24 0.00B 160.00B ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=false,hasNulls=false-24 0.00B 160.00B ± 0% +Inf% (p=0.008 n=5+5) | |
| name old allocs/op new allocs/op delta | |
| BuiltinFunctions/useSel=true,hasNulls=true-24 2.30k ± 2% 2.33k ± 1% ~ (p=0.111 n=5+5) | |
| BuiltinFunctions/useSel=true,hasNulls=false-24 2.56k ± 0% 2.56k ± 0% ~ (all equal) | |
| BuiltinFunctions/useSel=false,hasNulls=true-24 2.28k ± 1% 2.30k ± 2% ~ (p=0.310 n=5+5) | |
| BuiltinFunctions/useSel=false,hasNulls=false-24 2.56k ± 0% 2.56k ± 0% ~ (all equal) | |
| CompareSpecializedOperators/DefaultBuiltinOperator-24 7.17k ± 0% 7.17k ± 0% ~ (all equal) | |
| CompareSpecializedOperators/SpecializedSubstringOperator-24 0.00 0.00 ~ (all equal) | |
| CastOp/useSel=true/hasNulls=true/int_to_float-24 0.00 0.00 ~ (all equal) | |
| CastOp/useSel=true/hasNulls=false/int_to_float-24 0.00 0.00 ~ (all equal) | |
| CastOp/useSel=false/hasNulls=true/int_to_float-24 0.00 0.00 ~ (all equal) | |
| CastOp/useSel=false/hasNulls=false/int_to_float-24 0.00 0.00 ~ (all equal) | |
| CastOp/useSel=true/hasNulls=true/int_to_decimal-24 4.61k ± 1% 4.59k ± 1% ~ (p=0.421 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/int_to_decimal-24 5.12k ± 0% 5.12k ± 0% ~ (all equal) | |
| CastOp/useSel=false/hasNulls=true/int_to_decimal-24 4.63k ± 2% 4.63k ± 1% ~ (p=1.000 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/int_to_decimal-24 5.12k ± 0% 5.12k ± 0% ~ (all equal) | |
| CastOp/useSel=true/hasNulls=true/float_to_decimal-24 11.1k ± 2% 11.1k ± 1% ~ (p=0.548 n=5+5) | |
| CastOp/useSel=true/hasNulls=false/float_to_decimal-24 12.3k ± 0% 12.3k ± 0% ~ (all equal) | |
| CastOp/useSel=false/hasNulls=true/float_to_decimal-24 11.0k ± 1% 11.0k ± 1% ~ (p=0.421 n=5+5) | |
| CastOp/useSel=false/hasNulls=false/float_to_decimal-24 12.3k ± 0% 12.3k ± 0% ~ (all equal) | |
| Columnarize-24 20.0k ± 0% 20.0k ± 0% ~ (all equal) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=1-24 184 ±19% 176 ±19% ~ (p=0.524 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=1-24 377 ±30% 450 ±35% ~ (p=0.524 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=2-24 1.00k ±40% 0.89k ±20% ~ (p=0.524 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=1-24 5.41k ±36% 5.96k ±54% ~ (p=0.389 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=2-24 11.5k ±75% 11.1k ±48% ~ (p=0.690 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=1-24 3.14k ±19% 2.65k ±25% ~ (p=0.151 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=2-24 6.47k ±18% 6.12k ±23% ~ (p=0.690 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=1-24 46.8k ±21% 45.4k ±43% ~ (p=0.690 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=2-24 100k ±10% 94k ±17% ~ (p=0.310 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=1-24 240 ±33% 233 ±15% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=1-24 2.54k ±49% 2.91k ±31% ~ (p=0.143 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=2-24 5.04k ±21% 3.97k ± 0% ~ (p=0.667 n=5+4) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=1-24 467 ±41% 528 ±25% ~ (p=0.421 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=2-24 911 ±27% 1051 ±42% ~ (p=0.278 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=1-24 7.03k ±33% 6.14k ±23% ~ (p=0.968 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=2-24 11.5k ±44% 13.7k ±60% ~ (p=0.452 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=1-24 3.01k ±22% 3.03k ±24% ~ (p=1.000 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=2-24 6.70k ± 9% 6.52k ±16% ~ (p=0.690 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=1-24 45.9k ±20% 50.2k ±29% ~ (p=0.389 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=2-24 92.9k ±22% 96.1k ±18% ~ (p=0.841 n=5+5) | |
| LikeOps/selPrefixBytesBytesConstOp-24 0.00 0.00 ~ (all equal) | |
| LikeOps/selSuffixBytesBytesConstOp-24 0.00 0.00 ~ (all equal) | |
| LikeOps/selRegexpBytesBytesConstOp-24 0.00 0.00 ~ (all equal) | |
| ColumnarizeMaterialize-24 40.1k ± 0% 40.1k ± 0% ~ (all equal) | |
| Offset-24 0.00 0.00 ~ (all equal) | |
| OrderedSynchronizer-24 0.00 0.00 ~ (all equal) | |
| Ordinality-24 0.00 0.00 ~ (all equal) | |
| ParallelUnorderedSynchronizer-24 0.00 0.00 ~ (all equal) | |
| ProjPlusInt64Int64ConstOp/useSel=true,hasNulls=true-24 2.00 ± 0% 2.00 ± 0% ~ (all equal) | |
| ProjPlusInt64Int64ConstOp/useSel=true,hasNulls=false-24 0.00 0.00 ~ (all equal) | |
| ProjPlusInt64Int64ConstOp/useSel=false,hasNulls=true-24 2.00 ± 0% 2.00 ± 0% ~ (all equal) | |
| ProjPlusInt64Int64ConstOp/useSel=false,hasNulls=false-24 0.00 0.00 ~ (all equal) | |
| SelectInInt64/useSel=true,hasNulls=true-24 0.00 0.00 ~ (all equal) | |
| SelectInInt64/useSel=true,hasNulls=false-24 0.00 0.00 ~ (all equal) | |
| SelectInInt64/useSel=false,hasNulls=true-24 0.00 0.00 ~ (all equal) | |
| SelectInInt64/useSel=false,hasNulls=false-24 0.00 0.00 ~ (all equal) | |
| SelLTInt64Int64ConstOp/useSel=true,hasNulls=true-24 0.00 0.00 ~ (all equal) | |
| SelLTInt64Int64ConstOp/useSel=true,hasNulls=false-24 0.00 0.00 ~ (all equal) | |
| SelLTInt64Int64ConstOp/useSel=false,hasNulls=true-24 0.00 0.00 ~ (all equal) | |
| SelLTInt64Int64ConstOp/useSel=false,hasNulls=false-24 0.00 0.00 ~ (all equal) | |
| SelLTInt64Int64Op/useSel=true,hasNulls=true-24 2.00 ± 0% 2.00 ± 0% ~ (all equal) | |
| SelLTInt64Int64Op/useSel=true,hasNulls=false-24 0.00 0.00 ~ (all equal) | |
| SelLTInt64Int64Op/useSel=false,hasNulls=true-24 2.00 ± 0% 2.00 ± 0% ~ (all equal) | |
| SelLTInt64Int64Op/useSel=false,hasNulls=false-24 0.00 0.00 ~ (all equal) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=1/avgChunkSize=128-24 414 ± 1% 413 ± 3% ~ (p=0.857 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=2/avgChunkSize=128-24 351 ± 2% 358 ± 2% ~ (p=0.087 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=1/avgChunkSize=128-24 5.00k ± 2% 5.00k ± 1% ~ (p=0.571 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=2/avgChunkSize=128-24 4.04k ± 4% 3.98k ± 3% ~ (p=0.794 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=1/avgChunkSize=8-24 4.78k ± 0% 4.79k ± 0% +0.10% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=2/avgChunkSize=8-24 3.89k ± 0% 3.89k ± 0% +0.13% (p=0.016 n=4+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=3/avgChunkSize=8-24 2.80k ± 0% 2.81k ± 0% +0.18% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=4/matchLen=3/avgChunkSize=128-24 2.54k ± 0% 2.54k ± 0% +0.20% (p=0.008 n=5+5) | |
| AllSpooler/rows=262144/cols=4-24 1.22k ± 0% 1.22k ± 0% +0.25% (p=0.016 n=4+5) | |
| Sort/rows=262144/cols=4/topK=false-24 1.26k ± 0% 1.26k ± 0% +0.32% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=2/matchLen=1/avgChunkSize=128-24 1.54k ± 0% 1.55k ± 0% +0.32% (p=0.008 n=5+5) | |
| AllSpooler/rows=262144/cols=2-24 616 ± 0% 619 ± 0% +0.49% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=4/spilled=false-24 1.30k ± 0% 1.31k ± 0% +0.49% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=2/topK=false-24 635 ± 0% 639 ± 0% +0.63% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=3/avgChunkSize=128-24 447 ± 0% 450 ± 0% +0.76% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=2/spilled=false-24 682 ± 0% 688 ± 0% +0.82% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=1/avgChunkSize=8-24 461 ± 0% 465 ± 0% +0.87% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=1/avgChunkSize=128-24 461 ± 0% 465 ± 0% +0.87% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=2/avgChunkSize=8-24 461 ± 0% 465 ± 0% +0.87% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=2/avgChunkSize=128-24 461 ± 0% 465 ± 0% +0.87% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=4/matchLen=3/avgChunkSize=8-24 456 ± 0% 460 ± 0% +0.88% (p=0.008 n=5+5) | |
| AllSpooler/rows=262144/cols=1-24 314 ± 0% 317 ± 0% +0.96% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=1/avgChunkSize=8-24 404 ± 0% 408 ± 0% +1.09% (p=0.016 n=4+5) | |
| Sort/rows=262144/cols=1/topK=false-24 325 ± 0% 329 ± 0% +1.23% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=2/avgChunkSize=8-24 348 ± 0% 353 ± 0% +1.44% (p=0.016 n=4+5) | |
| ExternalSort/rows=262144/cols=1/spilled=false-24 371 ± 0% 377 ± 0% +1.62% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=2/matchLen=1/avgChunkSize=8-24 244 ± 0% 248 ± 0% +1.64% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=65536/cols=2/matchLen=1/avgChunkSize=128-24 235 ± 0% 239 ± 1% +1.70% (p=0.008 n=5+5) | |
| AllSpooler/rows=16384/cols=4-24 172 ± 0% 175 ± 0% +1.74% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=65536/cols=2/matchLen=1/avgChunkSize=8-24 1.74k ± 0% 1.77k ± 2% +1.78% (p=0.016 n=4+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=3/avgChunkSize=8-24 280 ± 0% 285 ± 0% +1.79% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=4/topK=true-24 210 ± 0% 214 ± 0% +1.90% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=4/topK=true-24 210 ± 0% 214 ± 0% +1.90% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=4/topK=true-24 210 ± 0% 214 ± 0% +1.90% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=4/matchLen=3/avgChunkSize=128-24 260 ± 0% 265 ± 0% +1.92% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=4/topK=false-24 207 ± 0% 211 ± 0% +1.93% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=2/topK=true-24 178 ± 0% 182 ± 0% +2.25% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=2/topK=true-24 178 ± 0% 182 ± 0% +2.25% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=2/topK=true-24 178 ± 0% 182 ± 0% +2.25% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=4/spilled=false-24 253 ± 0% 259 ± 0% +2.37% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=1/topK=true-24 162 ± 0% 166 ± 0% +2.47% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=1/topK=true-24 162 ± 0% 166 ± 0% +2.47% (p=0.008 n=5+5) | |
| Sort/rows=262144/cols=1/topK=true-24 162 ± 0% 166 ± 0% +2.47% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=2/matchLen=1/avgChunkSize=128-24 163 ± 0% 168 ± 0% +3.07% (p=0.029 n=4+4) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=1/avgChunkSize=8-24 129 ± 0% 133 ± 0% +3.10% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=1/avgChunkSize=128-24 129 ± 0% 133 ± 0% +3.10% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=2/avgChunkSize=8-24 129 ± 0% 133 ± 0% +3.10% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=2/avgChunkSize=128-24 129 ± 0% 133 ± 0% +3.10% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=4-24 32.0 ± 0% 33.0 ± 0% +3.12% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=3/avgChunkSize=8-24 126 ± 0% 130 ± 0% +3.17% (p=0.016 n=5+4) | |
| AllSpooler/rows=16384/cols=2-24 92.0 ± 0% 95.0 ± 0% +3.26% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=4/spilled=true-24 517 ± 0% 534 ± 0% +3.29% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=4/matchLen=3/avgChunkSize=128-24 121 ± 0% 125 ± 0% +3.31% (p=0.016 n=4+5) | |
| ExternalSort/rows=16384/cols=4/spilled=true-24 1.74k ± 0% 1.80k ± 0% +3.39% (p=0.008 n=5+5) | |
| SortChunks/CHUNKS/rows=4096/cols=2/matchLen=1/avgChunkSize=8-24 178 ± 0% 184 ± 2% +3.48% (p=0.016 n=4+5) | |
| ExternalSort/rows=262144/cols=4/spilled=true-24 22.0k ± 0% 22.8k ± 0% +3.54% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=2/topK=false-24 111 ± 0% 115 ± 0% +3.60% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=2/spilled=false-24 157 ± 0% 163 ± 0% +3.82% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=4/topK=false-24 103 ± 0% 107 ± 0% +3.88% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=4/spilled=false-24 149 ± 0% 155 ± 0% +4.03% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=2/spilled=true-24 352 ± 0% 367 ± 0% +4.26% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=4-24 68.0 ± 0% 71.0 ± 0% +4.41% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| Distinct/Ordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=2-24 22.0 ± 0% 23.0 ± 0% +4.55% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=2/matchLen=1/avgChunkSize=128-24 72.0 ± 0% 75.4 ± 1% +4.72% (p=0.016 n=4+5) | |
| ExternalSort/rows=16384/cols=2/spilled=true-24 901 ± 0% 944 ± 0% +4.77% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=1/spilled=true-24 263 ± 0% 276 ± 0% +4.94% (p=0.008 n=5+5) | |
| SortChunks/ALL/rows=4096/cols=2/matchLen=1/avgChunkSize=8-24 75.6 ± 1% 79.4 ± 1% +5.03% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=2/spilled=true-24 10.0k ± 0% 10.5k ± 0% +5.26% (p=0.016 n=5+4) | |
| ExternalSort/rows=16384/cols=1/spilled=false-24 108 ± 0% 114 ± 0% +5.56% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=2/spilled=false-24 105 ± 0% 111 ± 0% +5.71% (p=0.008 n=5+5) | |
| AllSpooler/rows=16384/cols=1-24 52.0 ± 0% 55.0 ± 0% +5.77% (p=0.008 n=5+5) | |
| Sort/rows=16384/cols=1/topK=false-24 63.0 ± 0% 67.0 ± 0% +6.35% (p=0.008 n=5+5) | |
| ExternalSort/rows=16384/cols=1/spilled=true-24 531 ± 0% 566 ± 0% +6.59% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=2/topK=false-24 59.0 ± 0% 63.0 ± 0% +6.78% (p=0.008 n=5+5) | |
| ExternalSort/rows=2048/cols=1/spilled=false-24 82.0 ± 0% 88.0 ± 0% +7.32% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=2-24 107 ± 0% 115 ± 0% +7.48% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=2-24 40.0 ± 0% 43.0 ± 0% +7.50% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=2-24 117 ± 0% 126 ± 1% +7.69% (p=0.016 n=4+5) | |
| HashRouter/numOutputs=8/numInputBatches=2-24 115 ± 0% 124 ± 0% +7.83% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=2-24 112 ± 0% 121 ± 0% +8.04% (p=0.008 n=5+5) | |
| ExternalSort/rows=262144/cols=1/spilled=true-24 4.76k ± 0% 5.15k ± 0% +8.30% (p=0.029 n=4+4) | |
| HashRouter/numOutputs=16/numInputBatches=4-24 154 ± 0% 167 ± 0% +8.44% (p=0.016 n=5+4) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=4/spillForced=true-24 4.73k ± 0% 5.17k ± 0% +9.21% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=4/spillForced=true-24 4.73k ± 0% 5.17k ± 0% +9.23% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=4/spillForced=true-24 4.73k ± 0% 5.17k ± 0% +9.26% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=4/spillForced=true-24 4.73k ± 0% 5.17k ± 0% +9.26% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=8-24 252 ± 0% 275 ± 0% +9.30% (p=0.016 n=5+4) | |
| HashRouter/numOutputs=4/numInputBatches=8-24 251 ± 0% 274 ± 0% +9.32% (p=0.016 n=4+5) | |
| HashRouter/numOutputs=2/numInputBatches=8-24 246 ± 0% 269 ± 0% +9.43% (p=0.016 n=4+5) | |
| HashRouter/numOutputs=8/numInputBatches=8-24 251 ± 1% 275 ± 0% +9.56% (p=0.016 n=5+4) | |
| HashRouter/numOutputs=4/numInputBatches=4-24 158 ± 2% 173 ± 1% +9.90% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=16-24 421 ± 1% 464 ± 1% +10.01% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=16/numInputBatches=16-24 425 ± 0% 468 ± 0% +10.12% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=4-24 159 ± 0% 176 ± 0% +10.16% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=2/numInputBatches=4-24 153 ± 1% 169 ± 0% +10.48% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=4/numInputBatches=16-24 425 ± 1% 469 ± 0% +10.50% (p=0.008 n=5+5) | |
| MergeJoiner/rows=1024-24 38.0 ± 0% 42.0 ± 0% +10.53% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=1024-24 38.0 ± 0% 42.0 ± 0% +10.53% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=1024-24 38.0 ± 0% 42.0 ± 0% +10.53% (p=0.008 n=5+5) | |
| HashRouter/numOutputs=8/numInputBatches=16-24 426 ± 1% 471 ± 1% +10.56% (p=0.008 n=5+5) | |
| Sort/rows=2048/cols=1/topK=false-24 37.0 ± 0% 41.0 ± 0% +10.81% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 66.4 ± 4% 73.8 ± 2% +11.14% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 68.0 ± 3% 75.8 ± 2% +11.47% (p=0.008 n=5+5) | |
| AllSpooler/rows=2048/cols=1-24 26.0 ± 0% 29.0 ± 0% +11.54% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=2/ordCols=0-24 72.4 ± 5% 81.0 ± 0% +11.88% (p=0.008 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=2-24 370 ± 1% 416 ±16% +12.54% (p=0.048 n=4+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 82.0 ± 0% 92.6 ± 3% +12.93% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=4/ordCols=0-24 116 ± 0% 131 ± 0% +12.93% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=4096/cols=4/ordCols=0-24 116 ± 0% 131 ± 0% +12.93% (p=0.016 n=5+4) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 82.0 ± 0% 93.0 ± 2% +13.41% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 108 ± 0% 123 ± 0% +13.89% (p=0.029 n=4+4) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=128/spillForced=true-24 92.2k ± 0% 105.0k ± 0% +13.94% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=128/spillForced=true-24 92.2k ± 0% 105.0k ± 0% +13.96% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=128/spillForced=true-24 92.2k ± 0% 105.0k ± 0% +13.97% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=128/spillForced=true-24 92.2k ± 0% 105.0k ± 0% +13.97% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 136 ± 0% 155 ± 3% +13.97% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 136 ± 0% 155 ± 0% +13.97% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=2048-24 148 ± 0% 169 ± 0% +14.19% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=2048-24 148 ± 0% 169 ± 0% +14.19% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=2048-24 146 ± 0% 167 ± 0% +14.38% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=2048-24 146 ± 0% 167 ± 0% +14.38% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=4096/cols=2/ordCols=0-24 70.8 ± 2% 81.0 ± 0% +14.41% (p=0.008 n=5+5) | |
| MergeJoiner/rows=4096-24 152 ± 0% 174 ± 0% +14.47% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=4096-24 152 ± 0% 174 ± 0% +14.47% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=4096-24 152 ± 0% 174 ± 0% +14.47% (p=0.008 n=5+5) | |
| MergeJoiner/rows=16384-24 608 ± 0% 702 ± 0% +15.46% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=16384-24 608 ± 0% 702 ± 0% +15.46% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=16384-24 608 ± 0% 702 ± 0% +15.46% (p=0.008 n=5+5) | |
| MergeJoiner/bothSidesRepeat-rows=32768-24 1.22k ± 0% 1.41k ± 0% +15.61% (p=0.008 n=5+5) | |
| MergeJoiner/rows=1048576-24 38.9k ± 0% 45.1k ± 0% +15.78% (p=0.008 n=5+5) | |
| MergeJoiner/oneSideRepeat-rows=1048576-24 38.9k ± 0% 45.1k ± 0% +15.78% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=2048-24 150 ± 0% 175 ± 0% +16.67% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=2048-24 150 ± 0% 175 ± 0% +16.67% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=2048-24 148 ± 0% 173 ± 0% +16.89% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=2048-24 148 ± 0% 173 ± 0% +16.89% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 102 ± 2% 121 ± 5% +17.77% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=4/spillForced=false-24 290 ± 0% 360 ± 0% +24.14% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=4/spillForced=false-24 290 ± 0% 360 ± 0% +24.14% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=4/spillForced=false-24 287 ± 0% 357 ± 0% +24.39% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=4/spillForced=false-24 287 ± 0% 357 ± 0% +24.39% (p=0.008 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=2-24 299 ±22% 393 ±34% +31.68% (p=0.032 n=5+5) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=1-24 1.47k ±37% 2.01k ± 0% +36.97% (p=0.016 n=5+4) | |
| Distinct/PartiallyOrdered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=2-24 2.17k ± 0% 3.25k ±77% +49.78% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=2/ordCols=0-24 200 ± 0% 329 ± 1% +64.50% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=2/ordCols=0-24 209 ± 2% 346 ± 2% +65.58% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=2/ordCols=0-24 195 ± 2% 326 ± 1% +66.91% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=2/ordCols=0-24 208 ± 0% 348 ± 4% +67.31% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=65536/cols=4/ordCols=0-24 369 ± 1% 624 ± 2% +69.14% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.010/rows=65536/cols=4/ordCols=0-24 387 ± 3% 654 ± 3% +69.22% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.010/rows=65536/cols=4/ordCols=0-24 388 ± 2% 658 ± 3% +69.40% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=65536/cols=4/ordCols=0-24 356 ± 0% 618 ± 2% +73.65% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=2/ordCols=0-24 231 ± 0% 489 ± 3% +111.69% (p=0.008 n=5+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=2/ordCols=0-24 231 ± 0% 495 ± 4% +114.11% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=65536/cols=4/ordCols=0-24 429 ± 0% 938 ± 1% +118.55% (p=0.016 n=4+5) | |
| Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=65536/cols=4/ordCols=0-24 429 ± 0% 949 ± 4% +121.31% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=262144-24 1.30k ± 0% 3.35k ± 0% +157.80% (p=0.016 n=5+4) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=262144-24 1.30k ± 0% 3.36k ± 0% +157.87% (p=0.016 n=4+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=262144-24 1.30k ± 0% 3.35k ± 0% +157.87% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=262144-24 1.30k ± 0% 3.36k ± 0% +158.02% (p=0.016 n=4+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=262144-24 1.30k ± 0% 3.35k ± 0% +158.12% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=262144-24 1.30k ± 0% 3.36k ± 0% +158.14% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=262144-24 1.30k ± 0% 3.35k ± 0% +158.21% (p=0.016 n=4+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=262144-24 1.30k ± 0% 3.36k ± 0% +158.26% (p=0.016 n=4+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=false/rows=4194304-24 16.8k ± 0% 49.5k ± 0% +195.59% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=false/rows=4194304-24 16.8k ± 0% 49.5k ± 0% +195.60% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=true/rows=4194304-24 16.8k ± 0% 49.5k ± 0% +195.62% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=true/distinct=true/rows=4194304-24 16.8k ± 0% 49.5k ± 0% +195.62% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=true/distinct=false/rows=4194304-24 16.8k ± 0% 49.5k ± 0% +195.63% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=true/rows=4194304-24 16.8k ± 0% 49.5k ± 0% +195.64% (p=0.008 n=5+5) | |
| HashJoiner/nulls=false/fullOuter=false/distinct=true/rows=4194304-24 16.8k ± 0% 49.5k ± 0% +195.65% (p=0.008 n=5+5) | |
| HashJoiner/nulls=true/fullOuter=false/distinct=false/rows=4194304-24 16.8k ± 0% 49.5k ± 0% +195.67% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=true/batches=128/spillForced=false-24 891 ± 0% 2945 ± 0% +230.36% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=true/batches=128/spillForced=false-24 890 ± 0% 2945 ± 0% +230.73% (p=0.008 n=5+5) | |
| ExternalHashJoiner/nulls=true/fullOuter=false/batches=128/spillForced=false-24 889 ± 0% 2941 ± 0% +230.87% (p=0.016 n=4+5) | |
| ExternalHashJoiner/nulls=false/fullOuter=false/batches=128/spillForced=false-24 888 ± 0% 2943 ± 0% +231.34% (p=0.016 n=5+4) | |
| LogicalProjOp/AND,useSel=true,hasNulls=true-24 0.00 1.00 ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=true,hasNulls=false-24 0.00 1.00 ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=false,hasNulls=true-24 0.00 1.00 ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/AND,useSel=false,hasNulls=false-24 0.00 1.00 ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=true,hasNulls=true-24 0.00 1.00 ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=true,hasNulls=false-24 0.00 1.00 ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=false,hasNulls=true-24 0.00 1.00 ± 0% +Inf% (p=0.008 n=5+5) | |
| LogicalProjOp/OR,useSel=false,hasNulls=false-24 0.00 1.00 ± 0% +Inf% (p=0.008 n=5+5) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment