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

   
   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 bcba028b03aabc64a5a2612183dc2153a43aa609, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5452    5113    5128    5113
   q2   398     167     161     161
   q3   1464    1127    1137    1127
   q4   1095    846     832     832
   q5   3144    3144    3069    3069
   q6   235     134     130     130
   q7   972     549     513     513
   q8   2158    2227    2219    2219
   q9   6740    6696    6673    6673
   q10  3172    3148    3155    3148
   q11  334     218     220     218
   q12  390     233     238     233
   q13  4434    3626    3664    3626
   q14  248     217     214     214
   q15  600     547     548     547
   q16  457     412     413     412
   q17  1050    605     516     516
   q18  7045    6781    6724    6724
   q19  1643    1564    1503    1503
   q20  587     344     365     344
   q21  2880    2482    2520    2482
   q22  389     330     325     325
   Total cold run time: 44887 ms
   Total hot run time: 40129 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5111    5081    5073    5073
   q2   333     246     248     246
   q3   3357    3318    3303    3303
   q4   2145    2059    2031    2031
   q5   5955    5904    5883    5883
   q6   227     123     125     123
   q7   2376    1907    1917    1907
   q8   3556    3639    3669    3639
   q9   9061    8964    8998    8964
   q10  3880    3912    3913    3912
   q11  599     478     455     455
   q12  804     664     646     646
   q13  3851    3198    3188    3188
   q14  297     278     280     278
   q15  607     528     533     528
   q16  544     479     518     479
   q17  2025    1787    1845    1787
   q18  8798    8361    8415    8361
   q19  1750    1706    1727    1706
   q20  2291    2016    1968    1968
   q21  5704    5328    5363    5328
   q22  579     474     467     467
   Total cold run time: 63850 ms
   Total hot run time: 60272 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