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

   
   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 a8a53b53d8ff38d91c43de4113b5a2928407280c, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5411    5098    5177    5098
   q2   384     159     158     158
   q3   1466    1228    1238    1228
   q4   1098    873     806     806
   q5   3183    3069    3115    3069
   q6   221     132     141     132
   q7   976     550     520     520
   q8   2160    2194    2197    2194
   q9   6691    6684    6622    6622
   q10  3208    3103    3121    3103
   q11  339     226     222     222
   q12  386     232     235     232
   q13  4383    3667    3659    3659
   q14  250     224     222     222
   q15  625     556     534     534
   q16  473     398     405     398
   q17  1045    603     507     507
   q18  7108    6775    6762    6762
   q19  1652    1530    1442    1442
   q20  597     356     343     343
   q21  2903    2500    2505    2500
   q22  397     316     332     316
   Total cold run time: 44956 ms
   Total hot run time: 40067 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5144    5095    5125    5095
   q2   336     254     264     254
   q3   3403    3308    3297    3297
   q4   2153    2080    2055    2055
   q5   5963    5965    5941    5941
   q6   228     123     126     123
   q7   2379    1936    1940    1936
   q8   3582    3677    3663    3663
   q9   9079    9000    8987    8987
   q10  3889    3934    3945    3934
   q11  593     483     486     483
   q12  810     612     636     612
   q13  3909    3191    3192    3191
   q14  291     295     288     288
   q15  612     545     549     545
   q16  561     520     521     520
   q17  2015    1811    1824    1811
   q18  8754    8364    8341    8341
   q19  1752    1687    1686    1686
   q20  2297    1989    1982    1982
   q21  5760    5367    5344    5344
   q22  562     506     534     506
   Total cold run time: 64072 ms
   Total hot run time: 60594 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