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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 32237 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 02b6c14f49dc2a4f27683dc5b7178f94c4fee0a4, 
data reload: false
   
   ------ Round 1 ----------------------------------
   q1   17578   5498    5384    5384
   q2   2055    302     174     174
   q3   10413   1199    726     726
   q4   10204   979     533     533
   q5   7540    2381    2138    2138
   q6   196     170     137     137
   q7   898     747     605     605
   q8   9251    1357    1183    1183
   q9   5129    4872    4894    4872
   q10  6852    2337    1871    1871
   q11  487     284     251     251
   q12  342     363     220     220
   q13  17750   3657    3149    3149
   q14  231     216     211     211
   q15  513     463     481     463
   q16  630     621     578     578
   q17  571     864     324     324
   q18  6886    6482    6427    6427
   q19  1906    948     519     519
   q20  301     316     188     188
   q21  2817    2157    1976    1976
   q22  376     342     308     308
   Total cold run time: 102926 ms
   Total hot run time: 32237 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   5516    5456    5490    5456
   q2   243     329     238     238
   q3   2230    2656    2318    2318
   q4   1431    1796    1345    1345
   q5   4314    4735    4665    4665
   q6   168     156     125     125
   q7   1976    1929    1812    1812
   q8   2652    2811    2845    2811
   q9   q10     q11     q12     q13     q14     q15     q16     q17     q18     
q19     q20     q21     q22     Total cold run time: 18530 ms
   Total hot run time: 18770 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