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

   
   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 81fd4987529354020227b833184e8f74c812b89e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5499    5121    5140    5121
   q2   383     170     160     160
   q3   1466    1177    1238    1177
   q4   1096    796     849     796
   q5   3146    3120    3023    3023
   q6   225     131     131     131
   q7   998     565     515     515
   q8   2150    2278    2226    2226
   q9   6692    6675    6659    6659
   q10  3181    3138    3155    3138
   q11  355     233     218     218
   q12  380     237     234     234
   q13  4387    3633    3641    3633
   q14  245     227     224     224
   q15  608     578     545     545
   q16  453     415     420     415
   q17  1046    564     623     564
   q18  7074    6709    6897    6709
   q19  1641    1520    1511    1511
   q20  576     399     352     352
   q21  2958    2532    2509    2509
   q22  384     318     337     318
   Total cold run time: 44943 ms
   Total hot run time: 40178 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5092    5087    5036    5036
   q2   331     263     246     246
   q3   3371    3346    3316    3316
   q4   2142    2017    2030    2017
   q5   5953    5883    5902    5883
   q6   230     127     125     125
   q7   2384    1906    1895    1895
   q8   3558    3659    3690    3659
   q9   9029    8964    8943    8943
   q10  3885    3904    3915    3904
   q11  605     470     468     468
   q12  788     668     626     626
   q13  3885    3186    3173    3173
   q14  307     278     268     268
   q15  617     540     546     540
   q16  531     502     506     502
   q17  2039    1787    1803    1787
   q18  8837    8336    8491    8336
   q19  1751    1737    1705    1705
   q20  2286    1974    1991    1974
   q21  5750    5304    5262    5262
   q22  588     491     547     491
   Total cold run time: 63959 ms
   Total hot run time: 60156 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