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

   
   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 a2207ee6fecea8d77f01003ae023832d4ad11f79, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5529    5176    5191    5176
   q2   408     174     160     160
   q3   1466    1218    1150    1150
   q4   1089    889     743     743
   q5   3095    3137    3154    3137
   q6   221     135     135     135
   q7   969     550     530     530
   q8   2159    2267    2256    2256
   q9   6692    6648    6664    6648
   q10  3159    3108    3128    3108
   q11  334     229     218     218
   q12  384     226     229     226
   q13  4398    3671    3660    3660
   q14  254     230     218     218
   q15  572     546     533     533
   q16  460     422     392     392
   q17  1044    559     551     551
   q18  7085    6795    6786    6786
   q19  1660    1531    1440    1440
   q20  543     331     349     331
   q21  2948    2464    2503    2464
   q22  416     332     332     332
   Total cold run time: 44885 ms
   Total hot run time: 40194 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5184    5079    5049    5049
   q2   336     238     228     228
   q3   3382    3328    3338    3328
   q4   2168    2036    2059    2036
   q5   5971    5973    5933    5933
   q6   227     126     130     126
   q7   2407    1911    1907    1907
   q8   3585    3658    3679    3658
   q9   9070    9066    8984    8984
   q10  3854    3898    3902    3898
   q11  596     507     489     489
   q12  799     632     634     632
   q13  3889    3185    3172    3172
   q14  307     261     300     261
   q15  603     525     531     525
   q16  561     497     487     487
   q17  2030    1816    1832    1816
   q18  8667    8283    8418    8283
   q19  1749    1680    1706    1680
   q20  2263    1969    1981    1969
   q21  5741    5346    5338    5338
   q22  546     529     483     483
   Total cold run time: 63935 ms
   Total hot run time: 60282 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