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

   
   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 d6d998991d8bfdd4948f3e4ecd388ac7100381a0, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5521    5162    5088    5088
   q2   385     201     157     157
   q3   1476    1270    1118    1118
   q4   1081    787     797     787
   q5   3134    3162    3089    3089
   q6   223     138     136     136
   q7   1014    555     517     517
   q8   2167    2252    2224    2224
   q9   6702    6674    6669    6669
   q10  3161    3136    3153    3136
   q11  346     221     215     215
   q12  387     228     238     228
   q13  4378    3661    3649    3649
   q14  254     215     215     215
   q15  580     529     530     529
   q16  483     414     381     381
   q17  1045    506     450     450
   q18  7149    6756    6733    6733
   q19  1647    1556    1434    1434
   q20  539     315     333     315
   q21  2916    2538    2439    2439
   q22  404     315     334     315
   Total cold run time: 44992 ms
   Total hot run time: 39824 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5082    5047    5093    5047
   q2   341     225     239     225
   q3   3361    3329    3326    3326
   q4   2148    2035    1998    1998
   q5   5947    5908    5939    5908
   q6   222     127     129     127
   q7   2391    1929    1899    1899
   q8   3555    3679    3670    3670
   q9   9082    8993    8974    8974
   q10  3849    3910    3912    3910
   q11  582     485     481     481
   q12  807     639     620     620
   q13  3896    3207    3154    3154
   q14  307     269     260     260
   q15  581     539     525     525
   q16  586     522     507     507
   q17  2044    1802    1820    1802
   q18  8794    8358    8546    8358
   q19  1753    1682    1676    1676
   q20  2261    1983    1974    1974
   q21  5805    5422    5427    5422
   q22  564     469     449     449
   Total cold run time: 63958 ms
   Total hot run time: 60312 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