Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-31 Thread via GitHub


Jibing-Li commented on PR #42983:
URL: https://github.com/apache/doris/pull/42983#issuecomment-2449604326

   run p0


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



Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-31 Thread via GitHub


Jibing-Li merged PR #42983:
URL: https://github.com/apache/doris/pull/42983


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



Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-31 Thread via GitHub


Jibing-Li commented on PR #42983:
URL: https://github.com/apache/doris/pull/42983#issuecomment-2449568999

   run p0


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



Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-31 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.47 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit c8d93b4ddb08b5a8933d2a16126240d67f709020, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.030.03
   query3   0.230.060.06
   query4   1.650.100.10
   query5   0.430.410.40
   query6   1.160.660.65
   query7   0.020.010.01
   query8   0.030.030.02
   query9   0.560.500.50
   query10  0.540.550.54
   query11  0.140.100.12
   query12  0.140.120.10
   query13  0.600.600.60
   query14  2.722.852.73
   query15  0.920.830.83
   query16  0.400.380.39
   query17  1.031.031.00
   query18  0.190.190.20
   query19  1.861.811.93
   query20  0.010.010.01
   query21  15.36   0.580.59
   query22  2.292.902.01
   query23  17.05   0.920.84
   query24  3.160.790.66
   query25  0.340.130.12
   query26  0.350.150.14
   query27  0.040.050.05
   query28  11.17   1.091.07
   query29  12.54   3.283.27
   query30  0.240.060.05
   query31  2.890.380.38
   query32  3.300.460.46
   query33  2.953.093.04
   query34  16.99   4.474.45
   query35  4.564.494.48
   query36  0.670.480.48
   query37  0.080.060.05
   query38  0.050.040.04
   query39  0.040.020.02
   query40  0.150.120.12
   query41  0.080.020.03
   query42  0.050.020.02
   query43  0.030.030.03
   Total cold run time: 107.11 s
   Total hot run time: 32.47 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-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



Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-31 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197016 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit c8d93b4ddb08b5a8933d2a16126240d67f709020, 
data reload: false
   
   query1   1202918 904 904
   query2   6262207720882077
   query3   10817   404540094009
   query4   67856   29518   23771   23771
   query5   4953449 445 445
   query6   410 181 177 177
   query7   5575298 297 297
   query8   313 242 230 230
   query9   9022274927372737
   query10  432 273 253 253
   query11  17381   15381   15888   15381
   query12  157 109 101 101
   query13  1560439 414 414
   query14  9919717173407171
   query15  206 193 185 185
   query16  7043464 472 464
   query17  1000553 571 553
   query18  1764297 297 297
   query19  190 154 152 152
   query20  116 110 113 110
   query21  209 98  104 98
   query22  4636446543044304
   query23  34631   33844   34108   33844
   query24  6032274227702742
   query25  500 403 395 395
   query26  647 159 157 157
   query27  1675283 292 283
   query28  4254246224562456
   query29  680 430 430 430
   query30  237 163 159 159
   query31  998 763 801 763
   query32  65  53  57  53
   query33  440 272 271 271
   query34  911 534 520 520
   query35  880 756 747 747
   query36  1083936 951 936
   query37  120 73  72  72
   query38  4390425442884254
   query39  1461146314271427
   query40  284 102 100 100
   query41  46  46  44  44
   query42  106 99  99  99
   query43  535 499 503 499
   query44  1163842 840 840
   query45  182 164 164 164
   query46  1103711 713 711
   query47  2003184619051846
   query48  434 316 327 316
   query49  731 427 406 406
   query50  811 407 417 407
   query51  7299706270967062
   query52  102 87  88  87
   query53  254 180 185 180
   query54  547 387 399 387
   query55  78  76  76  76
   query56  245 228 236 228
   query57  1313118411461146
   query58  216 200 211 200
   query59  3149329031673167
   query60  267 241 244 241
   query61  98  97  96  96
   query62  789 676 655 655
   query63  214 186 183 183
   query64  1331607 586 586
   query65  3292325332273227
   query66  708 333 325 325
   query67  15969   16061   15877   15877
   query68  3825595 593 593
   query69  432 256 254 254
   query70  1233115611621156
   query71  357 252 264 252
   query72  6233397739643964
   query73  758 367 359 359
   query74  10045   913090729072
   query75  3402267026872670
   query76  1879106610891066
   query77  472 284 272 272
   query78  10441   955193829382
   query79  2077604 606 604
   query80  1369413 424 413
   query81  535 237 241 237
   query82  1201111 111 111
   query83  212 142 136 136
   query84  282 75  71  71
   query85  995 283 270 270
   query86  415 304 302 302
   query87  4942468147434681
   query88  3560221621682168
   query89  418 295 284 284
   query90  1943186 185 185
   query91  134 99  95  95
   query92  62  53  49  49
   query93  2721565 556 556
   query94  861 284 285 284
   query95  348 247 249 247
   query96  628 279 291 279
   query97  2963270426872687
   query98  212 198 203 198
   query99  1589133213251325
   Total cold run time: 319840 ms
   Total hot run time: 197016 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 t

Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-31 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41781 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit c8d93b4ddb08b5a8933d2a16126240d67f709020, 
data reload: false
   
   -- Round 1 --
   q1   17834   770073437343
   q2   2037169 164 164
   q3   10651   110712001107
   q4   10552   874 909 874
   q5   7762308630963086
   q6   245 151 144 144
   q7   1017612 611 611
   q8   9364198220381982
   q9   6587648965406489
   q10  7105249124902490
   q11  458 254 251 251
   q12  411 216 218 216
   q13  17768   301929952995
   q14  253 222 208 208
   q15  581 530 513 513
   q16  649 597 588 588
   q17  974 589 569 569
   q18  7434678267546754
   q19  1326104510101010
   q20  494 186 183 183
   q21  4023318533383185
   q22  1124101910281019
   Total cold run time: 108649 ms
   Total hot run time: 41781 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7276727672967276
   q2   323 220 221 220
   q3   3113297629602960
   q4   2169188117821782
   q5   5750574258415742
   q6   224 142 139 139
   q7   2264181918001800
   q8   3405352435733524
   q9   9010898389788978
   q10  3617357535893575
   q11  588 491 505 491
   q12  801 613 591 591
   q13  8978322531723172
   q14  330 286 280 280
   q15  569 536 536 536
   q16  692 639 624 624
   q17  1860165616001600
   q18  8299785176887688
   q19  1756161315341534
   q20  2135185519101855
   q21  5619539854745398
   q22  1130105610351035
   Total cold run time: 69908 ms
   Total hot run time: 60800 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



Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-30 Thread via GitHub


Jibing-Li commented on PR #42983:
URL: https://github.com/apache/doris/pull/42983#issuecomment-2449096793

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



Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-30 Thread via GitHub


github-actions[bot] commented on PR #42983:
URL: https://github.com/apache/doris/pull/42983#issuecomment-2449098993

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



Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-30 Thread via GitHub


github-actions[bot] commented on PR #42983:
URL: https://github.com/apache/doris/pull/42983#issuecomment-2449098969

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



Re: [PR] [improvement](statistics)Improve statisitcs insert into audit log. [doris]

2024-10-30 Thread via GitHub


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

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