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

   
   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 896677feb939b470a4c47246b6f7624aa4381f58, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5412    5144    5111    5111
   q2   386     167     160     160
   q3   1476    1191    1086    1086
   q4   1076    839     825     825
   q5   3212    3153    3156    3153
   q6   221     131     133     131
   q7   984     574     511     511
   q8   2168    2283    2258    2258
   q9   6697    6660    6650    6650
   q10  3164    3121    3164    3121
   q11  332     236     213     213
   q12  384     234     236     234
   q13  4400    3609    3676    3609
   q14  262     218     220     218
   q15  579     539     520     520
   q16  448     420     400     400
   q17  1067    526     514     514
   q18  7040    6741    6818    6741
   q19  1647    1501    1474    1474
   q20  558     342     368     342
   q21  2937    2520    2596    2520
   q22  396     331     319     319
   Total cold run time: 44846 ms
   Total hot run time: 40110 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5110    5096    5028    5028
   q2   339     230     242     230
   q3   3356    3341    3352    3341
   q4   2167    2057    2042    2042
   q5   5949    5928    5932    5928
   q6   232     125     129     125
   q7   2401    1889    1946    1889
   q8   3580    3672    3685    3672
   q9   9080    8953    9029    8953
   q10  3877    3921    3915    3915
   q11  583     484     499     484
   q12  813     662     624     624
   q13  3879    3214    3212    3212
   q14  317     265     283     265
   q15  601     525     536     525
   q16  544     484     495     484
   q17  2073    1822    1843    1822
   q18  8733    8340    8429    8340
   q19  1744    1709    1677    1677
   q20  2258    1981    1954    1954
   q21  5791    5299    5250    5250
   q22  577     470     492     470
   Total cold run time: 64004 ms
   Total hot run time: 60230 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