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

   
   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 f9b20166a42680d6b03bee135332ce926863928e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5529    5178    5130    5130
   q2   382     170     153     153
   q3   1462    1156    1258    1156
   q4   1092    882     835     835
   q5   3152    3133    3020    3020
   q6   225     132     133     132
   q7   1002    557     509     509
   q8   2129    2246    2252    2246
   q9   6699    6668    6650    6650
   q10  3150    3120    3152    3120
   q11  330     219     212     212
   q12  387     237     235     235
   q13  4422    3667    3604    3604
   q14  255     214     220     214
   q15  609     563     536     536
   q16  465     407     432     407
   q17  1038    536     522     522
   q18  7065    6720    6772    6720
   q19  1631    1491    1415    1415
   q20  597     382     333     333
   q21  2900    2443    2430    2430
   q22  399     312     334     312
   Total cold run time: 44920 ms
   Total hot run time: 39891 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5123    5044    5091    5044
   q2   330     268     245     245
   q3   3362    3320    3268    3268
   q4   2144    2033    2007    2007
   q5   5965    5913    5961    5913
   q6   226     127     127     127
   q7   2397    1914    1941    1914
   q8   3543    3649    3662    3649
   q9   9035    9014    8916    8916
   q10  3867    3923    3919    3919
   q11  584     497     490     490
   q12  848     640     612     612
   q13  3833    3193    3192    3192
   q14  299     283     276     276
   q15  613     551     552     551
   q16  533     497     505     497
   q17  2033    1814    1794    1794
   q18  8756    8255    8329    8255
   q19  1737    1673    1698    1673
   q20  2281    1993    1981    1981
   q21  5628    5329    5227    5227
   q22  558     508     504     504
   Total cold run time: 63695 ms
   Total hot run time: 60054 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