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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 31237 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 25af7336f03e81a60af146dbf98c2b43d0c01085, 
data reload: false
   
   ------ Round 1 ----------------------------------
   q1   17600   5367    5052    5052
   q2   2050    309     165     165
   q3   10405   1294    707     707
   q4   10211   990     516     516
   q5   7534    2447    2271    2271
   q6   193     174     133     133
   q7   906     764     607     607
   q8   9293    1328    1109    1109
   q9   4917    4570    4631    4570
   q10  6818    2317    1882    1882
   q11  494     274     263     263
   q12  346     352     227     227
   q13  17763   3622    3045    3045
   q14  239     226     203     203
   q15  516     467     456     456
   q16  628     609     590     590
   q17  587     856     328     328
   q18  6799    6258    6140    6140
   q19  1356    942     545     545
   q20  305     322     195     195
   q21  2746    2157    1937    1937
   q22  368     324     296     296
   Total cold run time: 102074 ms
   Total hot run time: 31237 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   workload_group                       0
   ============================================
   show table status;
   Name Engine  Version Row_format      Rows    Avg_row_length  Data_length     
Max_data_length Index_length    Data_free       Auto_increment  Create_time     
Update_time     Check_time      Collation       Checksum        Create_options  
Comment
   customer     Doris   NULL    NULL    15000000        92      1381653732      
NULL    NULL    NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:43     
NULL    utf-8   NULL    NULL    
   lineitem     Doris   NULL    NULL    600037902       33      19843441616     
NULL    NULL    NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:38:59     
NULL    utf-8   NULL    NULL    
   nation       Doris   NULL    NULL    25      138     3473    NULL    NULL    
NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:24     NULL    utf-8   
NULL    NULL    
   orders       Doris   NULL    NULL    150000000       42      6422171781      
NULL    NULL    NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:42:55     
NULL    utf-8   NULL    NULL    
   part Doris   NULL    NULL    20000000        37      748811035       NULL    
NULL    NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:57     NULL    
utf-8   NULL    NULL    
   partsupp     Doris   NULL    NULL    80000000        56      4534120086      
NULL    NULL    NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:44:20     
NULL    utf-8   NULL    NULL    
   region       Doris   NULL    NULL    5       240     1201    NULL    NULL    
NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:24     NULL    utf-8   
NULL    NULL    
   revenue0     View    NULL    NULL    -1      0       0       NULL    NULL    
NULL    NULL    2023-12-26 18:27:24     NULL    NULL    utf-8   NULL    NULL    
   supplier     Doris   NULL    NULL    1000000 87      87519212        NULL    
NULL    NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:25     NULL    
utf-8   NULL    NULL    
   ============================================
   q1   5105    5505    5101    5101
   q2   238     337     231     231
   q3   2142    2641    2259    2259
   q4   1427    1814    1376    1376
   q5   4197    4133    4143    4133
   q6   202     163     122     122
   q7   1858    1821    1651    1651
   q8   2651    2702    2510    2510
   q9   7266    q10     q11     q12     q13     q14     q15     q16     q17     
q18     q19     q20     q21     q22     Total cold run time: 17820 ms
   Total hot run time: 17383 ms
   ```
   </details>
   


-- 
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