You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zhiqiang-hhhh (via GitHub)" <gi...@apache.org> on 2024/03/27 11:47:33 UTC

[PR] [chore](log) print query id before logging profile in be.INFO [doris]

zhiqiang-hhhh opened a new pull request, #32915:
URL: https://github.com/apache/doris/pull/32915

   (no comment)


-- 
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] [chore](log) print query id before logging profile in be.INFO [doris]

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


-- 
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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.95 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 34beb8935268e133724eb30ba9a2f725c7aa7059, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.07	0.03	0.02
   query3	0.24	0.05	0.05
   query4	1.78	0.06	0.06
   query5	0.54	0.51	0.52
   query6	1.24	0.62	0.63
   query7	0.02	0.01	0.01
   query8	0.04	0.02	0.02
   query9	0.52	0.48	0.48
   query10	0.55	0.53	0.54
   query11	0.12	0.08	0.10
   query12	0.12	0.09	0.09
   query13	0.61	0.61	0.60
   query14	0.77	0.78	0.80
   query15	0.77	0.75	0.76
   query16	0.36	0.37	0.37
   query17	0.99	1.02	0.98
   query18	0.20	0.26	0.24
   query19	1.90	1.81	1.79
   query20	0.01	0.01	0.01
   query21	15.50	0.56	0.56
   query22	2.01	1.97	1.65
   query23	17.19	1.01	0.94
   query24	4.89	1.31	1.33
   query25	0.39	0.12	0.05
   query26	0.50	0.16	0.17
   query27	0.05	0.04	0.04
   query28	7.61	0.75	0.76
   query29	12.64	2.17	2.38
   query30	0.57	0.52	0.51
   query31	2.80	0.38	0.37
   query32	3.39	0.49	0.48
   query33	3.02	3.06	3.10
   query34	15.25	4.80	4.83
   query35	4.87	4.84	4.85
   query36	1.07	1.00	1.01
   query37	0.06	0.05	0.04
   query38	0.04	0.02	0.02
   query39	0.02	0.01	0.02
   query40	0.16	0.14	0.14
   query41	0.07	0.02	0.02
   query42	0.02	0.02	0.01
   query43	0.02	0.01	0.02
   Total cold run time: 103.02 s
   Total hot run time: 30.95 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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   TeamCity be ut coverage result:
    Function Coverage: 37.79% (8044/21285) 
    Line Coverage: 29.46% (65694/223016)
    Region Coverage: 28.92% (33803/116903)
    Branch Coverage: 24.77% (17354/70066)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/89b733b421f659a361d08424a598216426e0b9d0_89b733b421f659a361d08424a598216426e0b9d0/report/index.html


-- 
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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.6 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 89b733b421f659a361d08424a598216426e0b9d0, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.07	0.02	0.02
   query3	0.25	0.05	0.04
   query4	1.80	0.07	0.07
   query5	0.53	0.52	0.52
   query6	1.27	0.60	0.60
   query7	0.01	0.01	0.01
   query8	0.04	0.02	0.02
   query9	0.52	0.49	0.49
   query10	0.54	0.54	0.55
   query11	0.12	0.09	0.09
   query12	0.11	0.09	0.09
   query13	0.62	0.62	0.60
   query14	0.77	0.80	0.80
   query15	0.81	0.76	0.76
   query16	0.36	0.39	0.38
   query17	0.98	1.02	1.02
   query18	0.21	0.27	0.26
   query19	1.92	1.86	1.77
   query20	0.02	0.01	0.01
   query21	15.46	0.56	0.56
   query22	1.99	2.59	2.00
   query23	17.36	0.90	0.98
   query24	4.93	1.51	1.48
   query25	0.33	0.08	0.05
   query26	0.70	0.17	0.17
   query27	0.04	0.05	0.04
   query28	7.70	0.76	0.71
   query29	12.62	2.35	2.34
   query30	0.58	0.52	0.47
   query31	2.82	0.39	0.37
   query32	3.39	0.51	0.49
   query33	3.07	3.07	3.03
   query34	15.25	4.79	4.79
   query35	4.84	4.86	4.84
   query36	1.08	1.01	1.02
   query37	0.06	0.04	0.04
   query38	0.04	0.02	0.03
   query39	0.02	0.01	0.01
   query40	0.16	0.13	0.14
   query41	0.07	0.02	0.01
   query42	0.02	0.02	0.02
   query43	0.02	0.01	0.02
   Total cold run time: 103.53 s
   Total hot run time: 31.6 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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   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)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   TeamCity be ut coverage result:
    Function Coverage: 37.80% (8046/21285) 
    Line Coverage: 29.47% (65720/223016)
    Region Coverage: 28.93% (33819/116903)
    Branch Coverage: 24.78% (17363/70066)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/34beb8935268e133724eb30ba9a2f725c7aa7059_34beb8935268e133724eb30ba9a2f725c7aa7059/report/index.html


