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

   
   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 d4771cb9e8d1eec85a076b033f39af1b80084718, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5474    5202    5189    5189
   q2   398     156     159     156
   q3   1470    1213    1188    1188
   q4   1090    846     888     846
   q5   3157    3118    3190    3118
   q6   221     147     139     139
   q7   998     562     519     519
   q8   2164    2264    2216    2216
   q9   6718    6674    6687    6674
   q10  3204    3161    3182    3161
   q11  338     211     208     208
   q12  378     241     241     241
   q13  4383    3678    3629    3629
   q14  245     222     219     219
   q15  581     530     529     529
   q16  469     401     411     401
   q17  1042    523     551     523
   q18  7071    6733    6840    6733
   q19  1645    1575    1486    1486
   q20  593     322     361     322
   q21  2919    2460    2511    2460
   q22  398     319     330     319
   Total cold run time: 44956 ms
   Total hot run time: 40276 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5126    5143    5120    5120
   q2   344     239     229     229
   q3   3381    3345    3321    3321
   q4   2150    2052    2023    2023
   q5   5961    5944    5965    5944
   q6   223     127     132     127
   q7   2421    1940    1932    1932
   q8   3558    3693    3647    3647
   q9   9116    9038    8982    8982
   q10  3865    3921    3929    3921
   q11  570     493     484     484
   q12  807     631     618     618
   q13  3889    3182    3186    3182
   q14  294     273     269     269
   q15  584     534     520     520
   q16  555     483     482     482
   q17  2047    1854    1870    1854
   q18  8680    8406    8409    8406
   q19  1765    1703    1711    1703
   q20  2248    1982    1966    1966
   q21  5759    5325    5382    5325
   q22  567     489     477     477
   Total cold run time: 63910 ms
   Total hot run time: 60532 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