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

   
   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 ac4a1b5ac5a01209719322d10ff88bdf1e9c06e1, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5542    5180    5121    5121
   q2   393     168     161     161
   q3   1453    1221    1168    1168
   q4   1091    783     757     757
   q5   3150    3071    3103    3071
   q6   227     138     136     136
   q7   980     563     530     530
   q8   2152    2194    2196    2194
   q9   6726    6673    6651    6651
   q10  3156    3050    3157    3050
   q11  342     220     210     210
   q12  383     240     244     240
   q13  4431    3711    3675    3675
   q14  248     218     220     218
   q15  579     539     520     520
   q16  463     408     405     405
   q17  1050    510     466     466
   q18  7122    6732    6776    6732
   q19  1652    1497    1629    1497
   q20  582     347     349     347
   q21  2904    2491    2454    2454
   q22  396     326     327     326
   Total cold run time: 45022 ms
   Total hot run time: 39929 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5170    5001    5074    5001
   q2   339     239     238     238
   q3   3374    3330    3317    3317
   q4   2163    2070    2006    2006
   q5   5945    5971    5935    5935
   q6   220     127     128     127
   q7   2365    1905    1936    1905
   q8   3574    3692    3683    3683
   q9   9077    8977    8988    8977
   q10  3839    3894    3906    3894
   q11  568     472     477     472
   q12  798     638     647     638
   q13  3879    3208    3208    3208
   q14  311     276     276     276
   q15  596     531     530     530
   q16  559     514     503     503
   q17  2024    1789    1829    1789
   q18  8725    8312    8359    8312
   q19  1759    1686    1686    1686
   q20  2256    1969    2001    1969
   q21  5736    5332    5253    5253
   q22  560     480     487     480
   Total cold run time: 63837 ms
   Total hot run time: 60199 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