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

   
   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 b7401deefbe6f8d00019119794d7df67e372c26c, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5448    5127    5120    5120
   q2   394     160     158     158
   q3   1458    1165    1178    1165
   q4   1089    839     855     839
   q5   3117    3101    3103    3101
   q6   224     133     145     133
   q7   987     551     533     533
   q8   2147    2252    2263    2252
   q9   6708    6635    6671    6635
   q10  3166    3144    3122    3122
   q11  341     213     207     207
   q12  380     237     238     237
   q13  4431    3681    3637    3637
   q14  257     224     226     224
   q15  581     533     521     521
   q16  452     386     414     386
   q17  1045    574     528     528
   q18  7062    6746    6784    6746
   q19  1643    1585    1542    1542
   q20  589     322     346     322
   q21  2885    2486    2559    2486
   q22  399     316     337     316
   Total cold run time: 44803 ms
   Total hot run time: 40210 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5133    5156    5056    5056
   q2   343     232     247     232
   q3   3363    3340    3329    3329
   q4   2164    2052    2073    2052
   q5   5947    5922    5931    5922
   q6   222     127     125     125
   q7   2384    1901    1895    1895
   q8   3566    3672    3660    3660
   q9   9011    8953    8990    8953
   q10  3855    3911    3947    3911
   q11  578     474     487     474
   q12  796     627     636     627
   q13  3883    3203    3198    3198
   q14  297     267     277     267
   q15  593     530     529     529
   q16  546     513     488     488
   q17  2023    1828    1799    1799
   q18  8738    8383    8351    8351
   q19  1746    1687    1686    1686
   q20  2281    1989    1971    1971
   q21  5766    5352    5282    5282
   q22  575     530     502     502
   Total cold run time: 63810 ms
   Total hot run time: 60309 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