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

   
   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 dba3fd83ad6b4c78173302af3d7eaa132f73ad54, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5402    5131    5171    5131
   q2   391     172     150     150
   q3   1477    1207    1183    1183
   q4   1085    835     831     831
   q5   3079    2973    3102    2973
   q6   226     133     134     133
   q7   986     533     523     523
   q8   2164    2291    2256    2256
   q9   6702    6654    6663    6654
   q10  3155    3096    3126    3096
   q11  342     225     215     215
   q12  376     232     239     232
   q13  4404    3642    3638    3638
   q14  246     214     219     214
   q15  576     538     524     524
   q16  442     390     418     390
   q17  1040    528     495     495
   q18  7095    6719    6700    6700
   q19  1634    1492    1530    1492
   q20  588     331     332     331
   q21  2923    2488    2484    2484
   q22  404     332     342     332
   Total cold run time: 44737 ms
   Total hot run time: 39977 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5116    5118    5090    5090
   q2   336     236     236     236
   q3   3371    3340    3325    3325
   q4   2167    2026    2040    2026
   q5   5972    5917    5912    5912
   q6   223     128     126     126
   q7   2394    1934    1934    1934
   q8   3573    3658    3672    3658
   q9   9124    8977    9034    8977
   q10  3898    3897    3908    3897
   q11  590     473     487     473
   q12  792     640     649     640
   q13  3881    3169    3181    3169
   q14  315     277     269     269
   q15  583     532     523     523
   q16  566     470     528     470
   q17  2018    1807    1829    1807
   q18  8773    8411    8397    8397
   q19  1751    1662    1691    1662
   q20  2261    1988    1976    1976
   q21  5753    5377    5299    5299
   q22  595     471     499     471
   Total cold run time: 64052 ms
   Total hot run time: 60337 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