-
-
Save mgartner/9e2bff7eaef825d0224363b41538c973 to your computer and use it in GitHub Desktop.
Comparing release-22.2@c31b03d31 to master@6f444d4f8
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 | |
Phases/single-col-histogram-range/Prepared/AssignPlaceholdersNoNorm-24 72.9µs ± 2% 48.6µs ± 0% -33.37% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/AssignPlaceholdersNorm-24 71.9µs ± 1% 48.6µs ± 0% -32.47% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/Explore-24 79.9µs ± 1% 57.2µs ± 2% -28.44% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/OptBuildNorm-24 165µs ± 1% 119µs ± 0% -27.59% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/Explore-24 177µs ± 1% 130µs ± 0% -26.64% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/ExecBuild-24 85.1µs ± 2% 62.6µs ± 1% -26.48% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/AssignPlaceholdersNorm-24 10.9ms ± 0% 8.1ms ± 0% -25.76% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/AssignPlaceholdersNoNorm-24 10.9ms ± 1% 8.1ms ± 1% -25.70% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/ExecBuild-24 184µs ± 0% 138µs ± 1% -25.16% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/OptBuildNoNorm-24 11.9ms ± 0% 9.1ms ± 0% -22.95% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/OptBuildNoNorm-24 99.0µs ± 1% 76.5µs ± 0% -22.66% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/OptBuildNorm-24 13.2ms ± 0% 10.3ms ± 1% -21.72% (p=0.008 n=5+5) | |
SlowQueries/slow-query-2-24 498ms ± 1% 392ms ± 0% -21.26% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-many/Simple-24 39.4ms ± 7% 32.0ms ± 6% -18.65% (p=0.008 n=5+5) | |
SlowQueries/slow-query-1-24 37.7ms ± 1% 30.7ms ± 0% -18.55% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-many/Prepared-24 34.6ms ± 2% 28.7ms ± 4% -17.04% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-one/Simple-24 23.5ms ± 3% 19.9ms ± 2% -15.22% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-one/Prepared-24 24.4ms ± 2% 20.8ms ± 3% -14.81% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/ExecBuild-24 354ms ± 1% 314ms ± 1% -11.39% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/Explore-24 346ms ± 1% 314ms ± 1% -9.20% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/Explore-24 369ms ± 2% 340ms ± 0% -8.10% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/ExecBuild-24 366ms ± 1% 338ms ± 1% -7.65% (p=0.008 n=5+5) | |
EndToEnd/many-columns-and-indexes-c/Simple-24 359ms ± 0% 344ms ± 1% -4.39% (p=0.029 n=4+4) | |
EndToEnd/many-columns-and-indexes-c/Prepared-24 359ms ± 0% 345ms ± 1% -4.04% (p=0.008 n=5+5) | |
EndToEnd/ored-preds-100/Prepared-24 1.32ms ± 1% 1.27ms ± 2% -3.75% (p=0.008 n=5+5) | |
Chain/chain-19-24 29.0ms ± 1% 28.3ms ± 0% -2.49% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Prepared/Explore-24 41.7µs ± 0% 40.6µs ± 0% -2.42% (p=0.016 n=4+5) | |
Chain/chain-16-24 20.4ms ± 1% 19.9ms ± 0% -2.33% (p=0.008 n=5+5) | |
Chain/chain-14-24 15.6ms ± 2% 15.3ms ± 1% -2.25% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/OptBuildNoNorm-24 5.13ms ± 1% 5.02ms ± 1% -2.12% (p=0.008 n=5+5) | |
Chain/chain-15-24 17.8ms ± 1% 17.5ms ± 0% -1.50% (p=0.008 n=5+5) | |
Chain/chain-12-24 11.1ms ± 2% 11.0ms ± 0% -1.43% (p=0.008 n=5+5) | |
Chain/chain-11-24 9.08ms ± 1% 8.97ms ± 0% -1.21% (p=0.008 n=5+5) | |
Chain/chain-17-24 22.8ms ± 0% 22.6ms ± 0% -0.84% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/AssignPlaceholdersNoNorm-24 63.3µs ± 0% 63.5µs ± 0% ~ (p=0.056 n=5+5) | |
Phases/batch-insert-one/Simple/Parse-24 25.3µs ± 0% 25.1µs ± 1% ~ (p=0.095 n=5+5) | |
Phases/batch-insert-one/Simple/OptBuildNoNorm-24 88.5µs ± 3% 89.0µs ± 1% ~ (p=0.151 n=5+5) | |
Phases/batch-insert-one/Simple/OptBuildNorm-24 105µs ± 1% 105µs ± 1% ~ (p=0.421 n=5+5) | |
Phases/batch-insert-one/Simple/Explore-24 112µs ± 1% 113µs ± 0% ~ (p=0.095 n=5+5) | |
Phases/batch-insert-one/Simple/ExecBuild-24 117µs ± 1% 117µs ± 1% ~ (p=1.000 n=5+5) | |
Phases/batch-insert-many/Simple/Parse-24 2.41ms ± 2% 2.38ms ± 1% ~ (p=0.421 n=5+5) | |
Phases/batch-insert-many/Simple/OptBuildNorm-24 7.54ms ± 2% 7.48ms ± 1% ~ (p=0.310 n=5+5) | |
Phases/batch-insert-many/Simple/Explore-24 7.96ms ± 3% 7.87ms ± 1% ~ (p=0.222 n=5+5) | |
Phases/batch-insert-many/Simple/ExecBuild-24 7.96ms ± 2% 7.99ms ± 1% ~ (p=0.690 n=5+5) | |
Phases/ored-preds-100/Prepared/ExecBuild-24 105µs ± 0% 106µs ± 0% ~ (p=0.056 n=5+5) | |
Chain/chain-8-24 3.42ms ± 0% 3.42ms ± 0% ~ (p=0.690 n=5+5) | |
Chain/chain-9-24 5.22ms ± 0% 5.22ms ± 1% ~ (p=0.841 n=5+5) | |
Chain/chain-10-24 7.08ms ± 0% 7.08ms ± 0% ~ (p=0.841 n=5+5) | |
Chain/chain-13-24 13.3ms ± 1% 13.2ms ± 1% ~ (p=0.310 n=5+5) | |
Chain/chain-18-24 25.5ms ± 1% 25.4ms ± 0% ~ (p=0.310 n=5+5) | |
EndToEnd/kv-read/Simple-24 495µs ± 3% 505µs ± 1% ~ (p=0.095 n=5+5) | |
EndToEnd/kv-read-const/Simple-24 359µs ± 3% 370µs ± 1% ~ (p=0.095 n=5+5) | |
EndToEnd/tpcc-delivery/Prepared-24 464µs ± 1% 467µs ± 1% ~ (p=0.151 n=5+5) | |
EndToEnd/tpcc-stock-level/Simple-24 1.14ms ± 1% 1.15ms ± 1% ~ (p=0.056 n=5+5) | |
EndToEnd/tpcc-stock-level/Prepared-24 853µs ± 1% 857µs ± 3% ~ (p=0.690 n=5+5) | |
EndToEnd/many-columns-and-indexes-a/Simple-24 1.22ms ± 3% 1.25ms ± 5% ~ (p=0.222 n=5+5) | |
EndToEnd/many-columns-and-indexes-a/Prepared-24 1.01ms ± 1% 1.01ms ± 1% ~ (p=0.222 n=5+5) | |
EndToEnd/many-columns-and-indexes-b/Simple-24 1.35ms ± 1% 1.36ms ± 1% ~ (p=0.222 n=5+5) | |
EndToEnd/many-columns-and-indexes-b/Prepared-24 1.11ms ± 1% 1.12ms ± 1% ~ (p=0.056 n=5+5) | |
EndToEnd/single-col-histogram-range/Simple-24 672µs ± 2% 675µs ± 2% ~ (p=0.310 n=5+5) | |
EndToEnd/ored-preds-using-params-100/Prepared-24 2.86ms ± 1% 2.89ms ± 0% ~ (p=0.056 n=5+5) | |
SlowQueries/slow-query-3-24 105ms ± 5% 101ms ± 0% ~ (p=0.190 n=5+4) | |
Phases/tpcc-stock-level/Prepared/AssignPlaceholdersNorm-24 66.6µs ± 0% 67.0µs ± 0% +0.59% (p=0.032 n=5+5) | |
Chain/chain-7-24 2.23ms ± 1% 2.26ms ± 1% +1.17% (p=0.016 n=5+5) | |
EndToEnd/single-col-histogram-range/Prepared-24 432µs ± 1% 440µs ± 2% +1.77% (p=0.032 n=5+5) | |
Phases/batch-insert-many/Prepared/ExecBuild-24 73.2µs ± 0% 74.6µs ± 3% +1.85% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/Explore-24 432µs ± 0% 440µs ± 0% +1.86% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/Explore-24 247µs ± 1% 252µs ± 0% +1.98% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Prepared/ExecBuild-24 44.3µs ± 1% 45.2µs ± 0% +2.04% (p=0.008 n=5+5) | |
EndToEnd/tpcc-new-order/Prepared-24 345µs ± 1% 353µs ± 1% +2.24% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/Explore-24 380µs ± 0% 389µs ± 0% +2.27% (p=0.008 n=5+5) | |
EndToEnd/tpcc-delivery/Simple-24 676µs ± 2% 692µs ± 1% +2.32% (p=0.016 n=5+5) | |
Chain/chain-6-24 1.44ms ± 0% 1.47ms ± 0% +2.36% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/ExecBuild-24 437µs ± 0% 448µs ± 0% +2.40% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/ExecBuild-24 385µs ± 0% 394µs ± 0% +2.41% (p=0.008 n=5+5) | |
FKInsert/MultiRowMultiParent/None-24 1.16ms ± 0% 1.20ms ± 2% +2.96% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/AssignPlaceholdersNorm-24 268µs ± 0% 276µs ± 0% +2.97% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/ExecBuild-24 265µs ± 1% 273µs ± 0% +2.97% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/AssignPlaceholdersNoNorm-24 268µs ± 0% 276µs ± 0% +3.05% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/AssignPlaceholdersNoNorm-24 259µs ± 0% 267µs ± 0% +3.13% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/AssignPlaceholdersNorm-24 259µs ± 0% 267µs ± 0% +3.31% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/AssignPlaceholdersNorm-24 571µs ± 1% 592µs ± 0% +3.63% (p=0.008 n=5+5) | |
EndToEnd/kv-read-const/Prepared-24 326µs ± 2% 338µs ± 2% +3.69% (p=0.008 n=5+5) | |
EndToEnd/tpcc-new-order/Simple-24 562µs ± 2% 582µs ± 1% +3.72% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Prepared/AssignPlaceholdersNorm-24 15.9µs ± 0% 16.5µs ± 1% +3.84% (p=0.008 n=5+5) | |
FKInsert/MultiRowSingleParent/None-24 1.14ms ± 2% 1.19ms ± 2% +3.89% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Prepared/AssignPlaceholdersNoNorm-24 15.9µs ± 0% 16.5µs ± 0% +3.98% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/Explore-24 126µs ± 1% 131µs ± 1% +4.00% (p=0.008 n=5+5) | |
EndToEnd/kv-read/Prepared-24 317µs ± 2% 330µs ± 1% +4.16% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/AssignPlaceholdersNoNorm-24 570µs ± 0% 595µs ± 0% +4.25% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/Explore-24 46.4µs ± 1% 48.4µs ± 1% +4.42% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/Explore-24 46.0µs ± 1% 48.1µs ± 1% +4.56% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/Explore-24 1.44ms ± 1% 1.51ms ± 2% +4.61% (p=0.008 n=5+5) | |
Chain/chain-5-24 886µs ± 1% 927µs ± 1% +4.63% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/ExecBuild-24 1.56ms ± 1% 1.63ms ± 1% +4.90% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/Explore-24 506µs ± 0% 531µs ± 0% +4.94% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/ExecBuild-24 513µs ± 0% 539µs ± 0% +5.09% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/Explore-24 422µs ± 0% 444µs ± 0% +5.22% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/Explore-24 571µs ± 0% 603µs ± 1% +5.51% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/Explore-24 106µs ± 0% 112µs ± 1% +5.64% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/ExecBuild-24 585µs ± 1% 618µs ± 0% +5.67% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/ExecBuild-24 49.0µs ± 1% 51.8µs ± 0% +5.68% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/ExecBuild-24 110µs ± 1% 116µs ± 1% +5.69% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/ExecBuild-24 129µs ± 1% 137µs ± 1% +5.75% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/ExecBuild-24 49.2µs ± 0% 52.1µs ± 0% +5.93% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/ExecBuild-24 428µs ± 0% 453µs ± 0% +6.01% (p=0.008 n=5+5) | |
Chain/chain-1-24 15.8µs ± 0% 16.8µs ± 0% +6.15% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/OptBuildNorm-24 36.6µs ± 1% 38.9µs ± 0% +6.29% (p=0.008 n=5+5) | |
Chain/chain-4-24 524µs ± 0% 557µs ± 1% +6.31% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/OptBuildNorm-24 297µs ± 0% 316µs ± 0% +6.58% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/OptBuildNorm-24 335µs ± 0% 357µs ± 0% +6.59% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/OptBuildNoNorm-24 321µs ± 0% 342µs ± 0% +6.61% (p=0.008 n=5+5) | |
EndToEnd/ored-preds-using-params-100/Simple-24 4.29ms ± 1% 4.58ms ± 1% +6.81% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/OptBuildNorm-24 362µs ± 2% 387µs ± 1% +6.81% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/OptBuildNorm-24 36.7µs ± 1% 39.3µs ± 0% +6.95% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/OptBuildNoNorm-24 291µs ± 0% 311µs ± 0% +6.96% (p=0.008 n=5+5) | |
FKInsert/MultiRowMultiParent/NoFastPath-24 1.50ms ± 2% 1.61ms ± 1% +7.17% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Prepared/ExecBuild-24 1.90µs ± 0% 2.04µs ± 0% +7.42% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/OptBuildNorm-24 74.1µs ± 1% 79.7µs ± 2% +7.49% (p=0.008 n=5+5) | |
Chain/chain-3-24 278µs ± 0% 299µs ± 1% +7.65% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/OptBuildNoNorm-24 60.2µs ± 1% 64.9µs ± 0% +7.84% (p=0.008 n=5+5) | |
EndToEnd/ored-preds-100/Simple-24 2.52ms ± 0% 2.72ms ± 1% +8.10% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/OptBuildNoNorm-24 32.6µs ± 1% 35.3µs ± 1% +8.12% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/OptBuildNoNorm-24 32.9µs ± 1% 35.7µs ± 1% +8.41% (p=0.008 n=5+5) | |
FKInsert/MultiRowSingleParent/FastPath-24 868µs ± 1% 943µs ± 2% +8.69% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/OptBuildNorm-24 84.2µs ± 0% 91.6µs ± 0% +8.73% (p=0.008 n=5+5) | |
FKInsert/MultiRowSingleParent/NoFastPath-24 1.41ms ± 5% 1.53ms ± 5% +8.76% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/ExecBuild-24 3.43ms ± 1% 3.74ms ± 0% +8.77% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Prepared/ExecBuild-24 1.75µs ± 1% 1.91µs ± 0% +9.12% (p=0.008 n=5+5) | |
Chain/chain-2-24 114µs ± 0% 124µs ± 0% +9.23% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/Explore-24 3.33ms ± 0% 3.63ms ± 1% +9.27% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/OptBuildNoNorm-24 198µs ± 1% 217µs ± 1% +9.31% (p=0.008 n=5+5) | |
FKInsert/MultiRowMultiParent/FastPath-24 1.03ms ± 1% 1.13ms ± 1% +9.37% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/OptBuildNoNorm-24 70.8µs ± 1% 77.7µs ± 1% +9.70% (p=0.008 n=5+5) | |
FKInsert/SingleRow/None-24 739µs ± 1% 811µs ± 4% +9.78% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/Explore-24 3.10ms ± 0% 3.41ms ± 0% +9.89% (p=0.008 n=5+5) | |
FKInsert/SingleRow/NoFastPath-24 1.04ms ± 1% 1.15ms ± 1% +9.89% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/ExecBuild-24 3.22ms ± 0% 3.54ms ± 1% +9.95% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/OptBuildNorm-24 2.22ms ± 0% 2.47ms ± 0% +11.17% (p=0.016 n=4+5) | |
Phases/ored-preds-using-params-100/Simple/OptBuildNoNorm-24 2.20ms ± 1% 2.46ms ± 1% +11.49% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/OptBuildNorm-24 2.40ms ± 0% 2.69ms ± 0% +11.83% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/Parse-24 14.1µs ± 0% 15.8µs ± 0% +12.10% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/Parse-24 14.0µs ± 0% 15.7µs ± 0% +12.19% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/OptBuildNoNorm-24 2.37ms ± 0% 2.67ms ± 1% +12.36% (p=0.008 n=5+5) | |
Phases/kv-read/Prepared/ExecBuild-24 1.37µs ± 0% 1.54µs ± 2% +12.52% (p=0.008 n=5+5) | |
FKInsert/SingleRow/FastPath-24 678µs ± 1% 768µs ± 1% +13.14% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/Parse-24 24.2µs ± 0% 28.1µs ± 0% +16.40% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/Parse-24 30.1µs ± 0% 35.6µs ± 0% +18.16% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/Parse-24 133µs ± 0% 157µs ± 0% +18.16% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/Parse-24 12.5µs ± 0% 14.8µs ± 0% +18.44% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/Parse-24 10.3µs ± 0% 12.3µs ± 0% +19.10% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/Parse-24 52.1µs ± 0% 62.8µs ± 1% +20.58% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/Parse-24 23.1µs ± 0% 28.2µs ± 0% +22.28% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/Parse-24 1.07ms ± 0% 1.32ms ± 0% +22.92% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/Parse-24 1.08ms ± 0% 1.33ms ± 0% +23.02% (p=0.008 n=5+5) | |
Phases/kv-read-const/Prepared/ExecBuild-24 1.15µs ± 0% 1.62µs ± 0% +40.32% (p=0.008 n=5+5) | |
name old alloc/op new alloc/op delta | |
Phases/single-col-histogram-range/Prepared/AssignPlaceholdersNoNorm-24 40.6kB ± 0% 10.5kB ± 0% -74.04% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/AssignPlaceholdersNorm-24 40.6kB ± 0% 10.5kB ± 0% -74.04% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/Explore-24 42.8kB ± 0% 12.8kB ± 0% -70.07% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/OptBuildNorm-24 85.7kB ± 0% 26.4kB ± 0% -69.14% (p=0.016 n=4+5) | |
SlowQueries/slow-query-2-24 156MB ± 0% 49MB ± 0% -68.77% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/ExecBuild-24 43.6kB ± 0% 14.3kB ± 0% -67.16% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/Explore-24 88.5kB ± 0% 29.3kB ± 0% -66.89% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/ExecBuild-24 89.2kB ± 0% 30.8kB ± 0% -65.49% (p=0.016 n=4+5) | |
Phases/single-col-histogram-range/Simple/OptBuildNoNorm-24 47.3kB ± 0% 18.1kB ± 0% -61.75% (p=0.016 n=4+5) | |
Phases/many-columns-and-indexes-c/Prepared/AssignPlaceholdersNorm-24 3.65MB ± 0% 2.05MB ± 0% -43.81% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/AssignPlaceholdersNoNorm-24 3.65MB ± 0% 2.05MB ± 0% -43.81% (p=0.008 n=5+5) | |
SlowQueries/slow-query-1-24 12.2MB ± 0% 7.0MB ± 0% -42.40% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/OptBuildNoNorm-24 4.30MB ± 0% 2.93MB ± 0% -31.91% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/OptBuildNorm-24 4.75MB ± 0% 3.26MB ± 0% -31.35% (p=0.008 n=5+5) | |
EndToEnd/many-columns-and-indexes-c/Simple-24 124MB ± 2% 108MB ± 0% -13.15% (p=0.029 n=4+4) | |
EndToEnd/many-columns-and-indexes-c/Prepared-24 124MB ± 1% 108MB ± 0% -12.81% (p=0.016 n=5+4) | |
EndToEnd/batch-insert-one/Simple-24 4.51MB ± 2% 3.94MB ± 2% -12.68% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/Explore-24 121MB ± 0% 106MB ± 0% -12.55% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/ExecBuild-24 122MB ± 0% 106MB ± 0% -12.54% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/Explore-24 123MB ± 0% 107MB ± 0% -12.35% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/ExecBuild-24 123MB ± 0% 108MB ± 0% -12.33% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-one/Prepared-24 4.57MB ± 7% 4.06MB ± 6% -11.11% (p=0.016 n=5+5) | |
SlowQueries/slow-query-3-24 50.1MB ± 0% 45.1MB ± 0% -9.95% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-many/Prepared-24 9.38MB ± 3% 8.69MB ± 3% -7.41% (p=0.016 n=5+4) | |
Chain/chain-13-24 2.79MB ± 0% 2.63MB ± 0% -5.74% (p=0.008 n=5+5) | |
Chain/chain-12-24 2.39MB ± 0% 2.25MB ± 0% -5.71% (p=0.008 n=5+5) | |
Chain/chain-14-24 3.23MB ± 0% 3.04MB ± 0% -5.68% (p=0.008 n=5+5) | |
Chain/chain-10-24 1.57MB ± 0% 1.49MB ± 0% -5.67% (p=0.008 n=5+5) | |
Chain/chain-11-24 2.01MB ± 0% 1.90MB ± 0% -5.60% (p=0.008 n=5+5) | |
Chain/chain-17-24 4.61MB ± 0% 4.35MB ± 0% -5.52% (p=0.008 n=5+5) | |
Chain/chain-19-24 5.45MB ± 0% 5.15MB ± 0% -5.52% (p=0.008 n=5+5) | |
Chain/chain-18-24 5.03MB ± 0% 4.75MB ± 0% -5.51% (p=0.008 n=5+5) | |
Chain/chain-16-24 4.19MB ± 0% 3.96MB ± 0% -5.49% (p=0.008 n=5+5) | |
Chain/chain-15-24 3.79MB ± 0% 3.58MB ± 0% -5.46% (p=0.008 n=5+5) | |
Chain/chain-9-24 1.22MB ± 0% 1.16MB ± 0% -5.17% (p=0.008 n=5+5) | |
Chain/chain-8-24 849kB ± 0% 809kB ± 0% -4.68% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/OptBuildNoNorm-24 562kB ± 0% 537kB ± 0% -4.47% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/OptBuildNorm-24 563kB ± 0% 538kB ± 0% -4.46% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/OptBuildNoNorm-24 582kB ± 0% 556kB ± 0% -4.33% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/OptBuildNorm-24 582kB ± 0% 557kB ± 0% -4.31% (p=0.008 n=5+5) | |
Chain/chain-7-24 562kB ± 0% 539kB ± 0% -4.03% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/AssignPlaceholdersNorm-24 19.7kB ± 0% 19.0kB ± 0% -3.41% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/AssignPlaceholdersNoNorm-24 20.0kB ± 0% 19.4kB ± 0% -3.34% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/Explore-24 58.4kB ± 0% 56.6kB ± 0% -3.05% (p=0.008 n=5+5) | |
Chain/chain-6-24 381kB ± 0% 371kB ± 0% -2.79% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/ExecBuild-24 62.3kB ± 0% 60.6kB ± 0% -2.69% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/Explore-24 953kB ± 0% 928kB ± 0% -2.61% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/Explore-24 972kB ± 0% 947kB ± 0% -2.57% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/ExecBuild-24 983kB ± 0% 958kB ± 0% -2.50% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/Explore-24 131kB ± 0% 127kB ± 0% -2.48% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/ExecBuild-24 1.00MB ± 0% 0.98MB ± 0% -2.45% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/OptBuildNorm-24 89.9kB ± 0% 87.8kB ± 0% -2.39% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/ExecBuild-24 134kB ± 0% 131kB ± 0% -2.32% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/OptBuildNoNorm-24 50.5kB ± 0% 49.6kB ± 0% -1.82% (p=0.008 n=5+5) | |
Chain/chain-5-24 233kB ± 0% 229kB ± 0% -1.32% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Prepared/Explore-24 12.5kB ± 0% 12.4kB ± 0% -0.65% (p=0.008 n=5+5) | |
EndToEnd/ored-preds-100/Prepared-24 1.01MB ± 0% 1.01MB ± 0% -0.22% (p=0.029 n=4+4) | |
Phases/tpcc-new-order/Simple/OptBuildNoNorm-24 21.7kB ± 0% 21.7kB ± 0% -0.21% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/Explore-24 26.0kB ± 0% 26.0kB ± 0% -0.20% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Prepared/ExecBuild-24 13.0kB ± 0% 13.0kB ± 0% -0.15% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/OptBuildNoNorm-24 15.9kB ± 0% 15.9kB ± 0% ~ (p=0.151 n=5+5) | |
EndToEnd/kv-read/Simple-24 35.8kB ±12% 39.7kB ±15% ~ (p=0.222 n=5+5) | |
EndToEnd/kv-read/Prepared-24 23.6kB ±16% 26.9kB ±13% ~ (p=0.095 n=5+5) | |
EndToEnd/kv-read-const/Prepared-24 23.1kB ± 9% 25.1kB ± 1% ~ (p=0.063 n=5+4) | |
EndToEnd/tpcc-new-order/Prepared-24 25.8kB ±13% 29.2kB ±15% ~ (p=0.056 n=5+5) | |
EndToEnd/tpcc-delivery/Simple-24 50.1kB ± 7% 57.7kB ±13% ~ (p=0.056 n=5+5) | |
EndToEnd/many-columns-and-indexes-a/Simple-24 54.3kB ±21% 54.7kB ± 0% ~ (p=0.343 n=4+4) | |
EndToEnd/single-col-histogram-range/Prepared-24 30.3kB ±20% 33.8kB ±24% ~ (p=0.310 n=5+5) | |
EndToEnd/batch-insert-many/Simple-24 11.6MB ± 5% 12.0MB ±24% ~ (p=1.000 n=4+5) | |
EndToEnd/ored-preds-100/Simple-24 1.19MB ± 2% 1.18MB ± 0% ~ (p=0.111 n=5+4) | |
EndToEnd/ored-preds-using-params-100/Simple-24 1.94MB ± 0% 1.94MB ± 0% ~ (p=0.151 n=5+5) | |
EndToEnd/ored-preds-using-params-100/Prepared-24 1.77MB ± 1% 1.77MB ± 0% ~ (p=0.190 n=5+4) | |
Phases/batch-insert-many/Simple/Parse-24 2.39MB ± 0% 2.39MB ± 0% +0.00% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/AssignPlaceholdersNorm-24 348kB ± 0% 348kB ± 0% +0.02% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/Explore-24 738kB ± 0% 738kB ± 0% +0.02% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/ExecBuild-24 26.5kB ± 0% 26.5kB ± 0% +0.02% (p=0.032 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/AssignPlaceholdersNoNorm-24 348kB ± 0% 348kB ± 0% +0.02% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Prepared/ExecBuild-24 71.1kB ± 0% 71.1kB ± 0% +0.05% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/Parse-24 160kB ± 0% 160kB ± 0% +0.05% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/ExecBuild-24 768kB ± 0% 768kB ± 0% +0.06% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/Parse-24 140kB ± 0% 140kB ± 0% +0.06% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/OptBuildNorm-24 25.6kB ± 0% 25.6kB ± 0% +0.17% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Prepared/ExecBuild-24 29.7kB ± 0% 29.7kB ± 0% +0.20% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/Parse-24 20.2kB ± 0% 20.3kB ± 0% +0.40% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/Parse-24 19.6kB ± 0% 19.7kB ± 0% +0.41% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/OptBuildNorm-24 20.8kB ± 0% 20.9kB ± 0% +0.43% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/Explore-24 7.83kB ± 0% 7.87kB ± 0% +0.52% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/Explore-24 31.9kB ± 0% 32.1kB ± 0% +0.53% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/ExecBuild-24 32.5kB ± 0% 32.7kB ± 0% +0.70% (p=0.008 n=5+5) | |
Chain/chain-4-24 138kB ± 0% 139kB ± 0% +0.72% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/Explore-24 5.31kB ± 0% 5.35kB ± 0% +0.75% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/Parse-24 10.3kB ± 0% 10.4kB ± 0% +0.93% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/AssignPlaceholdersNoNorm-24 6.35kB ± 0% 6.41kB ± 0% +1.01% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/AssignPlaceholdersNorm-24 6.35kB ± 0% 6.41kB ± 0% +1.01% (p=0.016 n=5+4) | |
Phases/tpcc-delivery/Prepared/AssignPlaceholdersNoNorm-24 6.14kB ± 0% 6.20kB ± 0% +1.04% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Prepared/AssignPlaceholdersNorm-24 6.14kB ± 0% 6.20kB ± 0% +1.04% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/ExecBuild-24 8.91kB ± 0% 9.01kB ± 0% +1.07% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/Parse-24 5.76kB ± 0% 5.84kB ± 0% +1.39% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/Parse-24 5.52kB ± 0% 5.60kB ± 0% +1.45% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/ExecBuild-24 6.06kB ± 0% 6.15kB ± 0% +1.55% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/AssignPlaceholdersNoNorm-24 3.83kB ± 0% 3.90kB ± 0% +1.67% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/AssignPlaceholdersNorm-24 3.83kB ± 0% 3.90kB ± 0% +1.67% (p=0.008 n=5+5) | |
EndToEnd/tpcc-stock-level/Prepared-24 131kB ± 0% 134kB ± 0% +2.14% (p=0.029 n=4+4) | |
Phases/kv-read-const/Simple/Parse-24 3.65kB ± 0% 3.73kB ± 0% +2.19% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Prepared/ExecBuild-24 1.46kB ± 0% 1.49kB ± 0% +2.20% (p=0.008 n=5+5) | |
FKInsert/MultiRowMultiParent/None-24 502kB ± 1% 513kB ± 2% +2.22% (p=0.016 n=5+5) | |
Phases/kv-read-const/Simple/OptBuildNoNorm-24 11.1kB ± 0% 11.3kB ± 0% +2.23% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/OptBuildNoNorm-24 11.0kB ± 0% 11.3kB ± 0% +2.24% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/Parse-24 3.55kB ± 0% 3.63kB ± 0% +2.25% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/ExecBuild-24 64.8kB ± 0% 66.3kB ± 0% +2.29% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/Explore-24 63.4kB ± 0% 64.9kB ± 0% +2.30% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/OptBuildNorm-24 62.0kB ± 0% 63.5kB ± 0% +2.34% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/Explore-24 14.6kB ± 0% 15.0kB ± 0% +2.51% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/Explore-24 14.5kB ± 0% 14.9kB ± 0% +2.53% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/OptBuildNorm-24 12.4kB ± 0% 12.7kB ± 0% +2.72% (p=0.016 n=5+4) | |
Phases/kv-read/Simple/OptBuildNorm-24 12.3kB ± 0% 12.6kB ± 0% +2.74% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/ExecBuild-24 15.2kB ± 0% 15.6kB ± 0% +2.77% (p=0.029 n=4+4) | |
Phases/batch-insert-one/Simple/OptBuildNoNorm-24 52.4kB ± 0% 53.9kB ± 0% +2.78% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/ExecBuild-24 15.1kB ± 0% 15.5kB ± 0% +2.79% (p=0.008 n=5+5) | |
FKInsert/MultiRowSingleParent/None-24 498kB ± 1% 512kB ± 0% +2.93% (p=0.008 n=5+5) | |
EndToEnd/tpcc-stock-level/Simple-24 149kB ± 0% 154kB ± 0% +3.00% (p=0.029 n=4+4) | |
Chain/chain-3-24 73.8kB ± 0% 76.2kB ± 0% +3.24% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Prepared/ExecBuild-24 832B ± 0% 864B ± 0% +3.85% (p=0.008 n=5+5) | |
Phases/kv-read/Prepared/ExecBuild-24 768B ± 0% 800B ± 0% +4.17% (p=0.008 n=5+5) | |
EndToEnd/many-columns-and-indexes-b/Prepared-24 45.9kB ± 0% 47.9kB ± 1% +4.37% (p=0.016 n=4+5) | |
EndToEnd/many-columns-and-indexes-a/Prepared-24 41.4kB ± 1% 43.3kB ± 1% +4.55% (p=0.029 n=4+4) | |
Chain/chain-1-24 9.25kB ± 0% 9.70kB ± 0% +4.84% (p=0.008 n=5+5) | |
FKInsert/MultiRowSingleParent/NoFastPath-24 356kB ± 1% 374kB ± 1% +5.04% (p=0.008 n=5+5) | |
Chain/chain-2-24 33.7kB ± 0% 35.6kB ± 0% +5.85% (p=0.008 n=5+5) | |
FKInsert/MultiRowMultiParent/NoFastPath-24 380kB ± 1% 403kB ± 1% +5.99% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/ExecBuild-24 3.76MB ± 0% 4.01MB ± 0% +6.65% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/OptBuildNorm-24 3.69MB ± 0% 3.94MB ± 0% +6.77% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/Explore-24 3.69MB ± 0% 3.94MB ± 0% +6.77% (p=0.008 n=5+5) | |
EndToEnd/tpcc-delivery/Prepared-24 36.7kB ± 3% 39.4kB ± 3% +7.19% (p=0.008 n=5+5) | |
FKInsert/MultiRowSingleParent/FastPath-24 155kB ± 3% 167kB ± 1% +7.95% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/OptBuildNoNorm-24 3.07MB ± 0% 3.32MB ± 0% +8.14% (p=0.008 n=5+5) | |
EndToEnd/many-columns-and-indexes-b/Simple-24 56.9kB ± 1% 61.7kB ± 0% +8.43% (p=0.016 n=5+4) | |
Phases/kv-read-const/Prepared/ExecBuild-24 584B ± 0% 640B ± 0% +9.59% (p=0.008 n=5+5) | |
EndToEnd/tpcc-new-order/Simple-24 37.0kB ± 1% 41.2kB ± 1% +11.18% (p=0.008 n=5+5) | |
FKInsert/MultiRowMultiParent/FastPath-24 176kB ± 0% 198kB ± 2% +12.15% (p=0.008 n=5+5) | |
EndToEnd/kv-read-const/Simple-24 23.0kB ± 0% 25.8kB ± 0% +12.56% (p=0.029 n=4+4) | |
EndToEnd/single-col-histogram-range/Simple-24 36.8kB ± 1% 41.7kB ± 1% +13.21% (p=0.029 n=4+4) | |
FKInsert/SingleRow/FastPath-24 73.2kB ± 1% 83.5kB ± 1% +14.01% (p=0.008 n=5+5) | |
FKInsert/SingleRow/None-24 97.0kB ± 1% 110.8kB ± 1% +14.26% (p=0.008 n=5+5) | |
FKInsert/SingleRow/NoFastPath-24 144kB ± 1% 167kB ± 3% +15.30% (p=0.016 n=4+5) | |
Phases/many-columns-and-indexes-a/Simple/Parse-24 2.48kB ± 0% 3.33kB ± 0% +34.19% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/Parse-24 2.40kB ± 0% 3.25kB ± 0% +35.33% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/Parse-24 3.71kB ± 0% 5.33kB ± 0% +43.53% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/ExecBuild-24 26.7kB ± 0% 48.7kB ± 0% +82.15% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/Explore-24 25.7kB ± 0% 47.5kB ± 0% +85.35% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/OptBuildNorm-24 24.2kB ± 0% 46.1kB ± 0% +90.67% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/OptBuildNoNorm-24 20.4kB ± 0% 42.2kB ± 0% +106.99% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/ExecBuild-24 18.6kB ± 0% 40.0kB ± 0% +115.37% (p=0.016 n=4+5) | |
Phases/many-columns-and-indexes-a/Simple/Explore-24 17.8kB ± 0% 39.2kB ± 0% +119.77% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/OptBuildNorm-24 16.4kB ± 0% 37.8kB ± 0% +130.76% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/OptBuildNoNorm-24 14.2kB ± 0% 35.6kB ± 0% +149.72% (p=0.016 n=4+5) | |
name old allocs/op new allocs/op delta | |
Phases/single-col-histogram-range/Prepared/AssignPlaceholdersNoNorm-24 867 ± 0% 238 ± 0% -72.55% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/AssignPlaceholdersNorm-24 867 ± 0% 238 ± 0% -72.55% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/Explore-24 876 ± 0% 247 ± 0% -71.80% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/OptBuildNorm-24 1.76k ± 0% 0.50k ± 0% -71.40% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Prepared/ExecBuild-24 883 ± 0% 256 ± 0% -71.01% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/Explore-24 1.77k ± 0% 0.51k ± 0% -70.99% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/ExecBuild-24 1.78k ± 0% 0.52k ± 0% -70.60% (p=0.008 n=5+5) | |
Phases/single-col-histogram-range/Simple/OptBuildNoNorm-24 914 ± 0% 284 ± 0% -68.93% (p=0.008 n=5+5) | |
SlowQueries/slow-query-2-24 1.25M ± 0% 0.40M ± 0% -67.81% (p=0.008 n=5+5) | |
SlowQueries/slow-query-1-24 127k ± 0% 76k ± 0% -40.21% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-one/Prepared-24 36.1k ± 0% 26.1k ± 0% -27.81% (p=0.029 n=4+4) | |
EndToEnd/batch-insert-one/Simple-24 35.8k ± 1% 26.0k ± 1% -27.54% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-many/Prepared-24 57.8k ± 8% 47.2k ± 3% -18.43% (p=0.008 n=5+5) | |
Chain/chain-19-24 34.5k ± 0% 28.8k ± 0% -16.37% (p=0.008 n=5+5) | |
Chain/chain-18-24 31.8k ± 0% 26.6k ± 0% -16.35% (p=0.008 n=5+5) | |
Chain/chain-17-24 29.2k ± 0% 24.4k ± 0% -16.32% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/OptBuildNoNorm-24 3.68k ± 0% 3.08k ± 0% -16.26% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/OptBuildNoNorm-24 3.68k ± 0% 3.08k ± 0% -16.26% (p=0.008 n=5+5) | |
Chain/chain-16-24 26.6k ± 0% 22.2k ± 0% -16.26% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/OptBuildNorm-24 3.68k ± 0% 3.08k ± 0% -16.23% (p=0.000 n=5+4) | |
Phases/ored-preds-using-params-100/Simple/OptBuildNorm-24 3.68k ± 0% 3.08k ± 0% -16.23% (p=0.000 n=5+4) | |
Chain/chain-15-24 24.0k ± 0% 20.1k ± 0% -16.19% (p=0.008 n=5+5) | |
Chain/chain-14-24 21.4k ± 0% 17.9k ± 0% -16.07% (p=0.008 n=5+5) | |
Chain/chain-13-24 18.8k ± 0% 15.8k ± 0% -15.95% (p=0.008 n=5+5) | |
EndToEnd/batch-insert-many/Simple-24 69.0k ± 0% 58.1k ± 0% -15.73% (p=0.029 n=4+4) | |
Chain/chain-12-24 16.2k ± 0% 13.7k ± 0% -15.73% (p=0.008 n=5+5) | |
Chain/chain-11-24 13.7k ± 0% 11.6k ± 0% -15.40% (p=0.008 n=5+5) | |
Chain/chain-10-24 11.2k ± 0% 9.5k ± 0% -14.89% (p=0.016 n=5+4) | |
Phases/tpcc-stock-level/Simple/OptBuildNoNorm-24 274 ± 0% 234 ± 0% -14.60% (p=0.008 n=5+5) | |
Chain/chain-9-24 8.68k ± 0% 7.48k ± 0% -13.80% (p=0.000 n=5+4) | |
Chain/chain-8-24 6.19k ± 0% 5.43k ± 0% -12.29% (p=0.029 n=4+4) | |
Phases/ored-preds-using-params-100/Simple/Explore-24 5.12k ± 0% 4.53k ± 0% -11.66% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/ExecBuild-24 5.54k ± 0% 4.94k ± 0% -10.76% (p=0.029 n=4+4) | |
Phases/ored-preds-100/Simple/ExecBuild-24 5.54k ± 0% 4.94k ± 0% -10.76% (p=0.000 n=5+4) | |
Chain/chain-6-24 2.83k ± 0% 2.62k ± 0% -7.43% (p=0.000 n=5+4) | |
Phases/tpcc-new-order/Simple/OptBuildNoNorm-24 116 ± 0% 108 ± 0% -6.90% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/Explore-24 350 ± 0% 327 ± 0% -6.57% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/OptBuildNoNorm-24 107 ± 0% 100 ± 0% -6.54% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/Explore-24 135 ± 0% 128 ± 0% -5.19% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/AssignPlaceholdersNorm-24 116 ± 0% 110 ± 0% -5.17% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/AssignPlaceholdersNoNorm-24 117 ± 0% 111 ± 0% -5.13% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/OptBuildNorm-24 138 ± 0% 131 ± 0% -5.07% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Prepared/ExecBuild-24 371 ± 0% 353 ± 0% -4.85% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/OptBuildNoNorm-24 105 ± 0% 100 ± 0% -4.76% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/Explore-24 721 ± 0% 687 ± 0% -4.72% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/OptBuildNorm-24 129 ± 0% 123 ± 0% -4.65% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/OptBuildNoNorm-24 19.8k ± 0% 18.9k ± 0% -4.59% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/ExecBuild-24 742 ± 0% 713 ± 0% -3.91% (p=0.008 n=5+5) | |
Chain/chain-5-24 1.77k ± 0% 1.70k ± 0% -3.79% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/Explore-24 28.0 ± 0% 27.0 ± 0% -3.57% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/Explore-24 172 ± 0% 166 ± 0% -3.49% (p=0.008 n=5+5) | |
Phases/tpcc-stock-level/Simple/OptBuildNorm-24 488 ± 0% 471 ± 0% -3.48% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/Parse-24 29.0 ± 0% 28.0 ± 0% -3.45% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/Parse-24 29.0 ± 0% 28.0 ± 0% -3.45% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Simple/ExecBuild-24 148 ± 0% 143 ± 0% -3.38% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/OptBuildNorm-24 125 ± 0% 121 ± 0% -3.20% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/Explore-24 161 ± 0% 156 ± 0% -3.11% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/OptBuildNorm-24 29.4k ± 0% 28.5k ± 0% -3.09% (p=0.016 n=5+4) | |
Phases/batch-insert-many/Simple/Explore-24 29.4k ± 0% 28.5k ± 0% -3.09% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/ExecBuild-24 29.4k ± 0% 28.5k ± 0% -3.08% (p=0.000 n=5+4) | |
Phases/tpcc-delivery/Simple/Parse-24 35.0 ± 0% 34.0 ± 0% -2.86% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/Parse-24 39.0 ± 0% 38.0 ± 0% -2.56% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/OptBuildNoNorm-24 264 ± 0% 258 ± 0% -2.27% (p=0.008 n=5+5) | |
Phases/tpcc-new-order/Simple/ExecBuild-24 178 ± 0% 174 ± 0% -2.25% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-b/Prepared/Explore-24 46.0 ± 0% 45.0 ± 0% -2.17% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/OptBuildNorm-24 326 ± 0% 320 ± 0% -1.84% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/Explore-24 330 ± 0% 324 ± 0% -1.82% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Simple/ExecBuild-24 167 ± 0% 164 ± 0% -1.80% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/ExecBuild-24 339 ± 0% 333 ± 0% -1.77% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/OptBuildNoNorm-24 61.0 ± 0% 60.0 ± 0% -1.64% (p=0.008 n=5+5) | |
Phases/tpcc-delivery/Prepared/Explore-24 71.0 ± 0% 70.0 ± 0% -1.41% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/Explore-24 74.0 ± 0% 73.0 ± 0% -1.35% (p=0.008 n=5+5) | |
Phases/batch-insert-one/Simple/Parse-24 105 ± 0% 104 ± 0% -0.95% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/Parse-24 118 ± 0% 117 ± 0% -0.85% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Simple/Parse-24 823 ± 0% 822 ± 0% -0.12% (p=0.008 n=5+5) | |
Phases/ored-preds-using-params-100/Simple/Parse-24 823 ± 0% 822 ± 0% -0.12% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/Explore-24 743k ± 0% 743k ± 0% -0.08% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/ExecBuild-24 743k ± 0% 743k ± 0% -0.07% (p=0.008 n=5+5) | |
Phases/batch-insert-many/Simple/Parse-24 11.8k ± 0% 11.8k ± 0% -0.02% (p=0.008 n=5+5) | |
Phases/kv-read/Prepared/ExecBuild-24 9.00 ± 0% 9.00 ± 0% ~ (all equal) | |
Phases/tpcc-new-order/Prepared/ExecBuild-24 9.00 ± 0% 9.00 ± 0% ~ (all equal) | |
Phases/tpcc-delivery/Prepared/AssignPlaceholdersNoNorm-24 34.0 ± 0% 34.0 ± 0% ~ (all equal) | |
Phases/tpcc-delivery/Prepared/AssignPlaceholdersNorm-24 34.0 ± 0% 34.0 ± 0% ~ (all equal) | |
Phases/tpcc-stock-level/Simple/Parse-24 59.0 ± 0% 59.0 ± 0% ~ (all equal) | |
Phases/many-columns-and-indexes-a/Simple/Parse-24 21.0 ± 0% 21.0 ± 0% ~ (all equal) | |
Phases/many-columns-and-indexes-a/Simple/OptBuildNorm-24 68.0 ± 0% 68.0 ± 0% ~ (all equal) | |
Phases/many-columns-and-indexes-a/Prepared/AssignPlaceholdersNoNorm-24 22.0 ± 0% 22.0 ± 0% ~ (all equal) | |
Phases/many-columns-and-indexes-a/Prepared/AssignPlaceholdersNorm-24 22.0 ± 0% 22.0 ± 0% ~ (all equal) | |
Phases/many-columns-and-indexes-b/Simple/Parse-24 30.0 ± 0% 30.0 ± 0% ~ (all equal) | |
Phases/many-columns-and-indexes-b/Prepared/AssignPlaceholdersNoNorm-24 40.0 ± 0% 40.0 ± 0% ~ (all equal) | |
Phases/many-columns-and-indexes-b/Prepared/AssignPlaceholdersNorm-24 40.0 ± 0% 40.0 ± 0% ~ (all equal) | |
Phases/single-col-histogram-range/Simple/Parse-24 20.0 ± 0% 20.0 ± 0% ~ (all equal) | |
Phases/batch-insert-one/Prepared/ExecBuild-24 10.0 ± 0% 10.0 ± 0% ~ (all equal) | |
Phases/batch-insert-many/Prepared/ExecBuild-24 8.00 ± 0% 8.00 ± 0% ~ (all equal) | |
Phases/ored-preds-100/Simple/Explore-24 5.12k ± 0% 4.53k ± 0% ~ (p=0.079 n=4+5) | |
Phases/ored-preds-using-params-100/Prepared/AssignPlaceholdersNoNorm-24 1.44k ± 0% 1.44k ± 0% ~ (all equal) | |
Phases/ored-preds-using-params-100/Prepared/AssignPlaceholdersNorm-24 1.44k ± 0% 1.44k ± 0% ~ (all equal) | |
Phases/ored-preds-using-params-100/Prepared/Explore-24 2.88k ± 0% 2.88k ± 0% ~ (all equal) | |
Chain/chain-7-24 4.27k ± 0% 3.83k ± 0% ~ (p=0.079 n=4+5) | |
EndToEnd/many-columns-and-indexes-a/Simple-24 462 ±17% 535 ± 0% ~ (p=0.229 n=4+4) | |
EndToEnd/many-columns-and-indexes-c/Simple-24 758k ± 4% 750k ± 0% ~ (p=0.686 n=4+4) | |
EndToEnd/many-columns-and-indexes-c/Prepared-24 749k ± 0% 749k ± 0% ~ (p=0.171 n=4+4) | |
Phases/many-columns-and-indexes-c/Simple/Explore-24 748k ± 0% 748k ± 0% +0.01% (p=0.032 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/ExecBuild-24 749k ± 0% 749k ± 0% +0.01% (p=0.032 n=5+5) | |
Phases/ored-preds-using-params-100/Prepared/ExecBuild-24 3.29k ± 0% 3.30k ± 0% +0.06% (p=0.016 n=5+4) | |
SlowQueries/slow-query-3-24 389k ± 0% 390k ± 0% +0.34% (p=0.008 n=5+5) | |
Phases/ored-preds-100/Prepared/ExecBuild-24 413 ± 0% 415 ± 0% +0.48% (p=0.008 n=5+5) | |
EndToEnd/ored-preds-using-params-100/Prepared-24 7.33k ± 0% 7.39k ± 0% +0.76% (p=0.029 n=4+4) | |
Chain/chain-4-24 1.03k ± 0% 1.04k ± 0% +1.07% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Simple/ExecBuild-24 83.0 ± 0% 84.0 ± 0% +1.20% (p=0.008 n=5+5) | |
EndToEnd/ored-preds-using-params-100/Simple-24 8.25k ± 0% 8.35k ± 0% +1.22% (p=0.008 n=5+5) | |
EndToEnd/ored-preds-100/Simple-24 4.95k ± 1% 5.01k ± 1% +1.25% (p=0.029 n=4+4) | |
Phases/tpcc-delivery/Prepared/ExecBuild-24 77.0 ± 0% 78.0 ± 0% +1.30% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/OptBuildNoNorm-24 73.0 ± 0% 74.0 ± 0% +1.37% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/OptBuildNoNorm-24 73.0 ± 0% 74.0 ± 0% +1.37% (p=0.008 n=5+5) | |
EndToEnd/ored-preds-100/Prepared-24 4.11k ± 0% 4.17k ± 0% +1.43% (p=0.029 n=4+4) | |
Phases/many-columns-and-indexes-b/Prepared/ExecBuild-24 59.0 ± 0% 60.0 ± 0% +1.69% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/Explore-24 85.0 ± 0% 87.0 ± 0% +2.35% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/Explore-24 85.0 ± 0% 87.0 ± 0% +2.35% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/OptBuildNorm-24 76.0 ± 0% 78.0 ± 0% +2.63% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/OptBuildNorm-24 76.0 ± 0% 78.0 ± 0% +2.63% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-a/Prepared/ExecBuild-24 37.0 ± 0% 38.0 ± 0% +2.70% (p=0.008 n=5+5) | |
Chain/chain-1-24 47.0 ± 0% 49.0 ± 0% +4.26% (p=0.008 n=5+5) | |
Phases/kv-read/Simple/ExecBuild-24 90.0 ± 0% 94.0 ± 0% +4.44% (p=0.008 n=5+5) | |
Phases/kv-read-const/Simple/ExecBuild-24 90.0 ± 0% 94.0 ± 0% +4.44% (p=0.008 n=5+5) | |
Chain/chain-3-24 537 ± 0% 576 ± 0% +7.26% (p=0.008 n=5+5) | |
EndToEnd/tpcc-stock-level/Prepared-24 919 ± 0% 991 ± 0% +7.83% (p=0.029 n=4+4) | |
FKInsert/MultiRowSingleParent/None-24 2.13k ± 1% 2.35k ± 0% +10.51% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/AssignPlaceholdersNoNorm-24 56.4k ± 0% 62.5k ± 0% +10.86% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Prepared/AssignPlaceholdersNorm-24 56.4k ± 0% 62.5k ± 0% +10.86% (p=0.008 n=5+5) | |
Phases/many-columns-and-indexes-c/Simple/OptBuildNorm-24 61.6k ± 0% 68.4k ± 0% +10.88% (p=0.029 n=4+4) | |
Phases/many-columns-and-indexes-c/Simple/OptBuildNoNorm-24 57.1k ± 0% 63.4k ± 0% +11.19% (p=0.008 n=5+5) | |
FKInsert/MultiRowMultiParent/None-24 2.08k ± 1% 2.33k ± 4% +12.21% (p=0.008 n=5+5) | |
FKInsert/MultiRowSingleParent/NoFastPath-24 2.15k ± 1% 2.42k ± 0% +12.77% (p=0.008 n=5+5) | |
EndToEnd/many-columns-and-indexes-b/Prepared-24 390 ± 0% 445 ± 0% +13.91% (p=0.016 n=4+5) | |
EndToEnd/tpcc-stock-level/Simple-24 1.05k ± 0% 1.20k ± 0% +14.08% (p=0.029 n=4+4) | |
FKInsert/MultiRowMultiParent/NoFastPath-24 2.27k ± 1% 2.60k ± 1% +14.69% (p=0.008 n=5+5) | |
Chain/chain-2-24 219 ± 0% 252 ± 0% +15.07% (p=0.008 n=5+5) | |
EndToEnd/many-columns-and-indexes-a/Prepared-24 346 ± 0% 400 ± 0% +15.58% (p=0.029 n=4+4) | |
FKInsert/MultiRowSingleParent/FastPath-24 1.16k ± 5% 1.35k ± 2% +16.30% (p=0.008 n=5+5) | |
FKInsert/SingleRow/None-24 775 ± 1% 902 ± 0% +16.31% (p=0.008 n=5+5) | |
EndToEnd/tpcc-delivery/Prepared-24 314 ± 0% 366 ± 0% +16.77% (p=0.008 n=5+5) | |
FKInsert/SingleRow/FastPath-24 607 ± 1% 710 ± 0% +17.00% (p=0.008 n=5+5) | |
FKInsert/SingleRow/NoFastPath-24 1.13k ± 1% 1.34k ± 5% +18.49% (p=0.016 n=4+5) | |
EndToEnd/many-columns-and-indexes-b/Simple-24 490 ± 0% 587 ± 0% +19.84% (p=0.016 n=5+4) | |
EndToEnd/kv-read-const/Prepared-24 222 ± 9% 266 ± 0% +19.94% (p=0.016 n=5+4) | |
EndToEnd/tpcc-new-order/Prepared-24 252 ± 0% 306 ± 1% +21.77% (p=0.029 n=4+4) | |
EndToEnd/single-col-histogram-range/Prepared-24 243 ± 0% 298 ± 1% +22.30% (p=0.029 n=4+4) | |
FKInsert/MultiRowMultiParent/FastPath-24 1.32k ± 1% 1.63k ± 5% +23.03% (p=0.008 n=5+5) | |
EndToEnd/kv-read-const/Simple-24 232 ± 0% 286 ± 0% +23.10% (p=0.016 n=4+5) | |
EndToEnd/kv-read/Prepared-24 233 ±20% 292 ±11% +25.45% (p=0.032 n=5+5) | |
EndToEnd/kv-read/Simple-24 349 ±17% 440 ±15% +25.87% (p=0.008 n=5+5) | |
EndToEnd/tpcc-new-order/Simple-24 360 ± 0% 456 ± 0% +26.75% (p=0.008 n=5+5) | |
EndToEnd/single-col-histogram-range/Simple-24 334 ± 0% 432 ± 1% +29.42% (p=0.029 n=4+4) | |
Phases/kv-read-const/Prepared/ExecBuild-24 6.00 ± 0% 8.00 ± 0% +33.33% (p=0.008 n=5+5) | |
EndToEnd/tpcc-delivery/Simple-24 418 ± 0% 568 ±18% +35.93% (p=0.016 n=4+5) | |
name old rows/op new rows/op delta | |
EndToEnd/tpcc-stock-level/Prepared-24 1.00 ± 0% 1.00 ± 0% ~ (all equal) | |
EndToEnd/batch-insert-one/Prepared-24 1.00 ± 0% 1.00 ± 0% ~ (all equal) | |
EndToEnd/batch-insert-many/Prepared-24 181 ± 0% 181 ± 0% ~ (all equal) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment