Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


starocean999 merged PR #50998:
URL: https://github.com/apache/doris/pull/50998


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


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

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


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

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


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

   
   
   ClickBench: Total hot run time: 28.84 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 3c6a0c76f4c278e33f2115dfbeeaeecd3e58834d, 
data reload: false
   
   query1   0.040.030.03
   query2   0.140.110.11
   query3   0.250.190.20
   query4   1.590.200.18
   query5   0.450.430.44
   query6   1.170.660.65
   query7   0.020.010.02
   query8   0.040.030.03
   query9   0.580.510.54
   query10  0.560.570.57
   query11  0.150.110.11
   query12  0.150.120.12
   query13  0.630.600.59
   query14  0.780.780.82
   query15  0.870.860.86
   query16  0.380.380.39
   query17  1.041.001.04
   query18  0.220.210.20
   query19  1.881.841.92
   query20  0.020.010.01
   query21  15.39   0.890.57
   query22  0.781.160.78
   query23  14.79   1.410.63
   query24  7.110.870.48
   query25  0.460.220.07
   query26  0.580.170.15
   query27  0.050.060.05
   query28  9.490.930.42
   query29  12.58   4.033.31
   query30  0.260.100.06
   query31  2.810.590.38
   query32  3.240.550.46
   query33  3.063.093.13
   query34  15.81   5.054.52
   query35  4.534.544.47
   query36  0.660.480.48
   query37  0.090.070.06
   query38  0.060.040.04
   query39  0.030.020.02
   query40  0.160.130.12
   query41  0.080.030.03
   query42  0.030.030.02
   query43  0.040.030.03
   Total cold run time: 103.05 s
   Total hot run time: 28.84 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


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

   
   
   TPC-DS: Total hot run time: 190627 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 3c6a0c76f4c278e33f2115dfbeeaeecd3e58834d, 
data reload: false
   
   query1   1389111910631063
   query2   6423178718271787
   query3   10969   458544344434
   query4   53666   25703   23003   23003
   query5   5099571 468 468
   query6   342 194 189 189
   query7   4879518 296 296
   query8   313 256 240 240
   query9   5500265426342634
   query10  475 347 288 288
   query11  15188   15005   14810   14810
   query12  174 106 103 103
   query13  1016528 395 395
   query14  10207   634363036303
   query15  193 203 175 175
   query16  7026654 528 528
   query17  1120764 614 614
   query18  1582426 329 329
   query19  211 216 180 180
   query20  128 130 135 130
   query21  224 130 118 118
   query22  4301443944424439
   query23  34332   33709   33887   33709
   query24  6598250925292509
   query25  476 491 408 408
   query26  738 283 154 154
   query27  2426508 353 353
   query28  2913212121212121
   query29  581 596 448 448
   query30  286 224 194 194
   query31  862 842 766 766
   query32  71  68  67  67
   query33  480 362 312 312
   query34  805 867 568 568
   query35  782 844 744 744
   query36  987 980 913 913
   query37  115 103 72  72
   query38  4219425943024259
   query39  1515145314421442
   query40  211 131 115 115
   query41  58  57  52  52
   query42  140 112 110 110
   query43  509 506 483 483
   query44  1384858 864 858
   query45  179 180 167 167
   query46  872 1084643 643
   query47  1841185017941794
   query48  410 475 326 326
   query49  720 515 478 478
   query50  686 708 422 422
   query51  4253425042684250
   query52  114 111 103 103
   query53  236 274 188 188
   query54  607 609 520 520
   query55  94  89  89  89
   query56  296 296 308 296
   query57  1190120011311131
   query58  261 276 274 274
   query59  2676278825262526
   query60  378 328 323 323
   query61  142 126 125 125
   query62  741 752 678 678
   query63  229 192 201 192
   query64  20601046700 700
   query65  4296423642644236
   query66  786 392 319 319
   query67  16317   15567   15626   15567
   query68  7304896 531 531
   query69  535 372 277 277
   query70  1202115511031103
   query71  511 319 308 308
   query72  5887234751092347
   query73  1569764 361 361
   query74  8969910689708970
   query75  3979321926692669
   query76  41921195765 765
   query77  692 362 276 276
   query78  10295   10099   93319331
   query79  2601857 594 594
   query80  690 511 452 452
   query81  491 258 225 225
   query82  539 130 99  99
   query83  250 250 240 240
   query84  296 115 88  88
   query85  798 367 313 313
   query86  364 298 295 295
   query87  4466442542754275
   query88  3507230623042304
   query89  409 330 284 284
   query90  1800212 209 209
   query91  146 141 113 113
   query92  75  66  57  57
   query93  2227945 585 585
   query94  670 419 303 303
   query95  379 300 292 292
   query96  497 572 279 279
   query97  2717280226552655
   query98  234 202 193 193
   query99  1578140813041304
   Total cold run time: 300166 ms
   Total hot run time: 190627 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

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


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

   
   
   TPC-H: Total hot run time: 33354 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 3c6a0c76f4c278e33f2115dfbeeaeecd3e58834d, 
data reload: false
   
   -- Round 1 --
   q1   26379   501749654965
   q2   2072268 180 180
   q3   10406   1220676 676
   q4   10226   974 524 524
   q5   7531230423252304
   q6   174 159 131 131
   q7   909 718 605 605
   q8   9322128410481048
   q9   6942505450515051
   q10  6862232318951895
   q11  481 287 270 270
   q12  342 355 207 207
   q13  17773   367630663066
   q14  232 236 212 212
   q15  529 480 495 480
   q16  411 437 372 372
   q17  599 845 352 352
   q18  7439706269956995
   q19  1555943 550 550
   q20  352 348 221 221
   q21  3658260023022302
   q22  10491023948 948
   Total cold run time: 115243 ms
   Total hot run time: 33354 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5162505854215058
   q2   240 348 245 245
   q3   2153267823372337
   q4   1396182813701370
   q5   4350435543754355
   q6   213 190 131 131
   q7   2027188618061806
   q8   2605252924652465
   q9   7272715569496949
   q10  3049318527602760
   q11  583 509 500 500
   q12  692 759 609 609
   q13  3507388933213321
   q14  285 305 280 280
   q15  544 488 468 468
   q16  442 494 426 426
   q17  1135146214031403
   q18  7707756774457445
   q19  781 826 867 826
   q20  2025197918431843
   q21  4809443544564435
   q22  1098103810181018
   Total cold run time: 52075 ms
   Total hot run time: 50050 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


xiedeyantu commented on PR #50998:
URL: https://github.com/apache/doris/pull/50998#issuecomment-2892688448

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


xiedeyantu commented on PR #50998:
URL: https://github.com/apache/doris/pull/50998#issuecomment-2892683285

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


starocean999 commented on code in PR #50998:
URL: https://github.com/apache/doris/pull/50998#discussion_r2096711626


