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

   
   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 5d484ba30dfb175b70295e7f850f23ca2caf3a07, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5526    5129    5168    5129
   q2   394     161     158     158
   q3   1446    1120    1209    1120
   q4   1089    766     792     766
   q5   3110    3108    3082    3082
   q6   220     137     136     136
   q7   963     555     518     518
   q8   2158    2284    2225    2225
   q9   6701    6654    6649    6649
   q10  3139    3140    3103    3103
   q11  347     225     232     225
   q12  382     235     233     233
   q13  4387    3625    3624    3624
   q14  261     221     223     221
   q15  591     556     545     545
   q16  457     427     414     414
   q17  1052    557     480     480
   q18  7046    6742    6782    6742
   q19  1640    1537    1479    1479
   q20  583     375     345     345
   q21  2917    2459    2507    2459
   q22  395     339     332     332
   Total cold run time: 44804 ms
   Total hot run time: 39985 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5180    5100    5075    5075
   q2   347     260     251     251
   q3   3363    3325    3336    3325
   q4   2151    2047    2020    2020
   q5   5922    5891    5923    5891
   q6   222     126     125     125
   q7   2386    1886    1894    1886
   q8   3549    3649    3672    3649
   q9   9026    8993    8940    8940
   q10  3851    3927    3887    3887
   q11  582     462     477     462
   q12  822     654     641     641
   q13  3863    3191    3190    3190
   q14  308     277     291     277
   q15  609     561     551     551
   q16  600     524     507     507
   q17  2015    1845    1818    1818
   q18  8707    8378    8408    8378
   q19  1733    1679    1636    1636
   q20  2320    1992    1962    1962
   q21  5737    5222    5412    5222
   q22  578     471     502     471
   Total cold run time: 63871 ms
   Total hot run time: 60164 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