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

   
   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 5596a40bcd0692f14ccaf57a253588634258d3d6, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5568    5141    5158    5141
   q2   391     165     159     159
   q3   1476    1288    1197    1197
   q4   1098    797     805     797
   q5   3140    3154    3104    3104
   q6   228     137     134     134
   q7   986     561     526     526
   q8   2162    2270    2239    2239
   q9   6701    6670    6648    6648
   q10  3188    3114    3117    3114
   q11  357     226     210     210
   q12  376     234     235     234
   q13  4406    3655    3668    3655
   q14  246     216     230     216
   q15  578     527     532     527
   q16  456     406     417     406
   q17  1053    531     590     531
   q18  7128    6745    6749    6745
   q19  1646    1491    1564    1491
   q20  598     342     325     325
   q21  2889    2418    2523    2418
   q22  403     319     322     319
   Total cold run time: 45074 ms
   Total hot run time: 40136 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5127    5054    5078    5054
   q2   335     242     238     238
   q3   3361    3330    3308    3308
   q4   2163    2090    2066    2066
   q5   5938    5926    5884    5884
   q6   222     126     130     126
   q7   2422    1914    1947    1914
   q8   3561    3678    3664    3664
   q9   9093    8968    9057    8968
   q10  3858    3909    3920    3909
   q11  572     486     476     476
   q12  801     626     610     610
   q13  3861    3199    3154    3154
   q14  308     261     291     261
   q15  579     539     522     522
   q16  552     512     503     503
   q17  2006    1830    1836    1830
   q18  8717    8360    8386    8360
   q19  1741    1669    1667    1667
   q20  2261    1986    1980    1980
   q21  5757    5403    5306    5306
   q22  558     462     499     462
   Total cold run time: 63793 ms
   Total hot run time: 60262 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