##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowQueryStatsCommand.java:
##
@@ -0,0 +1,211 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.DatabaseIf;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.common.UserException;
+import org.apache.doris.common.util.Util;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.commands.info.TableNameInfo;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.ShowResultSetMetaData;
+import org.apache.doris.qe.StmtExecutor;
+import org.apache.doris.statistics.query.QueryStatsUtil;
+
+import com.google.common.base.Preconditions;
+import com.google.common.base.Strings;
+import org.apache.commons.lang3.StringUtils;
+
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * The command for show query stats
+ */
+public class ShowQueryStatsCommand extends ShowCommand {
+private static final ShowResultSetMetaData 
SHOW_QUERY_STATS_CATALOG_META_DATA = ShowResultSetMetaData.builder()
+.addColumn(new Column("Database", ScalarType.createVarchar(20)))
+.addColumn(new Column("QueryCount", 
ScalarType.createVarchar(30))).build();
+private static final ShowResultSetMetaData 
SHOW_QUERY_STATS_DATABASE_META_DATA = ShowResultSetMetaData.builder()
+.addColumn(new Column("TableName", ScalarType.createVarchar(20)))
+.addColumn(new Column("QueryCount", 
ScalarType.createVarchar(30))).build();
+private static final ShowResultSetMetaData 
SHOW_QUERY_STATS_TABLE_META_DATA = ShowResultSetMetaData.builder()
+.addColumn(new Column("Field", ScalarType.createVarchar(20)))
+.addColumn(new Column("QueryCount", ScalarType.createVarchar(30)))
+.addColumn(new Column("FilterCount", 
ScalarType.createVarchar(30))).build();
+private static final ShowResultSetMetaData 
SHOW_QUERY_STATS_TABLE_ALL_META_DATA = ShowResultSetMetaData.builder()
+.addColumn(new Column("IndexName", ScalarType.createVarchar(20)))
+.addColumn(new Column("QueryCount", 
ScalarType.createVarchar(30))).build();
+private static final ShowResultSetMetaData 
SHOW_QUERY_STATS_TABLE_ALL_VERBOSE_META_DATA
+= ShowResultSetMetaData.builder().addColumn(new 
Column("IndexName", ScalarType.createVarchar(20)))
+.addColumn(new Column("Field", ScalarType.createVarchar(20)))
+.addColumn(new Column("QueryCount", ScalarType.createVarchar(30)))
+.addColumn(new Column("FilterCount", 
ScalarType.createVarchar(30))).build();
+
+TableNameInfo tableNameInfo;
+String dbName;
+boolean all;
+boolean verbose;
+List> totalRows = new ArrayList<>();
+ShowQueryStatsType type;
+
+public ShowQueryStatsCommand(String dbName, TableNameInfo tableNameInfo, 
boolean all, boolean verbose) {
+super(PlanType.SHOW_QUERY_STATS_COMMAND);
+this.dbName = dbName;
+this.tableNameInfo = tableNameInfo;
+this.all = all;
+this.verbose = verbose;
+}
+
+/**
+ * validate
+ */
+public void validate(ConnectContext ctx) throws UserException {
+if (StringUtils.isEmpty(dbName)) {
+dbName = ctx.getDatabase();
+type = ShowQueryStatsType.DATABASE;
+}
+if (Strings.isNullOrEmpty(dbName)) {

Review Comment:
   ```suggestion
   
   ```



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

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


xiedeyantu commented on PR #50998:
URL: https://github.com/apache/doris/pull/50998#issuecomment-2889327550

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


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

   
   
   ClickBench: Total hot run time: 29.59 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 0f4fd65f0c93992e0556cc2a41a2083d6d090e1a, 
data reload: false
   
   query1   0.040.040.03
   query2   0.120.100.11
   query3   0.240.190.20
   query4   1.600.180.20
   query5   0.450.440.43
   query6   1.540.670.67
   query7   0.020.020.01
   query8   0.050.030.03
   query9   0.570.520.50
   query10  0.570.570.56
   query11  0.170.110.10
   query12  0.140.120.11
   query13  0.620.600.60
   query14  0.810.800.80
   query15  0.870.840.84
   query16  0.400.390.38
   query17  1.011.071.06
   query18  0.220.210.22
   query19  1.901.801.82
   query20  0.020.010.01
   query21  15.40   0.870.54
   query22  0.741.330.98
   query23  14.70   1.400.66
   query24  6.981.631.06
   query25  0.550.140.24
   query26  0.650.160.14
   query27  0.050.050.06
   query28  9.900.890.43
   query29  12.90   4.003.29
   query30  0.240.090.07
   query31  2.820.610.38
   query32  3.230.560.46
   query33  3.013.033.08
   query34  15.55   5.134.48
   query35  4.534.514.50
   query36  0.670.490.47
   query37  0.080.060.06
   query38  0.050.030.04
   query39  0.030.030.02
   query40  0.170.140.12
   query41  0.080.030.02
   query42  0.030.030.02
   query43  0.030.040.03
   Total cold run time: 103.75 s
   Total hot run time: 29.59 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


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

   
   
   TPC-H: Total hot run time: 33839 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 0f4fd65f0c93992e0556cc2a41a2083d6d090e1a, 
data reload: false
   
   -- Round 1 --
   q1   25721   504250065006
   q2   2055269 180 180
   q3   10401   1222737 737
   q4   10232   1012527 527
   q5   7538236323182318
   q6   176 161 134 134
   q7   927 740 616 616
   q8   9314129710911091
   q9   6831505550595055
   q10  6871231319051905
   q11  488 296 276 276
   q12  359 354 217 217
   q13  1   374330883088
   q14  218 230 210 210
   q15  516 478 494 478
   q16  425 437 387 387
   q17  606 847 360 360
   q18  7517733871427142
   q19  27681510583 583
   q20  333 331 222 222
   q21  3735254123482348
   q22  1009966 959 959
   Total cold run time: 115817 ms
   Total hot run time: 33839 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5306508250665066
   q2   246 321 226 226
   q3   2184260422602260
   q4   1323176213271327
   q5   4475455843714371
   q6   219 173 125 125
   q7   1999192817731773
   q8   2619260224862486
   q9   7154710768686868
   q10  3039318828082808
   q11  573 520 483 483
   q12  688 767 609 609
   q13  3528387532503250
   q14  277 281 285 281
   q15  517 470 481 470
   q16  449 482 429 429
   q17  1178154713791379
   q18  7751767475697569
   q19  850 817 867 817
   q20  2007197518281828
   q21  4870448643364336
   q22  1101103110161016
   Total cold run time: 52353 ms
   Total hot run time: 49777 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


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

   
   
   TPC-DS: Total hot run time: 192979 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 0f4fd65f0c93992e0556cc2a41a2083d6d090e1a, 
data reload: false
   
   query1   1382110311001100
   query2   6199192719251925
   query3   11008   455144754475
   query4   54429   25978   22977   22977
   query5   5214516 462 462
   query6   386 194 198 194
   query7   5040511 291 291
   query8   306 251 232 232
   query9   6483264626572646
   query10  442 333 273 273
   query11  15054   15121   14953   14953
   query12  156 117 111 111
   query13  1149527 435 435
   query14  10199   635463826354
   query15  210 200 184 184
   query16  7090647 489 489
   query17  1091734 606 606
   query18  1532421 315 315
   query19  212 193 192 192
   query20  136 129 119 119
   query21  208 130 111 111
   query22  445244094409
   query23  34406   33509   9   9
   query24  6693240724452407
   query25  508 468 428 428
   query26  675 274 148 148
   query27  2188523 349 349
   query28  3217218721512151
   query29  595 559 430 430
   query30  276 218 189 189
   query31  862 890 800 800
   query32  75  67  61  61
   query33  455 374 336 336
   query34  937 857 552 552
   query35  821 853 770 770
   query36  985 1007932 932
   query37  112 105 81  81
   query38  4273426742754267
   query39  1523148914511451
   query40  220 124 115 115
   query41  59  52  55  52
   query42  139 108 118 108
   query43  527 530 496 496
   query44  1354857 856 856
   query45  187 170 164 164
   query46  868 1039669 669
   query47  1886188318151815
   query48  412 460 330 330
   query49  713 535 438 438
   query50  656 697 407 407
   query51  4265439642444244
   query52  120 120 103 103
   query53  231 257 193 193
   query54  595 595 535 535
   query55  88  90  91  90
   query56  354 327 298 298
   query57  1178118811211121
   query58  278 262 260 260
   query59  2830288127842784
   query60  338 325 310 310
   query61  125 121 126 121
   query62  752 740 696 696
   query63  238 196 192 192
   query64  15121024678 678
   query65  4348422542014201
   query66  709 403 306 306
   query67  15943   15535   15408   15408
   query68  7218896 529 529
   query69  543 306 271 271
   query70  1216110311001100
   query71  516 325 304 304
   query72  5972484450214844
   query73  1350682 359 359
   query74  8948907886168616
   query75  3817318326572657
   query76  41821187754 754
   query77  642 379 283 283
   query78  10090   10208   93659365
   query79  2494844 679 679
   query80  678 503 447 447
   query81  470 262 217 217
   query82  429 122 90  90
   query83  249 240 236 236
   query84  301 102 83  83
   query85  781 345 311 311
   query86  398 312 293 293
   query87  4478446943914391
   query88  3316240723822382
   query89  402 320 292 292
   query90  1782213 207 207
   query91  135 138 115 115
   query92  78  59  57  57
   query93  2188945 583 583
   query94  661 414 291 291
   query95  379 304 290 290
   query96  510 591 297 297
   query97  2731275225922592
   query98  235 216 204 204
   query99  1635138813061306
   Total cold run time: 300720 ms
   Total hot run time: 192979 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

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-19 Thread via GitHub 


xiedeyantu commented on PR #50998:
URL: https://github.com/apache/doris/pull/50998#issuecomment-2890853940

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-18 Thread via GitHub 


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

   
   
   ClickBench: Total hot run time: 28.66 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 8a09790e7c0484ea20470b1d8f32572e7425e5f6, 
data reload: false
   
   query1   0.040.040.04
   query2   0.130.110.10
   query3   0.240.190.20
   query4   1.590.200.20
   query5   0.450.470.46
   query6   1.190.680.65
   query7   0.020.010.02
   query8   0.040.030.04
   query9   0.580.500.53
   query10  0.560.580.55
   query11  0.150.110.10
   query12  0.150.110.11
   query13  0.620.590.60
   query14  0.800.820.81
   query15  0.880.840.87
   query16  0.390.380.38
   query17  1.081.041.01
   query18  0.220.210.21
   query19  1.931.771.81
   query20  0.010.010.01
   query21  15.40   0.880.52
   query22  0.761.360.76
   query23  14.80   1.410.59
   query24  6.741.500.50
   query25  0.530.240.08
   query26  0.570.160.13
   query27  0.050.050.06
   query28  9.660.950.47
   query29  12.57   3.943.28
   query30  0.250.090.07
   query31  2.820.590.39
   query32  3.230.550.47
   query33  3.043.113.04
   query34  15.81   5.164.46
   query35  4.494.584.50
   query36  0.670.490.48
   query37  0.080.070.06
   query38  0.050.040.03
   query39  0.030.020.03
   query40  0.160.150.13
   query41  0.090.030.02
   query42  0.040.030.02
   query43  0.030.030.03
   Total cold run time: 102.94 s
   Total hot run time: 28.66 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-18 Thread via GitHub 


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

   
   
   TPC-DS: Total hot run time: 193249 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 8a09790e7c0484ea20470b1d8f32572e7425e5f6, 
data reload: false
   
   query1   1424110410741074
   query2   6354182918471829
   query3   10972   457344074407
   query4   54687   25480   23038   23038
   query5   5023611 481 481
   query6   351 226 203 203
   query7   4886511 293 293
   query8   318 261 250 250
   query9   5476267126902671
   query10  474 347 278 278
   query11  15011   15003   14875   14875
   query12  161 113 114 113
   query13  1035527 434 434
   query14  10244   664165086508
   query15  214 198 175 175
   query16  7052659 500 500
   query17  1091766 636 636
   query18  1587389 302 302
   query19  199 188 172 172
   query20  133 141 123 123
   query21  206 131 109 109
   query22  4452449842964296
   query23  34410   33686   33639   33639
   query24  6543246524632463
   query25  507 481 414 414
   query26  733 275 155 155
   query27  2468513 361 361
   query28  3137218021712171
   query29  581 577 452 452
   query30  275 210 198 198
   query31  871 837 779 779
   query32  73  62  65  62
   query33  467 412 331 331
   query34  800 873 531 531
   query35  788 834 782 782
   query36  973 1011921 921
   query37  110 104 78  78
   query38  4207429441894189
   query39  1533147614561456
   query40  211 129 112 112
   query41  56  53  50  50
   query42  128 121 114 114
   query43  511 529 496 496
   query44  1412862 863 862
   query45  180 177 168 168
   query46  848 1045658 658
   query47  1820184918001800
   query48  409 438 345 345
   query49  695 546 433 433
   query50  697 720 424 424
   query51  4219430742924292
   query52  113 118 106 106
   query53  240 267 195 195
   query54  610 611 539 539
   query55  92  88  88  88
   query56  311 319 313 313
   query57  1212118311381138
   query58  285 278 265 265
   query59  2684284626702670
   query60  348 346 341 341
   query61  129 124 126 124
   query62  768 765 696 696
   query63  239 204 198 198
   query64  19141041733 733
   query65  4306422042514220
   query66  740 418 301 301
   query67  15981   15563   15380   15380
   query68  6823899 550 550
   query69  548 322 276 276
   query70  1178111711231117
   query71  509 325 297 297
   query72  5957464647614646
   query73  1259626 372 372
   query74  9015910786898689
   query75  4004323027082708
   query76  41251193778 778
   query77  717 380 291 291
   query78  10228   10182   92999299
   query79  2750879 615 615
   query80  662 581 470 470
   query81  478 253 230 230
   query82  416 132 101 101
   query83  270 265 240 240
   query84  299 105 85  85
   query85  782 358 330 330
   query86  363 288 286 286
   query87  4428449243514351
   query88  3671239623812381
   query89  420 330 296 296
   query90  1804224 224 224
   query91  146 163 114 114
   query92  78  64  59  59
   query93  2393968 587 587
   query94  645 410 302 302
   query95  372 300 288 288
   query96  522 582 290 290
   query97  2744277226992699
   query98  244 209 213 209
   query99  1388140612591259
   Total cold run time: 300222 ms
   Total hot run time: 193249 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

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-18 Thread via GitHub 


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

   
   
   TPC-H: Total hot run time: 33887 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 8a09790e7c0484ea20470b1d8f32572e7425e5f6, 
data reload: false
   
   -- Round 1 --
   q1   26066   512249904990
   q2   2058261 176 176
   q3   10412   1205661 661
   q4   10220   977 534 534
   q5   7539229623242296
   q6   180 165 135 135
   q7   890 773 623 623
   q8   9303126610481048
   q9   6808510550285028
   q10  6854230318931893
   q11  481 284 266 266
   q12  339 346 204 204
   q13  17765   363832373237
   q14  239 247 222 222
   q15  538 490 485 485
   q16  432 456 384 384
   q17  593 858 363 363
   q18  7721721372887213
   q19  1505957 559 559
   q20  353 344 234 234
   q21  4194321023692369
   q22  1018982 967 967
   Total cold run time: 115508 ms
   Total hot run time: 33887 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5123506250625062
   q2   225 318 229 229
   q3   2102263522912291
   q4   1348177113441344
   q5   4448434343964343
   q6   219 165 127 127
   q7   2012192617461746
   q8   2554259325262526
   q9   7206717169696969
   q10  2983316827452745
   q11  577 510 507 507
   q12  713 733 594 594
   q13  3511387332783278
   q14  284 296 287 287
   q15  547 511 499 499
   q16  453 492 434 434
   q17  1147151814221422
   q18  7714740374437403
   q19  770 776 919 776
   q20  1995202918561856
   q21  4753453443254325
   q22  1058104910551049
   Total cold run time: 51742 ms
   Total hot run time: 49812 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-18 Thread via GitHub 


xiedeyantu commented on PR #50998:
URL: https://github.com/apache/doris/pull/50998#issuecomment-2889248899

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Re: [PR] [Feat](nereids) support ShowQueryStatsCommand [doris]

2025-05-18 Thread via GitHub 


hello-stephen commented on PR #50998:
URL: https://github.com/apache/doris/pull/50998#issuecomment-2889003706

   
   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).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting 
information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it 
now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and 
after the optimization?
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]