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

   
   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 a4ae959d7ff41f70697302a17a2f82e15f1b8185, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5436    5155    5117    5117
   q2   378     175     159     159
   q3   1460    1162    1119    1119
   q4   1083    820     832     820
   q5   3124    3103    3133    3103
   q6   228     133     139     133
   q7   974     582     509     509
   q8   2152    2167    2236    2167
   q9   6663    6645    6644    6644
   q10  3184    3117    3134    3117
   q11  337     224     218     218
   q12  382     235     237     235
   q13  4394    3680    3656    3656
   q14  245     224     216     216
   q15  582     543     520     520
   q16  476     427     394     394
   q17  1039    558     515     515
   q18  7055    6729    6750    6729
   q19  1630    1520    1594    1520
   q20  596     343     345     343
   q21  2901    2500    2482    2482
   q22  398     327     340     327
   Total cold run time: 44717 ms
   Total hot run time: 40043 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5097    5089    5079    5079
   q2   340     236     243     236
   q3   3353    3332    3316    3316
   q4   2138    2073    2060    2060
   q5   5967    5925    5943    5925
   q6   226     128     129     128
   q7   2385    1919    1911    1911
   q8   3594    3630    3675    3630
   q9   9028    8996    8935    8935
   q10  3842    3891    3897    3891
   q11  586     489     474     474
   q12  815     629     646     629
   q13  3876    3220    3199    3199
   q14  305     263     273     263
   q15  594     528     531     528
   q16  549     501     501     501
   q17  2029    1847    1842    1842
   q18  8683    8377    8428    8377
   q19  1721    1621    1675    1621
   q20  2257    1988    1981    1981
   q21  5719    5393    5397    5393
   q22  552     465     474     465
   Total cold run time: 63656 ms
   Total hot run time: 60384 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