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

   
   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 fe2cdfe9356739142d968f3b454f290c58dc007f, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5471    5102    5121    5102
   q2   385     170     155     155
   q3   1466    1130    1192    1130
   q4   1086    820     738     738
   q5   3142    3153    3132    3132
   q6   223     134     134     134
   q7   1003    565     519     519
   q8   2157    2265    2267    2265
   q9   6680    6680    6693    6680
   q10  3176    3189    3125    3125
   q11  340     222     208     208
   q12  386     229     233     229
   q13  4446    3610    3660    3610
   q14  256     222     211     211
   q15  574     548     538     538
   q16  459     436     395     395
   q17  1052    526     551     526
   q18  7122    6758    6737    6737
   q19  1631    1539    1466    1466
   q20  549     336     307     307
   q21  2902    2476    2539    2476
   q22  381     317     297     297
   Total cold run time: 44887 ms
   Total hot run time: 39980 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5100    5170    5082    5082
   q2   338     233     239     233
   q3   3369    3339    3310    3310
   q4   2156    2048    2072    2048
   q5   5941    5903    5918    5903
   q6   228     126     127     126
   q7   2394    1904    1949    1904
   q8   3588    3671    3676    3671
   q9   8994    8990    8936    8936
   q10  3862    3896    3895    3895
   q11  580     482     480     480
   q12  813     627     635     627
   q13  3866    3199    3171    3171
   q14  291     291     272     272
   q15  578     527     534     527
   q16  563     532     490     490
   q17  2032    1816    1832    1816
   q18  8806    8385    8363    8363
   q19  1750    1726    1681    1681
   q20  2264    1966    1956    1956
   q21  5598    5329    5366    5329
   q22  552     505     464     464
   Total cold run time: 63663 ms
   Total hot run time: 60284 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