doris-robot commented on PR #29537:
URL: https://github.com/apache/doris/pull/29537#issuecomment-1878901178

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with 
scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 195d434ae08b6857e698e31ae9a597ae3c7364c4, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5522    5110    5097    5097
   q2   382     161     146     146
   q3   1453    1232    1173    1173
   q4   1090    828     848     828
   q5   3130    3132    3117    3117
   q6   222     132     137     132
   q7   958     567     536     536
   q8   2145    2277    2296    2277
   q9   6752    6654    6669    6654
   q10  3152    3127    3081    3081
   q11  343     216     234     216
   q12  377     239     231     231
   q13  4389    3631    3632    3631
   q14  248     221     211     211
   q15  578     534     535     534
   q16  450     422     418     418
   q17  1054    550     530     530
   q18  7083    6801    6726    6726
   q19  1649    1508    1398    1398
   q20  606     341     321     321
   q21  2878    2489    2474    2474
   q22  403     319     335     319
   Total cold run time: 44864 ms
   Total hot run time: 40050 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5079    5077    5068    5068
   q2   329     235     231     231
   q3   3361    3362    3311    3311
   q4   2156    2013    2013    2013
   q5   6010    5892    5957    5892
   q6   222     127     130     127
   q7   2376    1939    1921    1921
   q8   3579    3648    3673    3648
   q9   9072    9014    8983    8983
   q10  3861    3892    3895    3892
   q11  597     496     481     481
   q12  799     633     641     633
   q13  3867    3199    3227    3199
   q14  301     268     284     268
   q15  590     516     523     516
   q16  544     512     475     475
   q17  2035    1837    1808    1808
   q18  8732    8370    8301    8301
   q19  1740    1715    1685    1685
   q20  2273    1982    1969    1969
   q21  5762    5293    5306    5293
   q22  548     513     476     476
   Total cold run time: 63833 ms
   Total hot run time: 60190 ms
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to