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

   
   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 f12f00bef571cc3401e30fe4895ec7f8217f3749, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5504    5149    5138    5138
   q2   383     171     178     171
   q3   1456    1209    1150    1150
   q4   1075    812     730     730
   q5   3107    3032    3104    3032
   q6   223     133     133     133
   q7   955     530     530     530
   q8   2142    2288    2216    2216
   q9   6678    6654    6655    6654
   q10  3200    3114    3149    3114
   q11  340     205     203     203
   q12  389     233     229     229
   q13  4398    3643    3650    3643
   q14  252     234     224     224
   q15  582     529     530     529
   q16  444     403     433     403
   q17  1044    539     549     539
   q18  7070    6772    6768    6768
   q19  1637    1503    1466    1466
   q20  566     327     350     327
   q21  2874    2468    2443    2443
   q22  403     321     329     321
   Total cold run time: 44722 ms
   Total hot run time: 39963 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5215    5091    5089    5089
   q2   335     236     235     235
   q3   3365    3340    3311    3311
   q4   2145    1993    2003    1993
   q5   5937    5910    5944    5910
   q6   219     125     125     125
   q7   2395    1913    1931    1913
   q8   3593    3654    3644    3644
   q9   8980    8953    8972    8953
   q10  3842    3886    3913    3886
   q11  580     466     483     466
   q12  787     657     626     626
   q13  3885    3196    3203    3196
   q14  319     283     263     263
   q15  590     536     524     524
   q16  567     487     501     487
   q17  2028    1842    1830    1830
   q18  8859    8871    8381    8381
   q19  1741    1674    1691    1674
   q20  2268    1984    1976    1976
   q21  5614    5411    5330    5330
   q22  585     505     524     505
   Total cold run time: 63849 ms
   Total hot run time: 60317 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