-- 
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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 49754 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 89b733b421f659a361d08424a598216426e0b9d0, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17955	4369	4361	4361
   q2	2032	154	138	138
   q3	10434	1920	1942	1920
   q4	10315	1271	1332	1271
   q5	8487	3950	3950	3950
   q6	219	123	124	123
   q7	2047	1600	1574	1574
   q8	9343	2703	2709	2703
   q9	10781	10527	10344	10344
   q10	8637	3536	3469	3469
   q11	412	230	240	230
   q12	464	303	301	301
   q13	18371	3991	4035	3991
   q14	364	326	320	320
   q15	506	459	463	459
   q16	689	602	588	588
   q17	1110	963	958	958
   q18	7249	6769	6874	6769
   q19	1655	1576	1573	1573
   q20	542	321	300	300
   q21	4485	4203	4030	4030
   q22	510	382	386	382
   Total cold run time: 116607 ms
   Total hot run time: 49754 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4313	4352	4310	4310
   q2	324	227	214	214
   q3	4162	4164	4179	4164
   q4	2766	2755	2746	2746
   q5	7272	7166	7206	7166
   q6	231	120	122	120
   q7	3270	2842	2893	2842
   q8	4339	4437	4499	4437
   q9	16980	16991	16989	16989
   q10	4236	4257	4295	4257
   q11	749	698	685	685
   q12	1026	849	833	833
   q13	6780	3758	3762	3758
   q14	463	419	418	418
   q15	492	459	448	448
   q16	771	705	706	705
   q17	3859	3880	3915	3880
   q18	8911	8764	8730	8730
   q19	1706	1689	1626	1626
   q20	2390	2105	2160	2105
   q21	8562	8559	8547	8547
   q22	1023	950	962	950
   Total cold run time: 84625 ms
   Total hot run time: 79930 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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   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] [chore](log) print query id before logging profile in be.INFO [doris]

Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei commented on code in PR #32915:
URL: https://github.com/apache/doris/pull/32915#discussion_r1540997023


