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

   
   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 c69f52bae007951e2fc0d233f0beff0ca92c43c0, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5380    5128    5137    5128
   q2   388     175     179     175
   q3   1482    1161    1134    1134
   q4   1095    864     850     850
   q5   3152    3153    3102    3102
   q6   235     143     141     141
   q7   1034    587     538     538
   q8   2152    2249    2188    2188
   q9   6690    6670    6676    6670
   q10  3196    3183    3133    3133
   q11  344     222     221     221
   q12  398     243     248     243
   q13  4425    3669    3635    3635
   q14  259     231     224     224
   q15  628     584     572     572
   q16  468     419     410     410
   q17  1045    566     611     566
   q18  7093    6731    7551    6731
   q19  1677    1568    1522    1522
   q20  574     365     371     365
   q21  2843    2560    2503    2503
   q22  385     343     335     335
   Total cold run time: 44943 ms
   Total hot run time: 40386 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5120    5124    4999    4999
   q2   353     242     257     242
   q3   3395    3360    3353    3353
   q4   2151    2051    2013    2013
   q5   5957    5901    5924    5901
   q6   240     136     138     136
   q7   2364    1941    1888    1888
   q8   3574    3697    3691    3691
   q9   9092    9014    9016    9014
   q10  3906    3981    3965    3965
   q11  593     478     497     478
   q12  801     640     621     621
   q13  3901    3237    3231    3231
   q14  306     273     285     273
   q15  636     565     557     557
   q16  561     511     506     506
   q17  2018    1827    1836    1827
   q18  8871    8376    8423    8376
   q19  1779    1753    1729    1729
   q20  2296    1997    1976    1976
   q21  5839    5316    5360    5316
   q22  600     498     515     498
   Total cold run time: 64353 ms
   Total hot run time: 60590 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