You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "HHoflittlefish777 (via GitHub)" <gi...@apache.org> on 2024/02/22 08:51:04 UTC

[PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

HHoflittlefish777 opened a new pull request, #31279:
URL: https://github.com/apache/doris/pull/31279

   ## Proposed changes
   
   The properties totalTaskExcutionTimeMs is far more than actual, which make load rate is too low than actual.
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1958994836

   PR approved by anyone and no changes requested.


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959014719

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41404 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 c4cdafb836357153f495f0fcf737ab7fa8454cd2, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17611	5087	4959	4959
   q2	2044	139	141	139
   q3	11122	1034	1016	1016
   q4	4652	970	985	970
   q5	7601	3148	3196	3148
   q6	194	140	136	136
   q7	1263	798	769	769
   q8	9247	2092	2068	2068
   q9	7475	6661	6604	6604
   q10	8332	2668	2645	2645
   q11	408	220	206	206
   q12	779	330	343	330
   q13	17940	3612	3608	3608
   q14	292	263	261	261
   q15	609	540	503	503
   q16	483	405	413	405
   q17	928	892	859	859
   q18	7277	6693	6705	6693
   q19	1536	1495	1493	1493
   q20	482	273	277	273
   q21	6455	4045	3992	3992
   q22	674	327	339	327
   Total cold run time: 107404 ms
   Total hot run time: 41404 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4971	4974	5031	4974
   q2	298	185	184	184
   q3	3644	3627	3620	3620
   q4	2583	2564	2593	2564
   q5	5803	5788	5774	5774
   q6	217	131	133	131
   q7	2287	1669	1670	1669
   q8	3050	3136	3091	3091
   q9	8737	8743	8748	8743
   q10	5166	4267	4252	4252
   q11	540	367	419	367
   q12	795	555	554	554
   q13	4195	3445	3452	3445
   q14	256	251	248	248
   q15	601	503	508	503
   q16	481	440	472	440
   q17	1703	1621	1646	1621
   q18	8313	7814	7815	7814
   q19	1630	1649	1632	1632
   q20	2134	1845	1858	1845
   q21	6658	6238	6326	6238
   q22	569	543	510	510
   Total cold run time: 64631 ms
   Total hot run time: 60219 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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959042775

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.96 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit c4cdafb836357153f495f0fcf737ab7fa8454cd2, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.06	0.02	0.03
   query3	0.23	0.07	0.07
   query4	1.65	0.08	0.08
   query5	0.49	0.49	0.49
   query6	1.37	0.61	0.62
   query7	0.02	0.01	0.02
   query8	0.04	0.02	0.03
   query9	0.53	0.45	0.46
   query10	0.51	0.48	0.50
   query11	0.12	0.10	0.09
   query12	0.12	0.10	0.11
   query13	0.59	0.60	0.59
   query14	0.76	0.78	0.78
   query15	0.83	0.80	0.80
   query16	0.33	0.33	0.34
   query17	0.93	0.93	0.93
   query18	0.19	0.18	0.15
   query19	1.83	1.75	1.70
   query20	0.02	0.01	0.02
   query21	15.41	0.66	0.59
   query22	2.87	4.63	2.21
   query23	17.48	1.14	1.00
   query24	2.09	0.48	0.37
   query25	0.61	0.08	0.05
   query26	0.18	0.14	0.14
   query27	0.06	0.06	0.05
   query28	11.98	0.83	0.80
   query29	12.61	3.31	3.39
   query30	0.51	0.49	0.48
   query31	2.77	0.36	0.38
   query32	3.33	0.47	0.48
   query33	3.14	3.18	3.18
   query34	15.34	4.50	4.52
   query35	4.53	4.51	4.51
   query36	1.08	0.96	0.95
   query37	0.07	0.04	0.05
   query38	0.04	0.02	0.02
   query39	0.02	0.02	0.02
   query40	0.17	0.14	0.14
   query41	0.07	0.02	0.01
   query42	0.02	0.02	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 105.05 s
   Total hot run time: 30.96 s
   ```
   </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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959048090

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit c4cdafb836357153f495f0fcf737ab7fa8454cd2 with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:       13.5 seconds inserted 10000000 Rows, about 740K ops/s
   ```
   


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959126079

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit a3e3be022ee39f0824dc34da061abff405947317 with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       13.5 seconds inserted 10000000 Rows, about 740K ops/s
   ```
   


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "HHoflittlefish777 (via GitHub)" <gi...@apache.org>.
HHoflittlefish777 commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959049301

   run buildall


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1958973992

   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959088772

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41289 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 a3e3be022ee39f0824dc34da061abff405947317, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17591	4996	4853	4853
   q2	2050	138	133	133
   q3	11224	1049	1028	1028
   q4	5284	1013	1046	1013
   q5	7953	3235	3288	3235
   q6	204	137	140	137
   q7	1281	806	792	792
   q8	9599	2087	2047	2047
   q9	7431	6640	6582	6582
   q10	8300	2635	2649	2635
   q11	421	220	209	209
   q12	732	325	324	324
   q13	17914	3631	3608	3608
   q14	296	262	263	262
   q15	587	509	504	504
   q16	485	417	405	405
   q17	927	872	828	828
   q18	7286	6703	6689	6689
   q19	1542	1497	1493	1493
   q20	473	293	268	268
   q21	5926	3962	3924	3924
   q22	786	338	320	320
   Total cold run time: 108292 ms
   Total hot run time: 41289 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4867	4880	4850	4850
   q2	295	180	184	180
   q3	3615	3579	3568	3568
   q4	2525	2552	2506	2506
   q5	5754	5721	5722	5721
   q6	215	130	125	125
   q7	2237	1667	1652	1652
   q8	3009	3061	3119	3061
   q9	8719	8674	8690	8674
   q10	6235	4234	4225	4225
   q11	520	380	368	368
   q12	768	546	541	541
   q13	4212	3384	3413	3384
   q14	276	239	253	239
   q15	585	507	505	505
   q16	474	438	444	438
   q17	1675	1601	1613	1601
   q18	8301	7685	7578	7578
   q19	1622	1633	1636	1633
   q20	2113	1828	1829	1828
   q21	6563	6188	6135	6135
   q22	570	503	510	503
   Total cold run time: 65150 ms
   Total hot run time: 59315 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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959323135

   PR approved by at least one committer and no changes requested.


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "HHoflittlefish777 (via GitHub)" <gi...@apache.org>.
HHoflittlefish777 commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959054513

   run buildall


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "liaoxin01 (via GitHub)" <gi...@apache.org>.
liaoxin01 merged PR #31279:
URL: https://github.com/apache/doris/pull/31279


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959033701

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 177033 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit c4cdafb836357153f495f0fcf737ab7fa8454cd2, data reload: false
   
   query1	925	357	347	347
   query2	6497	1759	1728	1728
   query3	6698	206	204	204
   query4	23191	21428	21140	21140
   query5	4266	385	384	384
   query6	268	168	165	165
   query7	4603	297	303	297
   query8	244	197	206	197
   query9	8432	2869	2868	2868
   query10	418	232	227	227
   query11	15004	14729	14566	14566
   query12	138	85	85	85
   query13	1670	427	413	413
   query14	9112	7851	7849	7849
   query15	217	181	189	181
   query16	7507	248	243	243
   query17	1417	561	541	541
   query18	1948	272	264	264
   query19	196	149	153	149
   query20	86	82	82	82
   query21	186	124	128	124
   query22	4881	4634	4713	4634
   query23	32497	31743	31480	31480
   query24	12787	3459	3418	3418
   query25	655	361	362	361
   query26	1868	159	162	159
   query27	3039	318	314	314
   query28	6664	1861	1857	1857
   query29	1115	664	640	640
   query30	280	138	146	138
   query31	948	746	754	746
   query32	94	60	60	60
   query33	717	236	224	224
   query34	1095	498	501	498
   query35	941	862	836	836
   query36	1020	876	896	876
   query37	136	63	60	60
   query38	3284	3169	3187	3169
   query39	1383	1323	1314	1314
   query40	285	105	103	103
   query41	38	33	34	33
   query42	105	101	100	100
   query43	469	435	445	435
   query44	1071	681	705	681
   query45	198	183	174	174
   query46	1030	793	795	793
   query47	1619	1587	1643	1587
   query48	423	354	341	341
   query49	1221	319	330	319
   query50	772	377	377	377
   query51	4449	4299	4283	4283
   query52	110	98	97	97
   query53	404	325	316	316
   query54	294	219	236	219
   query55	84	80	83	80
   query56	227	202	204	202
   query57	1039	954	920	920
   query58	209	198	197	197
   query59	2295	2125	2084	2084
   query60	245	224	215	215
   query61	83	83	86	83
   query62	600	375	379	375
   query63	353	313	313	313
   query64	6410	3101	3109	3101
   query65	3301	3278	3261	3261
   query66	1344	327	324	324
   query67	14520	14010	14030	14010
   query68	5085	534	544	534
   query69	507	358	364	358
   query70	1271	1194	1244	1194
   query71	324	264	250	250
   query72	6343	2813	2625	2625
   query73	711	310	309	309
   query74	6867	6470	6412	6412
   query75	3187	2620	2550	2550
   query76	3182	1146	1198	1146
   query77	348	244	237	237
   query78	9447	8855	8842	8842
   query79	999	514	515	514
   query80	529	344	349	344
   query81	435	205	206	205
   query82	161	89	88	88
   query83	143	128	123	123
   query84	229	78	79	78
   query85	950	351	340	340
   query86	292	303	310	303
   query87	3469	3275	3299	3275
   query88	2681	2293	2267	2267
   query89	459	372	370	370
   query90	1981	167	163	163
   query91	151	123	129	123
   query92	55	51	53	51
   query93	1033	515	501	501
   query94	1157	177	177	177
   query95	441	338	341	338
   query96	570	263	262	262
   query97	4483	4303	4266	4266
   query98	228	211	202	202
   query99	1089	725	758	725
   Total cold run time: 268432 ms
   Total hot run time: 177033 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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959110560

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 176732 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit a3e3be022ee39f0824dc34da061abff405947317, data reload: false
   
   query1	907	345	347	345
   query2	6527	1787	1745	1745
   query3	6687	204	201	201
   query4	23282	21208	21138	21138
   query5	4259	379	371	371
   query6	255	179	171	171
   query7	4794	286	294	286
   query8	240	194	215	194
   query9	8459	2784	2775	2775
   query10	412	239	222	222
   query11	15062	14437	14606	14437
   query12	134	82	82	82
   query13	1690	410	429	410
   query14	8926	7590	7513	7513
   query15	211	183	190	183
   query16	7132	260	248	248
   query17	1420	534	524	524
   query18	2098	267	259	259
   query19	190	146	143	143
   query20	86	82	80	80
   query21	182	123	119	119
   query22	4997	4840	4880	4840
   query23	32475	31572	31465	31465
   query24	12884	3443	3479	3443
   query25	646	356	345	345
   query26	1872	150	155	150
   query27	3036	310	321	310
   query28	6507	1855	1843	1843
   query29	1235	613	616	613
   query30	276	135	148	135
   query31	963	740	746	740
   query32	96	58	57	57
   query33	711	225	226	225
   query34	1081	478	486	478
   query35	936	834	840	834
   query36	977	934	936	934
   query37	184	61	59	59
   query38	3331	3169	3133	3133
   query39	1382	1346	1327	1327
   query40	283	107	105	105
   query41	36	35	36	35
   query42	107	100	99	99
   query43	470	434	439	434
   query44	1077	678	695	678
   query45	194	183	173	173
   query46	1056	809	770	770
   query47	1636	1551	1555	1551
   query48	409	344	353	344
   query49	1218	302	301	301
   query50	776	375	367	367
   query51	4457	4381	4370	4370
   query52	109	94	96	94
   query53	391	301	298	298
   query54	283	215	222	215
   query55	85	76	79	76
   query56	221	204	193	193
   query57	1086	959	946	946
   query58	209	194	195	194
   query59	2259	2098	2143	2098
   query60	243	220	231	220
   query61	81	83	87	83
   query62	590	420	389	389
   query63	328	288	296	288
   query64	6210	3020	3106	3020
   query65	3294	3264	3237	3237
   query66	1382	333	314	314
   query67	14795	14271	14345	14271
   query68	5128	564	571	564
   query69	511	350	360	350
   query70	1333	1209	1308	1209
   query71	348	256	251	251
   query72	6288	2807	2618	2618
   query73	705	312	315	312
   query74	6836	6471	6475	6471
   query75	3215	2580	2551	2551
   query76	3271	1153	1217	1153
   query77	344	239	232	232
   query78	9392	8819	8843	8819
   query79	988	502	502	502
   query80	517	346	345	345
   query81	432	204	202	202
   query82	240	82	81	81
   query83	135	123	124	123
   query84	227	77	76	76
   query85	1028	341	330	330
   query86	284	310	310	310
   query87	3518	3295	3294	3294
   query88	2708	2287	2286	2286
   query89	436	356	353	353
   query90	2022	165	163	163
   query91	155	126	124	124
   query92	53	45	49	45
   query93	1020	514	510	510
   query94	1139	175	180	175
   query95	424	341	347	341
   query96	575	265	264	264
   query97	4445	4319	4258	4258
   query98	229	210	195	195
   query99	1081	773	685	685
   Total cold run time: 268854 ms
   Total hot run time: 176732 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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1959120380

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.45 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit a3e3be022ee39f0824dc34da061abff405947317, data reload: false
   
   query1	0.02	0.02	0.02
   query2	0.06	0.03	0.03
   query3	0.23	0.07	0.08
   query4	1.64	0.12	0.11
   query5	0.51	0.48	0.47
   query6	1.39	0.61	0.62
   query7	0.02	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.53	0.45	0.45
   query10	0.50	0.49	0.48
   query11	0.13	0.10	0.10
   query12	0.11	0.09	0.10
   query13	0.60	0.60	0.58
   query14	0.75	0.79	0.79
   query15	0.80	0.77	0.79
   query16	0.34	0.34	0.34
   query17	0.90	0.90	0.91
   query18	0.18	0.18	0.15
   query19	1.79	1.69	1.68
   query20	0.02	0.01	0.01
   query21	15.41	0.63	0.59
   query22	2.81	3.74	2.81
   query23	17.49	1.04	1.01
   query24	2.15	0.44	0.39
   query25	0.61	0.07	0.06
   query26	0.16	0.13	0.13
   query27	0.06	0.04	0.06
   query28	12.04	0.85	0.83
   query29	12.52	3.32	3.43
   query30	0.47	0.48	0.47
   query31	2.79	0.34	0.36
   query32	3.36	0.48	0.47
   query33	3.14	3.13	3.16
   query34	15.34	4.48	4.50
   query35	4.48	4.49	4.48
   query36	1.07	0.96	0.94
   query37	0.07	0.05	0.06
   query38	0.04	0.03	0.03
   query39	0.02	0.02	0.01
   query40	0.17	0.14	0.15
   query41	0.07	0.01	0.02
   query42	0.03	0.01	0.02
   query43	0.02	0.02	0.02
   Total cold run time: 104.88 s
   Total hot run time: 31.45 s
   ```
   </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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "HHoflittlefish777 (via GitHub)" <gi...@apache.org>.
HHoflittlefish777 commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1958976201

   run buildall


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](routine-load) fix total task exec time is far more than actual [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31279:
URL: https://github.com/apache/doris/pull/31279#issuecomment-1958994729

   PR approved by at least one committer and no changes requested.


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org