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

   
   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 5a8579375b94bfc14b403dad2d96eb7c4a97c94f, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5465    5102    5197    5102
   q2   385     169     159     159
   q3   1461    1194    1198    1194
   q4   1103    738     750     738
   q5   3149    3063    3158    3063
   q6   221     137     139     137
   q7   989     584     534     534
   q8   2155    2223    2313    2223
   q9   6645    6665    6666    6665
   q10  3196    3173    3152    3152
   q11  328     233     223     223
   q12  381     240     238     238
   q13  4413    3646    3628    3628
   q14  251     221     221     221
   q15  573     531     517     517
   q16  451     389     409     389
   q17  1033    534     594     534
   q18  7064    6748    6785    6748
   q19  1634    1504    1397    1397
   q20  558     347     330     330
   q21  2928    2681    2545    2545
   q22  411     318     323     318
   Total cold run time: 44794 ms
   Total hot run time: 40055 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5087    5102    5094    5094
   q2   337     242     232     232
   q3   3380    3345    3317    3317
   q4   2149    2047    2059    2047
   q5   5939    5954    5958    5954
   q6   222     131     132     131
   q7   2406    1924    1939    1924
   q8   3549    3638    3686    3638
   q9   9033    9009    9004    9004
   q10  3881    3918    3897    3897
   q11  565     479     494     479
   q12  813     637     649     637
   q13  3864    3191    3186    3186
   q14  301     282     268     268
   q15  600     528     528     528
   q16  539     506     495     495
   q17  2040    1819    1792    1792
   q18  8824    8400    8432    8400
   q19  1746    1678    1719    1678
   q20  2270    1982    1970    1970
   q21  5778    5383    5401    5383
   q22  569     469     472     469
   Total cold run time: 63892 ms
   Total hot run time: 60523 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