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

   
   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 147907567984d29a3a308bcd29a1ae22e0371941, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5489    5226    5187    5187
   q2   399     165     158     158
   q3   1457    1220    1179    1179
   q4   1092    853     842     842
   q5   3113    3139    3114    3114
   q6   225     131     129     129
   q7   993     541     514     514
   q8   2161    2275    2270    2270
   q9   6707    6648    6702    6648
   q10  3184    3085    3077    3077
   q11  349     215     216     215
   q12  392     238     239     238
   q13  4391    3638    3635    3635
   q14  262     227     227     227
   q15  607     559     539     539
   q16  456     404     399     399
   q17  1041    627     538     538
   q18  7091    6713    6723    6713
   q19  1640    1529    1449    1449
   q20  582     345     327     327
   q21  2860    2475    2451    2451
   q22  400     324     342     324
   Total cold run time: 44891 ms
   Total hot run time: 40173 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5108    5072    5025    5025
   q2   340     267     251     251
   q3   3388    3342    3300    3300
   q4   2113    2015    2000    2000
   q5   5953    5912    5916    5912
   q6   230     125     123     123
   q7   2395    1885    1943    1885
   q8   3547    3668    3660    3660
   q9   9046    8959    8974    8959
   q10  3868    3929    3940    3929
   q11  586     487     502     487
   q12  801     643     628     628
   q13  3871    3198    3185    3185
   q14  297     288     274     274
   q15  600     541     529     529
   q16  550     497     520     497
   q17  2115    1849    1783    1783
   q18  8788    8396    8440    8396
   q19  1741    1686    1697    1686
   q20  2294    1993    1984    1984
   q21  5564    5379    5298    5298
   q22  587     527     491     491
   Total cold run time: 63782 ms
   Total hot run time: 60282 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