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

   
   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 3bfdedcaae578c43b4a09b1e09fb3613ef8011f8, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5558    5142    5169    5142
   q2   385     188     159     159
   q3   1459    1123    1164    1123
   q4   1080    805     768     768
   q5   3109    3134    3155    3134
   q6   223     137     132     132
   q7   976     559     509     509
   q8   2147    2281    2280    2280
   q9   6709    6681    6689    6681
   q10  3169    3151    3101    3101
   q11  341     211     216     211
   q12  387     227     238     227
   q13  4404    3629    3651    3629
   q14  253     214     212     212
   q15  570     541     529     529
   q16  466     414     398     398
   q17  1051    540     542     540
   q18  7060    6755    6734    6734
   q19  1646    1510    1578    1510
   q20  594     327     325     325
   q21  2824    2482    2525    2482
   q22  396     330     311     311
   Total cold run time: 44807 ms
   Total hot run time: 40137 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5091    4992    5165    4992
   q2   342     237     242     237
   q3   3376    3356    3315    3315
   q4   2161    2089    2059    2059
   q5   5958    5937    5931    5931
   q6   225     126     125     125
   q7   2388    1920    1934    1920
   q8   3594    3657    3679    3657
   q9   8971    8951    8909    8909
   q10  3880    3912    3932    3912
   q11  577     462     464     462
   q12  817     629     640     629
   q13  3865    3196    3146    3146
   q14  324     269     265     265
   q15  589     528     529     528
   q16  563     519     501     501
   q17  2045    1841    1803    1803
   q18  8775    8321    8344    8321
   q19  1753    1728    1677    1677
   q20  2296    1974    1979    1974
   q21  5713    5314    5431    5314
   q22  575     477     489     477
   Total cold run time: 63878 ms
   Total hot run time: 60154 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