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

   
   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 c9662e0318441d3130ab29ea3631bead2d5b7f81, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5512    5129    5145    5129
   q2   392     161     165     161
   q3   1456    1182    1186    1182
   q4   1094    778     780     778
   q5   3110    3120    3091    3091
   q6   235     139     129     129
   q7   993     536     532     532
   q8   2159    2179    2215    2179
   q9   6708    6670    6651    6651
   q10  3201    3143    3114    3114
   q11  350     232     224     224
   q12  385     234     241     234
   q13  4362    3649    3665    3649
   q14  252     222     218     218
   q15  609     551     540     540
   q16  455     410     412     410
   q17  1036    525     542     525
   q18  7103    6679    6763    6679
   q19  1639    1510    1596    1510
   q20  554     362     341     341
   q21  2872    2447    2529    2447
   q22  403     315     334     315
   Total cold run time: 44880 ms
   Total hot run time: 40038 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5124    5068    5052    5052
   q2   333     247     243     243
   q3   3368    3335    3318    3318
   q4   2166    2021    2058    2021
   q5   5963    5935    5927    5927
   q6   252     130     125     125
   q7   2364    1945    1962    1945
   q8   3572    3643    3690    3643
   q9   9019    8977    8983    8977
   q10  3878    3912    3917    3912
   q11  583     477     491     477
   q12  793     626     664     626
   q13  3905    3221    3194    3194
   q14  313     275     270     270
   q15  593     539     540     539
   q16  563     505     521     505
   q17  2015    1831    1847    1831
   q18  8761    8385    8432    8385
   q19  1763    1712    1711    1711
   q20  2298    1996    1965    1965
   q21  5741    5339    5240    5240
   q22  541     571     497     497
   Total cold run time: 63908 ms
   Total hot run time: 60403 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to