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

   
   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 1142a9aa8b11918c00697abc8165b5e6fdab5500, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5509    5136    5112    5112
   q2   384     170     177     170
   q3   1458    1110    1106    1106
   q4   1100    825     777     777
   q5   3131    3047    3073    3047
   q6   223     131     141     131
   q7   967     539     554     539
   q8   2160    2265    2206    2206
   q9   6666    6668    6680    6668
   q10  3135    3095    3122    3095
   q11  336     220     213     213
   q12  383     232     238     232
   q13  4372    3679    3622    3622
   q14  259     221     216     216
   q15  602     568     548     548
   q16  455     395     395     395
   q17  1042    531     556     531
   q18  7084    6734    6762    6734
   q19  1648    1533    1558    1533
   q20  569     337     361     337
   q21  2827    2439    2456    2439
   q22  399     319     336     319
   Total cold run time: 44709 ms
   Total hot run time: 39970 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5154    5034    5161    5034
   q2   333     260     257     257
   q3   3386    3307    3302    3302
   q4   2152    2032    1987    1987
   q5   5918    5907    5959    5907
   q6   224     122     126     122
   q7   2394    1954    1941    1941
   q8   3534    3661    3654    3654
   q9   8986    9011    8937    8937
   q10  3862    3870    3937    3870
   q11  587     487     470     470
   q12  845     624     719     624
   q13  3885    3212    3216    3212
   q14  295     279     277     277
   q15  625     550     546     546
   q16  584     520     506     506
   q17  2015    1807    1789    1789
   q18  8773    8369    8340    8340
   q19  1738    1704    1662    1662
   q20  2272    2328    1970    1970
   q21  5827    5330    5335    5330
   q22  569     479     527     479
   Total cold run time: 63958 ms
   Total hot run time: 60216 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