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

   
   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 1b0540353e961aab5b2f0c5084f586d124965f90, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5468    5171    5117    5117
   q2   380     174     157     157
   q3   1460    1115    1156    1115
   q4   1080    806     838     806
   q5   3105    3188    3042    3042
   q6   223     134     135     134
   q7   958     540     522     522
   q8   2139    2183    2220    2183
   q9   6681    6629    6648    6629
   q10  3196    3158    3206    3158
   q11  347     211     224     211
   q12  387     231     233     231
   q13  4398    3683    3645    3645
   q14  250     211     217     211
   q15  580     552     528     528
   q16  457     406     397     397
   q17  1041    531     504     504
   q18  7088    6708    7114    6708
   q19  1649    1507    1417    1417
   q20  563     346     438     346
   q21  2907    2386    2459    2386
   q22  367     326     357     326
   Total cold run time: 44724 ms
   Total hot run time: 39773 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5100    5053    4980    4980
   q2   335     242     229     229
   q3   3353    3320    3305    3305
   q4   2168    2056    2065    2056
   q5   5925    5914    5952    5914
   q6   224     124     128     124
   q7   2397    1933    1900    1900
   q8   3560    3660    3664    3660
   q9   9030    8988    8865    8865
   q10  3843    3884    3914    3884
   q11  589     471     460     460
   q12  814     651     633     633
   q13  3874    3196    3183    3183
   q14  295     265     273     265
   q15  587     535     530     530
   q16  563     484     496     484
   q17  2029    1812    1806    1806
   q18  8706    8380    8962    8380
   q19  1746    1690    1662    1662
   q20  2284    1981    1961    1961
   q21  5837    5338    5317    5317
   q22  563     467     513     467
   Total cold run time: 63822 ms
   Total hot run time: 60065 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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to