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

   
   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 a38aba72811db39597e5f5fbf2c7354a5f80fd0e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5648    5178    5163    5163
   q2   390     162     167     162
   q3   1467    1098    1147    1098
   q4   1091    821     800     800
   q5   3164    3125    3149    3125
   q6   222     135     135     135
   q7   965     553     518     518
   q8   2152    2184    2194    2184
   q9   6740    6678    6650    6650
   q10  3176    3173    3099    3099
   q11  333     232     225     225
   q12  376     230     242     230
   q13  4415    3659    3679    3659
   q14  255     229     219     219
   q15  580     530     530     530
   q16  451     408     410     408
   q17  1052    508     496     496
   q18  7102    6813    6688    6688
   q19  1631    1525    1471    1471
   q20  605     325     318     318
   q21  2910    2520    2465    2465
   q22  396     327     323     323
   Total cold run time: 45121 ms
   Total hot run time: 39966 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5191    5144    5137    5137
   q2   339     246     230     230
   q3   3358    3341    3313    3313
   q4   2161    2072    2019    2019
   q5   5947    5922    5930    5922
   q6   222     125     131     125
   q7   2373    1928    1959    1928
   q8   3550    3674    3688    3674
   q9   9040    8954    9077    8954
   q10  3860    3937    3913    3913
   q11  568     494     468     468
   q12  804     643     632     632
   q13  3880    3214    3173    3173
   q14  304     293     276     276
   q15  586     528     519     519
   q16  551     509     492     492
   q17  2042    1816    1819    1816
   q18  8811    8373    8383    8373
   q19  1733    1674    1646    1646
   q20  2290    1995    1954    1954
   q21  5736    5324    5272    5272
   q22  567     540     494     494
   Total cold run time: 63913 ms
   Total hot run time: 60330 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