##########
be/src/runtime/plan_fragment_executor.cpp:
##########
@@ -525,6 +525,8 @@ void PlanFragmentExecutor::close() {
 
         if (_is_report_success) {
             std::stringstream ss;
+            ss << "Query : " << print_id(this->_query_id) << " instance "

Review Comment:
   不要这样写
   把代码写到542 行跟随LOG(INFO)一起输出就可以了。



-- 
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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 201070 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 34beb8935268e133724eb30ba9a2f725c7aa7059, data reload: false
   
   query1	952	391	378	378
   query2	6537	2264	2142	2142
   query3	6920	197	200	197
   query4	20351	17884	17888	17884
   query5	19740	6511	6514	6511
   query6	290	210	224	210
   query7	4150	294	300	294
   query8	252	252	261	252
   query9	3154	2718	2646	2646
   query10	418	286	306	286
   query11	11258	10681	10662	10662
   query12	117	83	68	68
   query13	5580	638	623	623
   query14	17817	13512	13694	13512
   query15	367	227	242	227
   query16	6452	272	253	253
   query17	1582	1447	847	847
   query18	2308	404	395	395
   query19	222	139	144	139
   query20	77	78	75	75
   query21	191	93	90	90
   query22	5349	5097	5060	5060
   query23	32386	31792	31939	31792
   query24	6962	6510	6507	6507
   query25	528	421	408	408
   query26	526	159	156	156
   query27	1935	292	291	291
   query28	6156	2268	2224	2224
   query29	2847	2656	2714	2656
   query30	241	164	157	157
   query31	905	726	702	702
   query32	67	59	62	59
   query33	398	253	242	242
   query34	840	458	456	456
   query35	1147	941	947	941
   query36	1235	1253	1214	1214
   query37	89	64	58	58
   query38	3115	2929	2931	2929
   query39	1356	1318	1316	1316
   query40	209	90	97	90
   query41	39	36	31	31
   query42	79	80	82	80
   query43	635	618	625	618
   query44	1133	708	715	708
   query45	237	224	223	223
   query46	1235	972	979	972
   query47	1874	1889	1676	1676
   query48	1000	659	651	651
   query49	623	364	375	364
   query50	873	626	597	597
   query51	4748	4633	4673	4633
   query52	78	79	72	72
   query53	436	314	310	310
   query54	2672	2440	2466	2440
   query55	85	79	83	79
   query56	203	212	206	206
   query57	1145	1035	1196	1035
   query58	210	184	203	184
   query59	3482	3310	3249	3249
   query60	204	188	183	183
   query61	86	84	87	84
   query62	844	458	521	458
   query63	458	326	329	326
   query64	2397	1485	1334	1334
   query65	3604	3522	3554	3522
   query66	752	372	363	363
   query67	16089	15364	15804	15364
   query68	8365	646	673	646
   query69	574	319	338	319
   query70	1503	1472	1313	1313
   query71	403	300	302	300
   query72	6500	3447	3468	3447
   query73	741	312	313	312
   query74	6281	5820	5930	5820
   query75	4547	3683	3635	3635
   query76	4617	1148	1155	1148
   query77	606	244	249	244
   query78	12833	11649	12172	11649
   query79	8111	641	645	641
   query80	1316	396	389	389
   query81	497	230	229	229
   query82	1536	98	98	98
   query83	164	133	129	129
   query84	258	70	66	66
   query85	863	295	286	286
   query86	304	285	290	285
   query87	3307	2961	3039	2961
   query88	4750	2299	2311	2299
   query89	371	267	310	267
   query90	1853	210	219	210
   query91	149	117	119	117
   query92	55	50	51	50
   query93	5528	601	552	552
   query94	646	201	201	201
   query95	1119	1072	1050	1050
   query96	638	320	320	320
   query97	6431	6431	6364	6364
   query98	187	179	175	175
   query99	2928	881	837	837
   Total cold run time: 308228 ms
   Total hot run time: 201070 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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 34beb8935268e133724eb30ba9a2f725c7aa7059 with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
   Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       20.9 seconds inserted 10000000 Rows, about 478K 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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 202922 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 89b733b421f659a361d08424a598216426e0b9d0, data reload: false
   
   query1	940	393	389	389
   query2	6551	2171	2255	2171
   query3	6924	200	198	198
   query4	20627	18041	17935	17935
   query5	19734	6568	6484	6484
   query6	285	214	225	214
   query7	4163	285	293	285
   query8	266	273	231	231
   query9	3148	2704	2632	2632
   query10	413	280	307	280
   query11	11327	10728	10753	10728
   query12	122	73	71	71
   query13	5566	653	669	653
   query14	17184	13551	13579	13551
   query15	388	231	238	231
   query16	6460	283	260	260
   query17	1717	1453	860	860
   query18	2329	406	386	386
   query19	204	148	147	147
   query20	77	73	74	73
   query21	181	94	92	92
   query22	5289	5077	5025	5025
   query23	32536	31969	32048	31969
   query24	7009	6499	6548	6499
   query25	507	428	412	412
   query26	524	166	158	158
   query27	1898	290	300	290
   query28	6108	2249	2244	2244
   query29	2926	2643	2763	2643
   query30	239	159	160	159
   query31	886	732	746	732
   query32	65	61	55	55
   query33	378	253	248	248
   query34	841	476	482	476
   query35	1101	878	917	878
   query36	1351	1316	1248	1248
   query37	88	59	58	58
   query38	3100	2936	2885	2885
   query39	1360	1317	1310	1310
   query40	199	94	93	93
   query41	35	32	33	32
   query42	85	96	81	81
   query43	613	525	588	525
   query44	1143	708	716	708
   query45	245	226	231	226
   query46	1233	1000	969	969
   query47	1943	1811	1858	1811
   query48	971	665	660	660
   query49	615	353	372	353
   query50	863	621	573	573
   query51	4691	4739	4740	4739
   query52	98	75	87	75
   query53	437	323	315	315
   query54	2665	2419	2433	2419
   query55	104	79	87	79
   query56	216	199	191	191
   query57	1219	1161	1047	1047
   query58	212	192	186	186
   query59	3362	3446	3315	3315
   query60	204	192	198	192
   query61	82	80	85	80
   query62	786	464	508	464
   query63	471	332	336	332
   query64	2402	1474	1373	1373
   query65	3620	3570	3559	3559
   query66	767	366	372	366
   query67	15807	15637	14967	14967
   query68	10351	677	691	677
   query69	573	333	342	333
   query70	1905	1478	1465	1465
   query71	391	289	310	289
   query72	6447	3475	3452	3452
   query73	740	324	318	318
   query74	6289	5947	5766	5766
   query75	5377	3695	3780	3695
   query76	6893	1152	1216	1152
   query77	1189	247	250	247
   query78	12580	12901	13510	12901
   query79	10097	662	680	662
   query80	673	398	396	396
   query81	497	233	235	233
   query82	320	104	96	96
   query83	187	138	125	125
   query84	254	69	71	69
   query85	726	281	277	277
   query86	348	290	304	290
   query87	3278	3042	3026	3026
   query88	4998	2331	2329	2329
   query89	337	292	290	290
   query90	2567	217	212	212
   query91	152	117	117	117
   query92	54	50	53	50
   query93	3059	588	592	588
   query94	1170	209	204	204
   query95	1128	1093	1080	1080
   query96	637	326	325	325
   query97	6488	6356	6244	6244
   query98	181	178	171	171
   query99	2913	955	953	953
   Total cold run time: 312699 ms
   Total hot run time: 202922 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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 89b733b421f659a361d08424a598216426e0b9d0 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:       20.8 seconds inserted 10000000 Rows, about 480K 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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   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] [chore](log) print query id before logging profile in be.INFO [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 49844 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 34beb8935268e133724eb30ba9a2f725c7aa7059, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17936	4456	4394	4394
   q2	2028	153	147	147
   q3	10328	1887	1937	1887
   q4	10103	1242	1302	1242
   q5	8535	4011	3988	3988
   q6	235	122	121	121
   q7	1999	1580	1595	1580
   q8	9244	2723	2719	2719
   q9	11098	10840	10385	10385
   q10	8644	3506	3524	3506
   q11	416	243	237	237
   q12	460	296	293	293
   q13	18336	3981	4004	3981
   q14	346	323	329	323
   q15	504	457	452	452
   q16	703	590	580	580
   q17	1123	979	976	976
   q18	7298	6823	6894	6823
   q19	1702	1537	1455	1455
   q20	503	287	294	287
   q21	4412	4080	4144	4080
   q22	499	401	388	388
   Total cold run time: 116452 ms
   Total hot run time: 49844 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4389	4301	4297	4297
   q2	315	227	220	220
   q3	4160	4153	4137	4137
   q4	2720	2741	2729	2729
   q5	7286	7241	7190	7190
   q6	231	121	116	116
   q7	3204	2857	2800	2800
   q8	4313	4463	4473	4463
   q9	17635	17401	17079	17079
   q10	4260	4223	4306	4223
   q11	755	665	696	665
   q12	1014	824	866	824
   q13	6995	3758	3752	3752
   q14	462	426	428	426
   q15	501	450	458	450
   q16	750	686	697	686
   q17	3836	3814	3834	3814
   q18	8846	8777	8923	8777
   q19	1709	1695	1668	1668
   q20	2395	2143	2133	2133
   q21	8359	8353	8474	8353
   q22	1015	942	980	942
   Total cold run time: 85150 ms
   Total hot run time: 79744 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