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

   
   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 fd5fccd14d9a92dbdcedc00d3d87d42d203512a0, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5435    5126    5148    5126
   q2   380     174     161     161
   q3   1482    1151    1061    1061
   q4   1084    852     823     823
   q5   3166    3115    2974    2974
   q6   222     133     130     130
   q7   994     532     561     532
   q8   2143    2245    2250    2245
   q9   6688    6683    6670    6670
   q10  3180    3112    3099    3099
   q11  350     223     227     223
   q12  376     239     228     228
   q13  4393    3619    3670    3619
   q14  242     222     210     210
   q15  607     550     541     541
   q16  469     406     402     402
   q17  1044    509     499     499
   q18  7126    6791    6838    6791
   q19  1650    1495    1514    1495
   q20  610     355     357     355
   q21  3069    2393    2447    2393
   q22  399     324     341     324
   Total cold run time: 45109 ms
   Total hot run time: 39901 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5135    5041    5059    5041
   q2   347     238     264     238
   q3   3395    3322    3307    3307
   q4   2142    1999    1996    1996
   q5   5981    5940    5940    5940
   q6   230     125     128     125
   q7   2402    1950    1965    1950
   q8   3567    3646    3702    3646
   q9   9085    8985    9006    8985
   q10  3896    3878    3906    3878
   q11  599     489     476     476
   q12  828     625     646     625
   q13  3942    3248    3223    3223
   q14  294     262     287     262
   q15  625     552     548     548
   q16  547     507     527     507
   q17  2061    1838    1806    1806
   q18  8758    8333    8360    8333
   q19  1741    1670    1733    1670
   q20  2275    1999    1979    1979
   q21  5732    5432    5335    5335
   q22  567     491     489     489
   Total cold run time: 64149 ms
   Total hot run time: 60359 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