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

   
   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 ff93072ca7ab7afd6ffca8e1de819fc675a0cf7d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5474    5102    5207    5102
   q2   391     164     165     164
   q3   1432    1124    1261    1124
   q4   1093    780     791     780
   q5   3162    3139    3052    3052
   q6   225     148     132     132
   q7   984     545     538     538
   q8   2146    2256    2233    2233
   q9   6682    6670    6666    6666
   q10  3172    3126    3139    3126
   q11  335     212     208     208
   q12  384     234     230     230
   q13  4358    3640    3630    3630
   q14  256     216     216     216
   q15  596     541     548     541
   q16  474     417     401     401
   q17  1047    563     569     563
   q18  7034    6749    6756    6749
   q19  1649    1511    1454    1454
   q20  570     332     344     332
   q21  2842    2438    2420    2420
   q22  407     326     340     326
   Total cold run time: 44713 ms
   Total hot run time: 39987 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5078    5062    5092    5062
   q2   336     248     246     246
   q3   3390    3338    3296    3296
   q4   2125    2003    2043    2003
   q5   5934    5943    5901    5901
   q6   231     128     127     127
   q7   2363    1911    1963    1911
   q8   3572    3637    3640    3637
   q9   9037    9023    8975    8975
   q10  3853    3926    3923    3923
   q11  574     474     475     474
   q12  806     622     630     622
   q13  3877    3180    3154    3154
   q14  301     266     273     266
   q15  629     547     540     540
   q16  562     509     538     509
   q17  2050    1813    1821    1813
   q18  8747    8380    8344    8344
   q19  1762    1687    1682    1682
   q20  2291    1992    1978    1978
   q21  5701    5241    5304    5241
   q22  567     479     491     479
   Total cold run time: 63786 ms
   Total hot run time: 60183 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