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

   
   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 5b4a8655789fbc6ef8161a0ade5f570732ee6bf0, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5570    5126    5180    5126
   q2   414     200     159     159
   q3   1471    1125    1164    1125
   q4   1091    837     829     829
   q5   3143    3131    3104    3104
   q6   225     138     136     136
   q7   1000    542     508     508
   q8   2146    2284    2275    2275
   q9   6704    6655    6662    6655
   q10  3176    3090    3084    3084
   q11  337     219     225     219
   q12  379     232     231     231
   q13  4395    3670    3642    3642
   q14  256     223     227     223
   q15  589     535     524     524
   q16  456     400     407     400
   q17  1042    535     531     531
   q18  7105    6712    6779    6712
   q19  1638    1576    1449    1449
   q20  585     355     355     355
   q21  2846    2459    2522    2459
   q22  398     336     330     330
   Total cold run time: 44966 ms
   Total hot run time: 40076 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5151    5029    5052    5029
   q2   346     225     231     225
   q3   3342    3344    3342    3342
   q4   2159    2064    2055    2055
   q5   5917    5956    5936    5936
   q6   225     128     127     127
   q7   2388    1891    1946    1891
   q8   3565    3644    3667    3644
   q9   9037    8967    9019    8967
   q10  3879    3918    3925    3918
   q11  571     503     475     475
   q12  794     625     646     625
   q13  3859    3213    3186    3186
   q14  298     267     269     267
   q15  584     531     539     531
   q16  557     495     494     494
   q17  2017    1837    1829    1829
   q18  8790    8377    8434    8377
   q19  1754    1687    1694    1687
   q20  2263    1978    1970    1970
   q21  5912    5358    5345    5345
   q22  587     501     504     501
   Total cold run time: 63995 ms
   Total hot run time: 60421 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