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

   
   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 94be0064bd4749203bf2c5ea6575c23a828d5598, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5506    5144    5147    5144
   q2   386     170     159     159
   q3   1463    1229    1139    1139
   q4   1090    857     818     818
   q5   3163    3170    3171    3170
   q6   221     134     136     134
   q7   994     541     507     507
   q8   2160    2298    2234    2234
   q9   6693    6659    6660    6659
   q10  3225    3129    3120    3120
   q11  334     220     224     220
   q12  380     231     238     231
   q13  4396    3674    3682    3674
   q14  247     218     223     218
   q15  584     540     532     532
   q16  449     439     408     408
   q17  1056    499     520     499
   q18  7127    6778    6818    6778
   q19  1647    1550    1600    1550
   q20  552     324     338     324
   q21  2904    2445    2497    2445
   q22  403     337     335     335
   Total cold run time: 44980 ms
   Total hot run time: 40298 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5175    5048    5087    5048
   q2   336     228     245     228
   q3   3361    3336    3320    3320
   q4   2165    2045    2028    2028
   q5   5976    5954    5941    5941
   q6   220     127     127     127
   q7   2356    1931    1939    1931
   q8   3565    3660    3701    3660
   q9   9029    8987    9032    8987
   q10  3871    3903    3907    3903
   q11  566     466     489     466
   q12  801     633     645     633
   q13  3877    3216    3166    3166
   q14  301     267     276     267
   q15  582     532     528     528
   q16  578     505     506     505
   q17  2065    1813    1813    1813
   q18  8780    8288    8403    8288
   q19  1760    1700    1711    1700
   q20  2286    1986    1977    1977
   q21  5787    5371    5284    5284
   q22  557     498     461     461
   Total cold run time: 63994 ms
   Total hot run time: 60261 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