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

   
   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 772bd7742c3e223574b122501b0a85baaa25c242, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5562    5096    5163    5096
   q2   400     162     160     160
   q3   1467    1121    1179    1121
   q4   1097    811     812     811
   q5   3125    3194    3095    3095
   q6   225     139     145     139
   q7   1010    559     500     500
   q8   2159    2241    2198    2198
   q9   6727    6707    6638    6638
   q10  3212    3172    3197    3172
   q11  344     226     213     213
   q12  390     236     240     236
   q13  4428    3682    3648    3648
   q14  254     224     211     211
   q15  606     551     536     536
   q16  460     409     399     399
   q17  1045    627     514     514
   q18  7075    6754    6842    6754
   q19  1641    1548    1421    1421
   q20  610     333     353     333
   q21  2933    2508    2481    2481
   q22  406     328     351     328
   Total cold run time: 45176 ms
   Total hot run time: 40004 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5125    5050    5151    5050
   q2   348     246     242     242
   q3   3412    3334    3287    3287
   q4   2140    2030    2050    2030
   q5   5964    5926    5928    5926
   q6   229     125     128     125
   q7   2399    1927    1938    1927
   q8   3563    3647    3665    3647
   q9   9019    8967    8996    8967
   q10  3884    3913    3936    3913
   q11  593     475     491     475
   q12  815     679     690     679
   q13  3875    3231    3197    3197
   q14  301     274     274     274
   q15  604     540     537     537
   q16  563     496     507     496
   q17  2011    1806    1812    1806
   q18  8748    8422    8378    8378
   q19  1735    1700    1666    1666
   q20  2510    2009    1993    1993
   q21  5744    5236    5419    5236
   q22  569     513     538     513
   Total cold run time: 64151 ms
   Total hot run time: 60364 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to