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

   
   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 ffce52a625abe3a04536658d1dbfc787d08816ba, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5364    5144    5119    5119
   q2   388     165     157     157
   q3   1479    1178    1174    1174
   q4   1084    844     799     799
   q5   3117    3188    3140    3140
   q6   226     132     129     129
   q7   981     548     545     545
   q8   2174    2226    2205    2205
   q9   6688    6652    6655    6652
   q10  3171    3181    3168    3168
   q11  332     226     217     217
   q12  381     229     239     229
   q13  4395    3614    3661    3614
   q14  255     220     221     220
   q15  611     573     556     556
   q16  442     396     416     396
   q17  1037    579     541     541
   q18  7084    6796    6769    6769
   q19  1642    1497    1405    1405
   q20  602     334     364     334
   q21  2921    2527    2456    2456
   q22  374     329     329     329
   Total cold run time: 44748 ms
   Total hot run time: 40154 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5069    5134    5068    5068
   q2   331     264     261     261
   q3   3370    3312    3302    3302
   q4   2142    2008    1985    1985
   q5   5938    5878    5897    5878
   q6   233     125     124     124
   q7   2385    1924    1914    1914
   q8   3592    3659    3674    3659
   q9   9020    8956    8959    8956
   q10  3869    3912    3894    3894
   q11  607     486     507     486
   q12  817     659     644     644
   q13  3863    3207    3213    3207
   q14  297     281     282     281
   q15  615     552     550     550
   q16  563     528     508     508
   q17  2021    1801    1842    1801
   q18  8724    8269    8388    8269
   q19  1748    1707    1701    1701
   q20  2277    2001    1970    1970
   q21  5769    5442    5356    5356
   q22  581     506     529     506
   Total cold run time: 63831 ms
   Total hot run time: 60320 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