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

   
   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 6b86465c599449e032921f3e3a8195c74cdb944d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5439    5128    5128    5128
   q2   385     168     167     167
   q3   1490    1186    1159    1159
   q4   1087    846     768     768
   q5   3166    3175    3146    3146
   q6   216     136     136     136
   q7   972     558     526     526
   q8   2146    2200    2290    2200
   q9   6733    6665    6642    6642
   q10  3165    3060    3055    3055
   q11  359     215     202     202
   q12  390     230     229     229
   q13  4418    3655    3670    3655
   q14  259     219     218     218
   q15  579     536     529     529
   q16  459     419     416     416
   q17  1048    503     577     503
   q18  7124    6714    7119    6714
   q19  1664    1477    1511    1477
   q20  588     327     323     323
   q21  2902    2515    2493    2493
   q22  398     314     338     314
   Total cold run time: 44987 ms
   Total hot run time: 40000 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5099    5080    5037    5037
   q2   330     236     234     234
   q3   3379    3344    3337    3337
   q4   2153    2054    2103    2054
   q5   5937    5922    5915    5915
   q6   222     127     127     127
   q7   2366    1923    1918    1918
   q8   3538    3641    3642    3641
   q9   9081    8986    9031    8986
   q10  3862    3897    3923    3897
   q11  578     475     467     467
   q12  799     619     628     619
   q13  3873    3172    3206    3172
   q14  304     274     290     274
   q15  581     519     517     517
   q16  573     500     514     500
   q17  2023    1851    1850    1850
   q18  8748    8398    8340    8340
   q19  1744    1682    1707    1682
   q20  2277    1965    1985    1965
   q21  5791    5263    5303    5263
   q22  558     474     458     458
   Total cold run time: 63816 ms
   Total hot run time: 60253 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