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

   
   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 13464cd090bcb8e2f936818442773b4ec88ad2ec, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5466    5169    5087    5087
   q2   383     162     160     160
   q3   1487    1188    1124    1124
   q4   1070    848     789     789
   q5   3163    3115    3174    3115
   q6   222     134     138     134
   q7   989     554     518     518
   q8   2166    2295    2253    2253
   q9   6705    6658    6668    6658
   q10  3144    3098    3090    3090
   q11  357     229     225     225
   q12  380     242     238     238
   q13  4427    3681    3682    3681
   q14  266     217     225     217
   q15  580     542     531     531
   q16  461     406     392     392
   q17  1050    539     480     480
   q18  7109    6763    6825    6763
   q19  1639    1583    1635    1583
   q20  589     328     315     315
   q21  2919    2456    2570    2456
   q22  396     323     328     323
   Total cold run time: 44968 ms
   Total hot run time: 40132 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5133    5033    5034    5033
   q2   346     239     235     235
   q3   3361    3345    3306    3306
   q4   2165    2066    2064    2064
   q5   5954    5935    5926    5926
   q6   224     127     132     127
   q7   2376    1881    1905    1881
   q8   3574    3690    3690    3690
   q9   9037    9042    9067    9042
   q10  3885    3892    3913    3892
   q11  577     479     490     479
   q12  807     624     634     624
   q13  3863    3202    3181    3181
   q14  303     276     268     268
   q15  586     535     518     518
   q16  548     517     516     516
   q17  2042    1795    1816    1795
   q18  8818    8363    8362    8362
   q19  1758    1711    1722    1711
   q20  2247    1984    1977    1977
   q21  5698    5255    5393    5255
   q22  578     466     510     466
   Total cold run time: 63880 ms
   Total hot run time: 60348 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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to