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

   
   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 80281fcf3e94dcfa76501c305a98c1e50ca79173, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5528    5086    5086    5086
   q2   379     154     168     154
   q3   1469    1131    1160    1131
   q4   1081    807     797     797
   q5   3098    3034    3089    3034
   q6   218     135     135     135
   q7   970     522     541     522
   q8   2131    2273    2237    2237
   q9   6683    6669    6661    6661
   q10  3164    3106    3149    3106
   q11  330     215     221     215
   q12  377     243     233     233
   q13  4380    3681    3639    3639
   q14  257     217     220     217
   q15  581     527     523     523
   q16  459     402     414     402
   q17  1049    519     536     519
   q18  7067    6740    7667    6740
   q19  1646    1467    1583    1467
   q20  549     348     332     332
   q21  2905    2496    2576    2496
   q22  398     332     341     332
   Total cold run time: 44719 ms
   Total hot run time: 39978 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5118    5079    5081    5079
   q2   345     248     232     232
   q3   3345    3328    3317    3317
   q4   2155    2024    2034    2024
   q5   5971    5955    5939    5939
   q6   219     125     128     125
   q7   2380    1937    1898    1898
   q8   3543    3627    3660    3627
   q9   8989    8982    8964    8964
   q10  3872    3912    3910    3910
   q11  599     480     481     480
   q12  808     619     619     619
   q13  3874    3199    3196    3196
   q14  295     264     269     264
   q15  598     527     523     523
   q16  582     502     478     478
   q17  2044    1837    1853    1837
   q18  8774    8324    8286    8286
   q19  1735    1681    1675    1675
   q20  2276    1977    1949    1949
   q21  5767    5273    5285    5273
   q22  567     486     485     485
   Total cold run time: 63856 ms
   Total hot run time: 60180 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