Closed PHILO-HE closed 3 weeks ago
===== Performance report for TPCDS SF2000 with Velox backend, for reference only ====
query | log/native_master_11_04_2024_time.csv | log/native_master_11_03_2024_95170df224_time.csv | difference | percentage |
q1 | 13.94 | 14.47 | 0.530 | 103.80% |
q2 | 15.27 | 15.28 | 0.002 | 100.01% |
q3 | 5.17 | 5.37 | 0.206 | 104.00% |
q4 | 72.22 | 71.09 | -1.130 | 98.43% |
q5 | 9.58 | 10.10 | 0.513 | 105.36% |
q6 | 3.89 | 2.36 | -1.527 | 60.70% |
q7 | 6.30 | 6.55 | 0.252 | 104.00% |
q8 | 3.37 | 5.52 | 2.151 | 163.82% |
q9 | 26.51 | 26.24 | -0.262 | 99.01% |
q10 | 9.07 | 8.84 | -0.224 | 97.53% |
q11 | 37.83 | 37.06 | -0.770 | 97.96% |
q12 | 1.33 | 1.53 | 0.201 | 115.15% |
q13 | 6.28 | 6.27 | -0.012 | 99.81% |
q14a | 47.78 | 48.43 | 0.641 | 101.34% |
q14b | 42.85 | 42.80 | -0.053 | 99.88% |
q15 | 2.60 | 2.49 | -0.109 | 95.80% |
q16 | 49.08 | 50.97 | 1.889 | 103.85% |
q17 | 5.65 | 5.25 | -0.406 | 92.82% |
q18 | 6.91 | 7.16 | 0.253 | 103.66% |
q19 | 2.21 | 2.38 | 0.167 | 107.58% |
q20 | 1.51 | 1.54 | 0.033 | 102.20% |
q21 | 1.21 | 1.18 | -0.027 | 97.73% |
q22 | 8.15 | 8.25 | 0.097 | 101.19% |
q23a | 108.70 | 107.12 | -1.581 | 98.55% |
q23b | 129.45 | 129.95 | 0.496 | 100.38% |
q24a | 107.07 | 111.67 | 4.601 | 104.30% |
q24b | 101.02 | 110.38 | 9.357 | 109.26% |
q25 | 3.98 | 4.11 | 0.124 | 103.11% |
q26 | 3.63 | 4.21 | 0.576 | 115.86% |
q27 | 4.13 | 5.18 | 1.045 | 125.27% |
q28 | 33.95 | 35.87 | 1.916 | 105.64% |
q29 | 11.34 | 9.55 | -1.781 | 84.29% |
q30 | 4.64 | 5.03 | 0.389 | 108.39% |
q31 | 7.23 | 6.84 | -0.388 | 94.64% |
q32 | 1.29 | 1.32 | 0.030 | 102.33% |
q33 | 4.64 | 4.24 | -0.405 | 91.28% |
q34 | 5.11 | 4.22 | -0.889 | 82.59% |
q35 | 9.59 | 7.63 | -1.965 | 79.51% |
q36 | 6.04 | 5.63 | -0.401 | 93.35% |
q37 | 4.98 | 5.64 | 0.664 | 113.34% |
q38 | 15.35 | 13.89 | -1.466 | 90.45% |
q39a | 3.60 | 3.57 | -0.034 | 99.06% |
q39b | 3.09 | 3.43 | 0.336 | 110.86% |
q40 | 4.10 | 3.92 | -0.180 | 95.60% |
q41 | 0.63 | 0.65 | 0.018 | 102.85% |
q42 | 0.95 | 0.99 | 0.043 | 104.57% |
q43 | 4.71 | 4.59 | -0.125 | 97.34% |
q44 | 10.66 | 8.61 | -2.050 | 80.78% |
q45 | 3.38 | 3.23 | -0.150 | 95.57% |
q46 | 3.89 | 3.86 | -0.033 | 99.16% |
q47 | 17.90 | 17.57 | -0.331 | 98.15% |
q48 | 5.14 | 6.17 | 1.036 | 120.17% |
q49 | 6.89 | 6.77 | -0.124 | 98.21% |
q50 | 21.41 | 21.92 | 0.502 | 102.35% |
q51 | 9.36 | 10.00 | 0.638 | 106.81% |
q52 | 1.09 | 1.05 | -0.047 | 95.68% |
q53 | 2.28 | 2.36 | 0.087 | 103.82% |
q54 | 3.79 | 3.86 | 0.070 | 101.84% |
q55 | 0.99 | 1.18 | 0.190 | 119.15% |
q56 | 4.10 | 4.35 | 0.248 | 106.04% |
q57 | 10.39 | 11.46 | 1.071 | 110.31% |
q58 | 2.49 | 2.67 | 0.177 | 107.13% |
q59 | 10.76 | 12.00 | 1.239 | 111.52% |
q60 | 4.05 | 4.26 | 0.213 | 105.26% |
q61 | 4.20 | 4.13 | -0.075 | 98.21% |
q62 | 4.96 | 4.19 | -0.772 | 84.46% |
q63 | 2.36 | 2.41 | 0.052 | 102.19% |
q64 | 59.74 | 60.58 | 0.840 | 101.41% |
q65 | 17.51 | 21.29 | 3.782 | 121.60% |
q66 | 4.83 | 4.53 | -0.302 | 93.74% |
q67 | 430.70 | 460.27 | 29.563 | 106.86% |
q68 | 3.82 | 3.91 | 0.096 | 102.52% |
q69 | 5.62 | 5.97 | 0.351 | 106.24% |
q70 | 10.72 | 12.07 | 1.351 | 112.60% |
q71 | 2.30 | 2.50 | 0.199 | 108.64% |
q72 | 217.08 | 215.83 | -1.256 | 99.42% |
q73 | 2.45 | 2.35 | -0.092 | 96.25% |
q74 | 23.02 | 22.95 | -0.075 | 99.67% |
q75 | 25.27 | 28.28 | 3.006 | 111.90% |
q76 | 11.47 | 13.29 | 1.824 | 115.90% |
q77 | 1.95 | 2.15 | 0.206 | 110.57% |
q78 | 53.21 | 49.92 | -3.291 | 93.82% |
q79 | 3.93 | 3.92 | -0.006 | 99.85% |
q80 | 12.10 | 11.65 | -0.450 | 96.28% |
q81 | 4.81 | 4.66 | -0.148 | 96.92% |
q82 | 7.87 | 7.01 | -0.860 | 89.07% |
q83 | 1.56 | 1.65 | 0.090 | 105.78% |
q84 | 2.98 | 2.70 | -0.277 | 90.71% |
q85 | 6.99 | 9.04 | 2.048 | 129.28% |
q86 | 5.46 | 4.26 | -1.195 | 78.10% |
q87 | 13.67 | 15.81 | 2.142 | 115.67% |
q88 | 18.55 | 18.38 | -0.172 | 99.07% |
q89 | 3.09 | 3.51 | 0.418 | 113.53% |
q90 | 3.00 | 3.20 | 0.204 | 106.82% |
q91 | 2.22 | 2.31 | 0.091 | 104.09% |
q92 | 1.24 | 1.20 | -0.044 | 96.47% |
q93 | 40.24 | 41.87 | 1.628 | 104.05% |
q94 | 27.40 | 26.88 | -0.512 | 98.13% |
q9 | 89.73 | 87.54 | -2.188 | 97.56% |
q5 | 2.64 | 2.56 | -0.072 | 97.27% |
q96 | 17.79 | 18.19 | 0.403 | 102.27% |
q97 | 2.06 | 1.93 | -0.130 | 93.71% |
q98 | 11.36 | 9.84 | -1.515 | 86.66% |
q99 | 11.36 | 9.84 | -1.515 | 86.66% |
total | 2236.42 | 2286.81 | 50.394 | 102.25% |
What changes were proposed in this pull request?
Fix #7797.
How was this patch tested?
Existing scheduled job.