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

   
   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 6e25a64f51cd07a9acedfb7307749650f4912df7, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5455    5162    5130    5130
   q2   390     162     158     158
   q3   1466    1140    1199    1140
   q4   1084    816     861     816
   q5   3131    3129    3006    3006
   q6   228     136     141     136
   q7   983     549     521     521
   q8   2149    2260    2271    2260
   q9   6698    6671    6613    6613
   q10  3212    3087    3157    3087
   q11  346     228     207     207
   q12  381     237     231     231
   q13  4398    3662    3623    3623
   q14  245     214     222     214
   q15  625     554     537     537
   q16  456     403     412     403
   q17  1049    514     499     499
   q18  7031    6713    6795    6713
   q19  1778    1527    1604    1527
   q20  571     358     328     328
   q21  2863    2407    2476    2407
   q22  393     323     331     323
   Total cold run time: 44932 ms
   Total hot run time: 39879 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5062    5046    5086    5046
   q2   335     259     259     259
   q3   3375    3317    3311    3311
   q4   2157    2013    2020    2013
   q5   5915    5905    5947    5905
   q6   228     124     128     124
   q7   2423    1880    1952    1880
   q8   3581    3656    3666    3656
   q9   9008    8970    8964    8964
   q10  3886    3912    3908    3908
   q11  570     489     507     489
   q12  829     616     662     616
   q13  3917    3218    3184    3184
   q14  311     273     267     267
   q15  614     534     541     534
   q16  571     489     502     489
   q17  2011    1825    1801    1801
   q18  8693    8375    8383    8375
   q19  1737    1708    1689    1689
   q20  2298    2004    1991    1991
   q21  5703    5287    5284    5284
   q22  576     489     521     489
   Total cold run time: 63800 ms
   Total hot run time: 60274 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