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

   
   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 e738c419d4902982a79c0660590b9b9d7d16580f, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5544    5229    5146    5146
   q2   390     165     159     159
   q3   1466    1239    1135    1135
   q4   1114    941     812     812
   q5   3169    3147    3158    3147
   q6   232     131     131     131
   q7   1026    531     500     500
   q8   2178    2306    2284    2284
   q9   6769    6704    6672    6672
   q10  3206    3136    3114    3114
   q11  350     222     211     211
   q12  388     242     233     233
   q13  4389    3644    3662    3644
   q14  254     224     209     209
   q15  605     541     538     538
   q16  458     412     425     412
   q17  1055    607     558     558
   q18  7090    6778    6941    6778
   q19  1650    1540    1473    1473
   q20  580     337     322     322
   q21  2920    2487    2526    2487
   q22  390     314     312     312
   Total cold run time: 45223 ms
   Total hot run time: 40277 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5092    5070    5133    5070
   q2   333     247     279     247
   q3   3359    3353    3280    3280
   q4   2136    2024    2002    2002
   q5   5930    5895    5927    5895
   q6   227     125     128     125
   q7   2412    1911    1876    1876
   q8   3569    3664    3667    3664
   q9   9042    8974    8997    8974
   q10  3890    3912    3918    3912
   q11  595     469     496     469
   q12  786     634     646     634
   q13  3874    3200    3186    3186
   q14  303     282     259     259
   q15  613     546     543     543
   q16  551     524     539     524
   q17  2024    1799    1795    1795
   q18  8720    8433    8434    8433
   q19  1751    1710    1690    1690
   q20  2350    1972    1987    1972
   q21  5732    5311    5358    5311
   q22  564     510     492     492
   Total cold run time: 63853 ms
   Total hot run time: 60353 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