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

   
   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 a24fa676662dc89476e5dcc29d6102bfc9399597, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5448    5106    5117    5106
   q2   401     174     161     161
   q3   1453    1198    1176    1176
   q4   1090    820     793     793
   q5   3146    3182    3126    3126
   q6   225     140     140     140
   q7   995     563     525     525
   q8   2154    2194    2237    2194
   q9   6737    6676    6682    6676
   q10  3183    3172    3102    3102
   q11  344     231     222     222
   q12  386     242     236     236
   q13  4395    3646    3660    3646
   q14  254     221     204     204
   q15  592     548     541     541
   q16  452     394     434     394
   q17  1052    541     473     473
   q18  7082    6821    6809    6809
   q19  1643    1553    1411    1411
   q20  613     353     334     334
   q21  2924    2486    2494    2486
   q22  405     324     313     313
   Total cold run time: 44974 ms
   Total hot run time: 40068 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5132    5092    5100    5092
   q2   339     245     249     245
   q3   3361    3322    3315    3315
   q4   2149    1995    2002    1995
   q5   5928    5911    5914    5911
   q6   228     130     125     125
   q7   2385    1914    1882    1882
   q8   3540    3677    3633    3633
   q9   9043    8987    8950    8950
   q10  3877    3940    3923    3923
   q11  580     512     480     480
   q12  790     662     656     656
   q13  3875    3182    3190    3182
   q14  313     280     261     261
   q15  614     537     538     537
   q16  537     507     522     507
   q17  2030    1813    1786    1786
   q18  8733    8380    8364    8364
   q19  1736    1652    1703    1652
   q20  2315    1999    1988    1988
   q21  5692    5203    5279    5203
   q22  564     509     489     489
   Total cold run time: 63761 ms
   Total hot run time: 60176 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to