You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by bi...@apache.org on 2018/10/25 23:18:11 UTC
[3/4] impala git commit: IMPALA-7351: Add estimates to Exchange node
http://git-wip-us.apache.org/repos/asf/impala/blob/8cbec20e/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test b/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test
index 6eb42ef..71040ad 100644
--- a/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test
+++ b/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test
@@ -10,61 +10,61 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [tpch_parquet.lineitem]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=40.00MB Threads=3
-Per-Host Resource Estimates: Memory=80MB
+Per-Host Resource Estimates: Memory=91MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.78MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.78MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=263B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=2
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=80.00MB Threads=3
-Per-Host Resource Estimates: Memory=160MB
+Per-Host Resource Estimates: Memory=172MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=11.56MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=11.56MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=263B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
Per-Host Resources: mem-estimate=160.00MB mem-reservation=80.00MB thread-reservation=2
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=0
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -82,61 +82,61 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [tpch_parquet.lineitem]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=1
tuple-ids=0 row-size=42B cardinality=6001215
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=4.00MB Threads=3
-Per-Host Resource Estimates: Memory=80MB
+Per-Host Resource Estimates: Memory=90MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.14MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.14MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=42B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=2
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=1
tuple-ids=0 row-size=42B cardinality=6001215
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=8.00MB Threads=3
-Per-Host Resource Estimates: Memory=160MB
+Per-Host Resource Estimates: Memory=170MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.27MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.27MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=42B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
Per-Host Resources: mem-estimate=160.00MB mem-reservation=8.00MB thread-reservation=2
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=0
tuple-ids=0 row-size=42B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -155,7 +155,7 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [functional_parquet.alltypes]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -171,19 +171,19 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional_parquet.alltypes
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=60.00KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=60.00KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=16B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=2
00:SCAN HDFS [functional_parquet.alltypes, RANDOM]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -199,19 +199,19 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional_parquet.alltypes
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=120.00KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=120.00KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=16B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
Per-Host Resources: mem-estimate=32.00MB mem-reservation=32.00KB thread-reservation=2
00:SCAN HDFS [functional_parquet.alltypes, RANDOM]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -236,7 +236,7 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [functional_parquet.alltypes]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -252,19 +252,19 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional_parquet.alltypes
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=83.99KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=83.99KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=24B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=16.00MB mem-reservation=24.00KB thread-reservation=2
00:SCAN HDFS [functional_parquet.alltypes, RANDOM]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -280,19 +280,19 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional_parquet.alltypes
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=167.99KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=167.99KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=24B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
Per-Host Resources: mem-estimate=32.00MB mem-reservation=48.00KB thread-reservation=2
00:SCAN HDFS [functional_parquet.alltypes, RANDOM]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -317,7 +317,7 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [functional_parquet.alltypes]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -333,19 +333,19 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional_parquet.alltypes
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=16.00KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=0B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=1.00MB mem-reservation=16.00KB thread-reservation=2
00:SCAN HDFS [functional_parquet.alltypes, RANDOM]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -361,19 +361,19 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional_parquet.alltypes
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=24.00KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=24.00KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=0B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
Per-Host Resources: mem-estimate=32.00MB mem-reservation=32.00KB thread-reservation=2
00:SCAN HDFS [functional_parquet.alltypes, RANDOM]
- partitions=24/24 files=24 size=199.69KB
+ partitions=24/24 files=24 size=188.54KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/24 rows=unavailable
@@ -396,9 +396,9 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [tpch_parquet.customer]
- partitions=1/1 files=1 size=12.34MB
+ partitions=1/1 files=1 size=12.31MB
stored statistics:
- table: rows=150000 size=12.34MB
+ table: rows=150000 size=12.31MB
columns: all
extrapolated-rows=disabled max-scan-range-rows=150000
mem-estimate=24.00MB mem-reservation=128.00KB thread-reservation=1
@@ -418,9 +418,9 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [tpch_parquet.customer]
- partitions=1/1 files=1 size=12.34MB
+ partitions=1/1 files=1 size=12.31MB
stored statistics:
- table: rows=150000 size=12.34MB
+ table: rows=150000 size=12.31MB
columns: all
extrapolated-rows=disabled max-scan-range-rows=150000
mem-estimate=24.00MB mem-reservation=2.00MB thread-reservation=1
@@ -465,11 +465,11 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [tpch_nested_parquet.customer.c_orders]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=24.00MB thread-reservation=1
tuple-ids=0 row-size=80B cardinality=1500000
in pipelines: 00(GETNEXT)
@@ -488,11 +488,11 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [tpch_nested_parquet.customer.c_orders]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=4.00MB thread-reservation=1
tuple-ids=0 row-size=16B cardinality=1500000
in pipelines: 00(GETNEXT)
@@ -511,11 +511,11 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [tpch_nested_parquet.customer.c_orders]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=4.00MB thread-reservation=1
tuple-ids=0 row-size=8B cardinality=1500000
in pipelines: 00(GETNEXT)
@@ -559,12 +559,12 @@ PLAN-ROOT SINK
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
predicates: !empty(c.c_orders)
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns missing stats: c_orders
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=32.00MB thread-reservation=1
tuple-ids=0 row-size=24B cardinality=150000
in pipelines: 00(GETNEXT)
@@ -607,12 +607,12 @@ PLAN-ROOT SINK
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
predicates: !empty(c.c_orders)
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns missing stats: c_orders
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=8.00MB thread-reservation=1
tuple-ids=0 row-size=24B cardinality=150000
in pipelines: 00(GETNEXT)
@@ -656,12 +656,12 @@ PLAN-ROOT SINK
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
predicates: !empty(c.c_orders)
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns missing stats: c_orders
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=8.00MB thread-reservation=1
tuple-ids=0 row-size=24B cardinality=150000
in pipelines: 00(GETNEXT)
@@ -705,12 +705,12 @@ PLAN-ROOT SINK
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
predicates: !empty(c.c_orders)
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns missing stats: c_orders
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=8.00MB thread-reservation=1
tuple-ids=0 row-size=24B cardinality=150000
in pipelines: 00(GETNEXT)
@@ -753,12 +753,12 @@ PLAN-ROOT SINK
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
predicates: !empty(c.c_orders)
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns: unavailable
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=4.00MB thread-reservation=1
tuple-ids=0 row-size=16B cardinality=150000
in pipelines: 00(GETNEXT)
@@ -823,13 +823,13 @@ PLAN-ROOT SINK
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
- partitions=1/1 files=4 size=289.00MB
+ partitions=1/1 files=4 size=288.99MB
predicates: !empty(c.c_orders)
predicates on o: !empty(o.o_lineitems)
stored statistics:
- table: rows=150000 size=289.00MB
+ table: rows=150000 size=288.99MB
columns missing stats: c_orders
- extrapolated-rows=disabled max-scan-range-rows=44227
+ extrapolated-rows=disabled max-scan-range-rows=44232
mem-estimate=88.00MB mem-reservation=16.00MB thread-reservation=1
tuple-ids=0 row-size=24B cardinality=150000
in pipelines: 00(GETNEXT)
@@ -856,15 +856,15 @@ PLAN-ROOT SINK
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=8.00MB Threads=3
-Per-Host Resource Estimates: Memory=88MB
+Per-Host Resource Estimates: Memory=99MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.78MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.78MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=263B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
@@ -881,15 +881,15 @@ Per-Host Resources: mem-estimate=88.00MB mem-reservation=8.00MB thread-reservati
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=16.00MB Threads=3
-Per-Host Resource Estimates: Memory=176MB
+Per-Host Resource Estimates: Memory=188MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=11.56MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=11.56MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=263B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
@@ -927,15 +927,15 @@ PLAN-ROOT SINK
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=8.00MB Threads=3
-Per-Host Resource Estimates: Memory=88MB
+Per-Host Resource Estimates: Memory=98MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.14MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.14MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=42B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
@@ -952,15 +952,15 @@ Per-Host Resources: mem-estimate=88.00MB mem-reservation=8.00MB thread-reservati
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=16.00MB Threads=3
-Per-Host Resource Estimates: Memory=176MB
+Per-Host Resource Estimates: Memory=186MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.27MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.27MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=42B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
@@ -1000,16 +1000,16 @@ PLAN-ROOT SINK
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=32.00KB Threads=3
-Per-Host Resource Estimates: Memory=16MB
+Per-Host Resource Estimates: Memory=17MB
Codegen disabled by planner
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=533.50KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=533.50KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=97B cardinality=7300
| in pipelines: 00(GETNEXT)
|
@@ -1027,16 +1027,16 @@ Per-Host Resources: mem-estimate=16.00MB mem-reservation=32.00KB thread-reservat
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=64.00KB Threads=3
-Per-Host Resource Estimates: Memory=32MB
+Per-Host Resource Estimates: Memory=33MB
Codegen disabled by planner
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=836.50KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=836.50KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=97B cardinality=7300
| in pipelines: 00(GETNEXT)
|
@@ -1082,12 +1082,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
tpch_avro.orders
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=223.95KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=223.95KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=108B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
@@ -1109,12 +1109,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
tpch_avro.orders
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=447.95KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=447.95KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=108B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
@@ -1159,12 +1159,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
tpch_rc.customer
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=101.90KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=101.90KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=98B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
@@ -1186,12 +1186,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
tpch_rc.customer
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=203.90KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=203.90KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=98B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
@@ -1236,12 +1236,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
tpcds_seq_snap.web_returns
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=107.90KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=107.90KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=104B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
@@ -1263,12 +1263,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
tpcds_seq_snap.web_returns
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=215.90KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=215.90KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=104B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
@@ -1364,7 +1364,7 @@ PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [functional.alltypesmixedformat]
- partitions=4/4 files=4 size=66.48KB
+ partitions=4/4 files=4 size=66.06KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/4 rows=unavailable
@@ -1380,19 +1380,19 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional.alltypesmixedformat
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=275.97KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=275.97KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=88B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=16.00MB mem-reservation=88.00KB thread-reservation=2
00:SCAN HDFS [functional.alltypesmixedformat, RANDOM]
- partitions=4/4 files=4 size=66.48KB
+ partitions=4/4 files=4 size=66.06KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/4 rows=unavailable
@@ -1403,24 +1403,24 @@ Per-Host Resources: mem-estimate=16.00MB mem-reservation=88.00KB thread-reservat
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=176.00KB Threads=5
-Per-Host Resource Estimates: Memory=32MB
+Per-Host Resource Estimates: Memory=33MB
WARNING: The following tables are missing relevant table and/or column statistics.
functional.alltypesmixedformat
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=551.97KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=551.97KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=88B cardinality=unavailable
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
Per-Host Resources: mem-estimate=32.00MB mem-reservation=176.00KB thread-reservation=4
00:SCAN HDFS [functional.alltypesmixedformat, RANDOM]
- partitions=4/4 files=4 size=66.48KB
+ partitions=4/4 files=4 size=66.06KB
stored statistics:
table: rows=unavailable size=unavailable
partitions: 0/4 rows=unavailable
@@ -1457,12 +1457,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional_hbase.alltypes
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=1.29MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=1.29MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=88B cardinality=14298
| in pipelines: 00(GETNEXT)
|
@@ -1482,12 +1482,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional_hbase.alltypes
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=1.38MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=1.38MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=88B cardinality=14298
| in pipelines: 00(GETNEXT)
|
@@ -1526,12 +1526,12 @@ Per-Host Resource Estimates: Memory=10MB
Codegen disabled by planner
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=16.37KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=16.37KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=97B cardinality=50
| in pipelines: 00(GETNEXT)
|
@@ -1550,12 +1550,12 @@ Per-Host Resource Estimates: Memory=10MB
Codegen disabled by planner
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=31.17KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=31.17KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=97B cardinality=50
| in pipelines: 00(GETNEXT)
|
@@ -1593,12 +1593,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional.alltypes_datasource
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=686.41KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=686.41KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=116B cardinality=5000
| in pipelines: 00(GETNEXT)
|
@@ -1615,12 +1615,12 @@ WARNING: The following tables are missing relevant table and/or column statistic
functional.alltypes_datasource
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=806.41KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
01:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=806.41KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=116B cardinality=5000
| in pipelines: 00(GETNEXT)
|
@@ -1671,15 +1671,15 @@ PLAN-ROOT SINK
in pipelines: 01(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=8.00MB Threads=3
-Per-Host Resource Estimates: Memory=88MB
+Per-Host Resource Estimates: Memory=99MB
F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.78MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
03:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.78MB mem-reservation=0B thread-reservation=0
| tuple-ids=2 row-size=263B cardinality=12002430
| in pipelines: 01(GETNEXT), 02(GETNEXT)
|
@@ -1712,15 +1712,15 @@ Per-Host Resources: mem-estimate=88.00MB mem-reservation=8.00MB thread-reservati
in pipelines: 01(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=16.00MB Threads=3
-Per-Host Resource Estimates: Memory=176MB
+Per-Host Resource Estimates: Memory=188MB
F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=11.56MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
03:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=11.56MB mem-reservation=0B thread-reservation=0
| tuple-ids=2 row-size=263B cardinality=12002430
| in pipelines: 01(GETNEXT), 02(GETNEXT)
|
@@ -1773,30 +1773,30 @@ PLAN-ROOT SINK
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=1
tuple-ids=0 row-size=8B cardinality=6001215
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=46.50MB Threads=4
-Per-Host Resource Estimates: Memory=124MB
+Per-Host Resource Estimates: Memory=140MB
F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=8.01MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
04:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=8.01MB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=16B cardinality=1563438
| in pipelines: 03(GETNEXT)
|
F01:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=3
-Per-Host Resources: mem-estimate=10.00MB mem-reservation=8.50MB thread-reservation=1
+Per-Host Resources: mem-estimate=18.01MB mem-reservation=8.50MB thread-reservation=1
03:AGGREGATE [FINALIZE]
| output: count:merge(*)
| group by: l_orderkey
@@ -1805,7 +1805,7 @@ Per-Host Resources: mem-estimate=10.00MB mem-reservation=8.50MB thread-reservati
| in pipelines: 03(GETNEXT), 00(OPEN)
|
02:EXCHANGE [HASH(l_orderkey)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=8.01MB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=16B cardinality=1563438
| in pipelines: 00(GETNEXT)
|
@@ -1819,30 +1819,30 @@ Per-Host Resources: mem-estimate=114.00MB mem-reservation=38.00MB thread-reserva
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=1
tuple-ids=0 row-size=8B cardinality=6001215
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=85.50MB Threads=5
-Per-Host Resource Estimates: Memory=248MB
+Per-Host Resource Estimates: Memory=272MB
F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=8.07MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
04:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=8.07MB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=16B cardinality=1563438
| in pipelines: 03(GETNEXT)
|
F01:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=6
-Per-Host Resources: mem-estimate=20.00MB mem-reservation=9.50MB thread-reservation=2
+Per-Host Resources: mem-estimate=36.14MB mem-reservation=9.50MB thread-reservation=2
03:AGGREGATE [FINALIZE]
| output: count:merge(*)
| group by: l_orderkey
@@ -1851,7 +1851,7 @@ Per-Host Resources: mem-estimate=20.00MB mem-reservation=9.50MB thread-reservati
| in pipelines: 03(GETNEXT), 00(OPEN)
|
02:EXCHANGE [HASH(l_orderkey)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=8.07MB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=16B cardinality=1563438
| in pipelines: 00(GETNEXT)
|
@@ -1865,11 +1865,11 @@ Per-Host Resources: mem-estimate=228.00MB mem-reservation=76.00MB thread-reserva
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=0
tuple-ids=0 row-size=8B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -1892,11 +1892,11 @@ PLAN-ROOT SINK
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=1.00MB mem-reservation=128.00KB thread-reservation=1
tuple-ids=0 row-size=8B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -1905,7 +1905,7 @@ Max Per-Host Resource Reservation: Memory=128.00KB Threads=3
Per-Host Resource Estimates: Memory=21MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=10.00MB mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
@@ -1916,7 +1916,7 @@ PLAN-ROOT SINK
| in pipelines: 03(GETNEXT), 01(OPEN)
|
02:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=8B cardinality=1
| in pipelines: 01(GETNEXT)
|
@@ -1929,11 +1929,11 @@ Per-Host Resources: mem-estimate=11.00MB mem-reservation=128.00KB thread-reserva
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=1.00MB mem-reservation=128.00KB thread-reservation=1
tuple-ids=0 row-size=8B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -1942,7 +1942,7 @@ Max Per-Host Resource Reservation: Memory=256.00KB Threads=3
Per-Host Resource Estimates: Memory=190MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=10.00MB mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
@@ -1953,7 +1953,7 @@ PLAN-ROOT SINK
| in pipelines: 03(GETNEXT), 01(OPEN)
|
02:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=8B cardinality=1
| in pipelines: 01(GETNEXT)
|
@@ -1966,11 +1966,11 @@ Per-Host Resources: mem-estimate=180.00MB mem-reservation=256.00KB thread-reserv
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=128.00KB thread-reservation=0
tuple-ids=0 row-size=8B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -1995,26 +1995,26 @@ PLAN-ROOT SINK
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=52.00MB Threads=3
-Per-Host Resource Estimates: Memory=120MB
+Per-Host Resource Estimates: Memory=151MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=30.78MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
02:MERGING-EXCHANGE [UNPARTITIONED]
| order by: l_comment ASC
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=30.78MB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=263B cardinality=6001215
| in pipelines: 01(GETNEXT)
|
@@ -2027,26 +2027,26 @@ Per-Host Resources: mem-estimate=120.00MB mem-reservation=52.00MB thread-reserva
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=104.00MB Threads=3
-Per-Host Resource Estimates: Memory=240MB
+Per-Host Resource Estimates: Memory=302MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=61.56MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
02:MERGING-EXCHANGE [UNPARTITIONED]
| order by: l_comment ASC
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=61.56MB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=263B cardinality=6001215
| in pipelines: 01(GETNEXT)
|
@@ -2059,11 +2059,11 @@ Per-Host Resources: mem-estimate=240.00MB mem-reservation=104.00MB thread-reserv
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=0
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -2089,11 +2089,11 @@ PLAN-ROOT SINK
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -2102,14 +2102,14 @@ Max Per-Host Resource Reservation: Memory=40.00MB Threads=3
Per-Host Resource Estimates: Memory=80MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=86.71KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
02:MERGING-EXCHANGE [UNPARTITIONED]
| order by: l_comment ASC
| limit: 100
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=86.71KB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=263B cardinality=100
| in pipelines: 01(GETNEXT)
|
@@ -2122,11 +2122,11 @@ Per-Host Resources: mem-estimate=80.03MB mem-reservation=40.00MB thread-reservat
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -2135,14 +2135,14 @@ Max Per-Host Resource Reservation: Memory=80.00MB Threads=3
Per-Host Resource Estimates: Memory=160MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=164.87KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
02:MERGING-EXCHANGE [UNPARTITIONED]
| order by: l_comment ASC
| limit: 100
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=164.87KB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=263B cardinality=100
| in pipelines: 01(GETNEXT)
|
@@ -2155,11 +2155,11 @@ Per-Host Resources: mem-estimate=160.05MB mem-reservation=80.00MB thread-reserva
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=0
tuple-ids=0 row-size=263B cardinality=6001215
in pipelines: 00(GETNEXT)
@@ -2206,20 +2206,20 @@ PLAN-ROOT SINK
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=51.00MB Threads=5
-Per-Host Resource Estimates: Memory=477MB
+Per-Host Resource Estimates: Memory=499MB
F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=11.35MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
04:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=11.35MB mem-reservation=0B thread-reservation=0
| tuple-ids=0,1 row-size=454B cardinality=5757710
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
-Per-Host Resources: mem-estimate=389.41MB mem-reservation=43.00MB thread-reservation=2 runtime-filters-memory=1.00MB
+Per-Host Resources: mem-estimate=399.80MB mem-reservation=43.00MB thread-reservation=2 runtime-filters-memory=1.00MB
02:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: l_orderkey = o_orderkey
| fk/pk conjuncts: l_orderkey = o_orderkey
@@ -2229,7 +2229,7 @@ Per-Host Resources: mem-estimate=389.41MB mem-reservation=43.00MB thread-reserva
| in pipelines: 00(GETNEXT), 01(OPEN)
|
|--03:EXCHANGE [BROADCAST]
-| | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | mem-estimate=10.38MB mem-reservation=0B thread-reservation=0
| | tuple-ids=1 row-size=191B cardinality=1500000
| | in pipelines: 01(GETNEXT)
| |
@@ -2257,15 +2257,15 @@ Per-Host Resources: mem-estimate=389.41MB mem-reservation=43.00MB thread-reserva
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=102.00MB Threads=5
-Per-Host Resource Estimates: Memory=955MB
+Per-Host Resource Estimates: Memory=968MB
F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=12.71MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
04:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=12.71MB mem-reservation=0B thread-reservation=0
| tuple-ids=0,1 row-size=454B cardinality=5757710
| in pipelines: 00(GETNEXT)
|
@@ -2288,7 +2288,7 @@ Per-Host Resources: mem-estimate=778.83MB mem-reservation=86.00MB thread-reserva
| | mem-estimate=0B mem-reservation=0B thread-reservation=0
| |
| 03:EXCHANGE [BROADCAST]
-| | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | mem-estimate=10.76MB mem-reservation=0B thread-reservation=0
| | tuple-ids=1 row-size=191B cardinality=1500000
| | in pipelines: 01(GETNEXT)
| |
@@ -2357,20 +2357,20 @@ PLAN-ROOT SINK
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=52.00MB Threads=6
-Per-Host Resource Estimates: Memory=278MB
+Per-Host Resource Estimates: Memory=311MB
F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=11.35MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
05:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=11.35MB mem-reservation=0B thread-reservation=0
| tuple-ids=0,1 row-size=454B cardinality=5757710
| in pipelines: 00(GETNEXT)
|
F02:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=3
-Per-Host Resources: mem-estimate=101.14MB mem-reservation=35.00MB thread-reservation=1 runtime-filters-memory=1.00MB
+Per-Host Resources: mem-estimate=122.30MB mem-reservation=35.00MB thread-reservation=1 runtime-filters-memory=1.00MB
02:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: l_orderkey = o_orderkey
| fk/pk conjuncts: l_orderkey = o_orderkey
@@ -2380,7 +2380,7 @@ Per-Host Resources: mem-estimate=101.14MB mem-reservation=35.00MB thread-reserva
| in pipelines: 00(GETNEXT), 01(OPEN)
|
|--04:EXCHANGE [HASH(o_orderkey)]
-| | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | mem-estimate=10.38MB mem-reservation=0B thread-reservation=0
| | tuple-ids=1 row-size=191B cardinality=1500000
| | in pipelines: 01(GETNEXT)
| |
@@ -2397,7 +2397,7 @@ Per-Host Resources: mem-estimate=101.14MB mem-reservation=35.00MB thread-reserva
| in pipelines: 01(GETNEXT)
|
03:EXCHANGE [HASH(l_orderkey)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.78MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=263B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
@@ -2415,20 +2415,20 @@ Per-Host Resources: mem-estimate=89.00MB mem-reservation=9.00MB thread-reservati
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=104.00MB Threads=7
-Per-Host Resource Estimates: Memory=456MB
+Per-Host Resource Estimates: Memory=492MB
F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=12.71MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
05:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=12.71MB mem-reservation=0B thread-reservation=0
| tuple-ids=0,1 row-size=454B cardinality=5757710
| in pipelines: 00(GETNEXT)
|
F02:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=6
-Per-Host Resources: mem-estimate=102.14MB mem-reservation=70.00MB thread-reservation=2 runtime-filters-memory=1.00MB
+Per-Host Resources: mem-estimate=125.26MB mem-reservation=70.00MB thread-reservation=2 runtime-filters-memory=1.00MB
02:HASH JOIN [INNER JOIN, PARTITIONED]
| hash-table-id=00
| hash predicates: l_orderkey = o_orderkey
@@ -2446,7 +2446,7 @@ Per-Host Resources: mem-estimate=102.14MB mem-reservation=70.00MB thread-reserva
| | mem-estimate=0B mem-reservation=0B thread-reservation=0
| |
| 04:EXCHANGE [HASH(o_orderkey)]
-| | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | mem-estimate=10.76MB mem-reservation=0B thread-reservation=0
| | tuple-ids=1 row-size=191B cardinality=1500000
| | in pipelines: 01(GETNEXT)
| |
@@ -2463,7 +2463,7 @@ Per-Host Resources: mem-estimate=102.14MB mem-reservation=70.00MB thread-reserva
| in pipelines: 01(GETNEXT)
|
03:EXCHANGE [HASH(l_orderkey)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=11.56MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=263B cardinality=6001215
| in pipelines: 00(GETNEXT)
|
@@ -2518,27 +2518,27 @@ PLAN-ROOT SINK
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=16.00MB Threads=5
-Per-Host Resource Estimates: Memory=449MB
+Per-Host Resource Estimates: Memory=471MB
F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=11.35MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
04:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=11.35MB mem-reservation=0B thread-reservation=0
| tuple-ids=0,1 row-size=454B cardinality=9001822500000
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
-Per-Host Resources: mem-estimate=361.10MB mem-reservation=8.00MB thread-reservation=2
+Per-Host Resources: mem-estimate=371.49MB mem-reservation=8.00MB thread-reservation=2
02:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
| mem-estimate=273.10MB mem-reservation=0B thread-reservation=0
| tuple-ids=0,1 row-size=454B cardinality=9001822500000
| in pipelines: 00(GETNEXT), 01(OPEN)
|
|--03:EXCHANGE [BROADCAST]
-| | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | mem-estimate=10.38MB mem-reservation=0B thread-reservation=0
| | tuple-ids=1 row-size=191B cardinality=1500000
| | in pipelines: 01(GETNEXT)
| |
@@ -2565,20 +2565,20 @@ Per-Host Resources: mem-estimate=361.10MB mem-reservation=8.00MB thread-reservat
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=32.00MB Threads=5
-Per-Host Resource Estimates: Memory=898MB
+Per-Host Resource Estimates: Memory=932MB
F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=12.71MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
04:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=12.71MB mem-reservation=0B thread-reservation=0
| tuple-ids=0,1 row-size=454B cardinality=9001822500000
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
-Per-Host Resources: mem-estimate=722.21MB mem-reservation=16.00MB thread-reservation=2
+Per-Host Resources: mem-estimate=743.73MB mem-reservation=16.00MB thread-reservation=2
02:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
| join table id: 00
| mem-estimate=273.10MB mem-reservation=0B thread-reservation=0
@@ -2592,7 +2592,7 @@ Per-Host Resources: mem-estimate=722.21MB mem-reservation=16.00MB thread-reserva
| | mem-estimate=0B mem-reservation=0B thread-reservation=0
| |
| 03:EXCHANGE [BROADCAST]
-| | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | mem-estimate=10.76MB mem-reservation=0B thread-reservation=0
| | tuple-ids=1 row-size=191B cardinality=1500000
| | in pipelines: 01(GETNEXT)
| |
@@ -2705,17 +2705,17 @@ Per-Host Resource Estimates: Memory=26MB
Codegen disabled by planner
F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=56.26KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
04:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=56.26KB mem-reservation=0B thread-reservation=0
| tuple-ids=3,2 row-size=6B cardinality=7300
| in pipelines: 01(GETNEXT)
|
F01:PLAN FRAGMENT [HASH(int_col)] hosts=3 instances=3
-Per-Host Resources: mem-estimate=10.00MB mem-reservation=10.00MB thread-reservation=1
+Per-Host Resources: mem-estimate=10.04MB mem-reservation=10.00MB thread-reservation=1
02:ANALYTIC
| functions: max(tinyint_col)
| partition by: int_col
@@ -2730,7 +2730,7 @@ Per-Host Resources: mem-estimate=10.00MB mem-reservation=10.00MB thread-reservat
| in pipelines: 01(GETNEXT), 00(OPEN)
|
03:EXCHANGE [HASH(int_col)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=38.88KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=5B cardinality=7300
| in pipelines: 00(GETNEXT)
|
@@ -2752,17 +2752,17 @@ Per-Host Resource Estimates: Memory=52MB
Codegen disabled by planner
F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=98.26KB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
04:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=98.26KB mem-reservation=0B thread-reservation=0
| tuple-ids=3,2 row-size=6B cardinality=7300
| in pipelines: 01(GETNEXT)
|
F01:PLAN FRAGMENT [HASH(int_col)] hosts=3 instances=6
-Per-Host Resources: mem-estimate=20.00MB mem-reservation=20.00MB thread-reservation=2
+Per-Host Resources: mem-estimate=20.13MB mem-reservation=20.00MB thread-reservation=2
02:ANALYTIC
| functions: max(tinyint_col)
| partition by: int_col
@@ -2777,7 +2777,7 @@ Per-Host Resources: mem-estimate=20.00MB mem-reservation=20.00MB thread-reservat
| in pipelines: 01(GETNEXT), 00(OPEN)
|
03:EXCHANGE [HASH(int_col)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=65.88KB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=5B cardinality=7300
| in pipelines: 00(GETNEXT)
|
@@ -2852,20 +2852,20 @@ PLAN-ROOT SINK
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.orders]
- partitions=1/1 files=2 size=54.21MB
+ partitions=1/1 files=2 size=54.07MB
stored statistics:
- table: rows=1500000 size=54.21MB
+ table: rows=1500000 size=54.07MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=1177197
+ extrapolated-rows=disabled max-scan-range-rows=1177135
mem-estimate=40.00MB mem-reservation=24.00MB thread-reservation=1
tuple-ids=0 row-size=191B cardinality=1500000
in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=68.00MB Threads=3
-Per-Host Resource Estimates: Memory=102MB
+Per-Host Resource Estimates: Memory=108MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=44.00MB mem-reservation=32.00MB thread-reservation=1
+| Per-Host Resources: mem-estimate=50.38MB mem-reservation=32.00MB thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
@@ -2907,7 +2907,7 @@ PLAN-ROOT SINK
|
07:MERGING-EXCHANGE [UNPARTITIONED]
| order by: o_totalprice ASC
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=20.38MB mem-reservation=0B thread-reservation=0
| tuple-ids=6 row-size=191B cardinality=1500000
| in pipelines: 01(GETNEXT)
|
@@ -2920,20 +2920,20 @@ Per-Host Resources: mem-estimate=58.00MB mem-reservation=36.00MB thread-reservat
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.orders, RANDOM]
- partitions=1/1 files=2 size=54.21MB
+ partitions=1/1 files=2 size=54.07MB
stored statistics:
- table: rows=1500000 size=54.21MB
+ table: rows=1500000 size=54.07MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=1177197
+ extrapolated-rows=disabled max-scan-range-rows=1177135
mem-estimate=40.00MB mem-reservation=24.00MB thread-reservation=1
tuple-ids=0 row-size=191B cardinality=1500000
in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=104.00MB Threads=3
-Per-Host Resource Estimates: Memory=160MB
+Per-Host Resource Estimates: Memory=187MB
F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=44.00MB mem-reservation=32.00MB thread-reservation=1
+| Per-Host Resources: mem-estimate=70.76MB mem-reservation=32.00MB thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
@@ -2975,7 +2975,7 @@ PLAN-ROOT SINK
|
07:MERGING-EXCHANGE [UNPARTITIONED]
| order by: o_totalprice ASC
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=40.76MB mem-reservation=0B thread-reservation=0
| tuple-ids=6 row-size=191B cardinality=1500000
| in pipelines: 01(GETNEXT)
|
@@ -2988,11 +2988,11 @@ Per-Host Resources: mem-estimate=116.00MB mem-reservation=72.00MB thread-reserva
| in pipelines: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [tpch_parquet.orders, RANDOM]
- partitions=1/1 files=2 size=54.21MB
+ partitions=1/1 files=2 size=54.07MB
stored statistics:
- table: rows=1500000 size=54.21MB
+ table: rows=1500000 size=54.07MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=1177197
+ extrapolated-rows=disabled max-scan-range-rows=1177135
mem-estimate=40.00MB mem-reservation=24.00MB thread-reservation=0
tuple-ids=0 row-size=191B cardinality=1500000
in pipelines: 00(GETNEXT)
@@ -3033,23 +3033,23 @@ PLAN-ROOT SINK
| | in pipelines: 08(GETNEXT), 09(OPEN)
| |
| |--09:SCAN HDFS [tpch_parquet.orders]
-| | partitions=1/1 files=2 size=54.21MB
+| | partitions=1/1 files=2 size=54.07MB
| | stored statistics:
-| | table: rows=1500000 size=54.21MB
+| | table: rows=1500000 size=54.07MB
| | columns: all
-| | extrapolated-rows=disabled max-scan-range-rows=1177197
+| | extrapolated-rows=disabled max-scan-range-rows=1177135
| | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=1
| | tuple-ids=6 row-size=8B cardinality=1500000
| | in pipelines: 09(GETNEXT)
| |
| 08:SCAN HDFS [tpch_parquet.lineitem]
-| partitions=1/1 files=3 size=193.99MB
+| partitions=1/1 files=3 size=193.72MB
| predicates: l_shipmode = 'F'
| runtime filters: RF004[bloom] -> l_orderkey
| stored statistics:
-| table: rows=6001215 size=193.99MB
+| table: rows=6001215 size=193.72MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=2141664
+| extrapolated-rows=disabled max-scan-range-rows=2141530
| parquet statistics predicates: l_shipmode = 'F'
| parquet dictionary predicates: l_shipmode = 'F'
| mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1
@@ -3065,12 +3065,12 @@ PLAN-ROOT SINK
| | in pipelines: 05(GETNEXT), 06(OPEN)
| |
| |--06:SCAN HDFS [tpch_parquet.orders]
-| | partitions=1/1 files=2 size=54.21MB
+| | partitions=1/1 files=2 size=54.07MB
| | predicates: o_orderpriority = '2-HIGH'
| | stored statistics:
-| | table: rows=1500000 size=54.21MB
+| | table: rows=1500000 size=54.07MB
| | columns: all
-| | extrapolated-rows=disabled max-scan-range-rows=1177197
+| | extrapolated-rows=disabled max-scan-range-rows=1177135
| | parquet statistics predicates: o_orderpriority = '2-HIGH'
| | parquet dictionary predicates: o_orderpriority = '2-HIGH'
| | mem-estimate=40.00MB mem-reservation=8.00MB thread-reservation=1
@@ -3078,12 +3078,12 @@ PLAN-ROOT SINK
| | in pipelines: 06(GETNEXT)
| |
| 05:SCAN HDFS [tpch_parquet.lineitem]
-| partitions=1/1 files=3 size=193.99MB
+| partitions=1/1 files=3 size=193.72MB
| runtime filters: RF002[bloom] -> l_orderkey
| stored statistics:
-| table: rows=6001215 size=193.99MB
+| table: rows=6001215 size=193.72MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=2141664
+| extrapolated-rows=disabled max-scan-range-rows=2141530
| mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1
| tuple-ids=3 row-size=70B cardinality=6001215
| in pipelines: 05(GETNEXT)
@@ -3103,23 +3103,23 @@ PLAN-ROOT SINK
| in pipelines: 01(GETNEXT), 02(OPEN)
|
|--02:SCAN HDFS [tpch_parquet.orders]
-| partitions=1/1 files=2 size=54.21MB
+| partitions=1/1 files=2 size=54.07MB
| stored statistics:
-| table: rows=1500000 size=54.21MB
+| table: rows=1500000 size=54.07MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=1177197
+| extrapolated-rows=disabled max-scan-range-rows=1177135
| mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=1
| tuple-ids=1 row-size=8B cardinality=1500000
| in pipelines: 02(GETNEXT)
|
01:SCAN HDFS [tpch_parquet.lineitem]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
predicates: l_tax > 10
runtime filters: RF000[bloom] -> l_orderkey
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
parquet statistics predicates: l_tax > 10
parquet dictionary predicates: l_tax > 10
mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1
@@ -3127,20 +3127,20 @@ PLAN-ROOT SINK
in pipelines: 01(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=123.75MB Threads=12
-Per-Host Resource Estimates: Memory=348MB
+Per-Host Resource Estimates: Memory=385MB
F09:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.22MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
17:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.22MB mem-reservation=0B thread-reservation=0
| tuple-ids=7 row-size=70B cardinality=2549844
| in pipelines: 14(GETNEXT), 05(GETNEXT), 08(GETNEXT)
|
F08:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
-Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservation=2 runtime-filters-memory=2.00MB
+Per-Host Resources: mem-estimate=109.02MB mem-reservation=43.00MB thread-reservation=2 runtime-filters-memory=2.00MB
00:UNION
| pass-through-operands: 14
| mem-estimate=0B mem-reservation=0B thread-reservation=0
@@ -3156,30 +3156,30 @@ Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservat
| | in pipelines: 08(GETNEXT), 09(OPEN)
| |
| |--16:EXCHANGE [BROADCAST]
-| | | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | | mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
| | | tuple-ids=6 row-size=8B cardinality=1500000
| | | in pipelines: 09(GETNEXT)
| | |
| | F07:PLAN FRAGMENT [RANDOM] hosts=2 instances=2
| | Per-Host Resources: mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=2
| | 09:SCAN HDFS [tpch_parquet.orders, RANDOM]
-| | partitions=1/1 files=2 size=54.21MB
+| | partitions=1/1 files=2 size=54.07MB
| | stored statistics:
-| | table: rows=1500000 size=54.21MB
+| | table: rows=1500000 size=54.07MB
| | columns: all
-| | extrapolated-rows=disabled max-scan-range-rows=1177197
+| | extrapolated-rows=disabled max-scan-range-rows=1177135
| | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=1
| | tuple-ids=6 row-size=8B cardinality=1500000
| | in pipelines: 09(GETNEXT)
| |
| 08:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
-| partitions=1/1 files=3 size=193.99MB
+| partitions=1/1 files=3 size=193.72MB
| predicates: l_shipmode = 'F'
| runtime filters: RF004[bloom] -> l_orderkey
| stored statistics:
-| table: rows=6001215 size=193.99MB
+| table: rows=6001215 size=193.72MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=2141664
+| extrapolated-rows=disabled max-scan-range-rows=2141530
| parquet statistics predicates: l_shipmode = 'F'
| parquet dictionary predicates: l_shipmode = 'F'
| mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1
@@ -3195,19 +3195,19 @@ Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservat
| | in pipelines: 05(GETNEXT), 06(OPEN)
| |
| |--15:EXCHANGE [BROADCAST]
-| | | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | | mem-estimate=9.34MB mem-reservation=0B thread-reservation=0
| | | tuple-ids=4 row-size=32B cardinality=300000
| | | in pipelines: 06(GETNEXT)
| | |
| | F05:PLAN FRAGMENT [RANDOM] hosts=2 instances=2
| | Per-Host Resources: mem-estimate=40.00MB mem-reservation=8.00MB thread-reservation=2
| | 06:SCAN HDFS [tpch_parquet.orders, RANDOM]
-| | partitions=1/1 files=2 size=54.21MB
+| | partitions=1/1 files=2 size=54.07MB
| | predicates: o_orderpriority = '2-HIGH'
| | stored statistics:
-| | table: rows=1500000 size=54.21MB
+| | table: rows=1500000 size=54.07MB
| | columns: all
-| | extrapolated-rows=disabled max-scan-range-rows=1177197
+| | extrapolated-rows=disabled max-scan-range-rows=1177135
| | parquet statistics predicates: o_orderpriority = '2-HIGH'
| | parquet dictionary predicates: o_orderpriority = '2-HIGH'
| | mem-estimate=40.00MB mem-reservation=8.00MB thread-reservation=1
@@ -3215,12 +3215,12 @@ Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservat
| | in pipelines: 06(GETNEXT)
| |
| 05:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
-| partitions=1/1 files=3 size=193.99MB
+| partitions=1/1 files=3 size=193.72MB
| runtime filters: RF002[bloom] -> l_orderkey
| stored statistics:
-| table: rows=6001215 size=193.99MB
+| table: rows=6001215 size=193.72MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=2141664
+| extrapolated-rows=disabled max-scan-range-rows=2141530
| mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1
| tuple-ids=3 row-size=70B cardinality=6001215
| in pipelines: 05(GETNEXT)
@@ -3232,12 +3232,12 @@ Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservat
| in pipelines: 14(GETNEXT), 01(OPEN)
|
13:EXCHANGE [HASH(l_orderkey,l_partkey,l_suppkey,l_linenumber,l_comment)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.22MB mem-reservation=0B thread-reservation=0
| tuple-ids=2 row-size=70B cardinality=575772
| in pipelines: 01(GETNEXT)
|
F02:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=3
-Per-Host Resources: mem-estimate=48.33MB mem-reservation=39.75MB thread-reservation=1 runtime-filters-memory=1.00MB
+Per-Host Resources: mem-estimate=64.32MB mem-reservation=39.75MB thread-reservation=1 runtime-filters-memory=1.00MB
04:AGGREGATE [STREAMING]
| group by: l_orderkey, l_partkey, l_suppkey, l_linenumber, l_comment
| mem-estimate=42.58MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
@@ -3253,37 +3253,37 @@ Per-Host Resources: mem-estimate=48.33MB mem-reservation=39.75MB thread-reservat
| in pipelines: 01(GETNEXT), 02(OPEN)
|
|--12:EXCHANGE [HASH(o_orderkey)]
-| | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | mem-estimate=5.75MB mem-reservation=0B thread-reservation=0
| | tuple-ids=1 row-size=8B cardinality=1500000
| | in pipelines: 02(GETNEXT)
| |
| F01:PLAN FRAGMENT [RANDOM] hosts=2 instances=2
| Per-Host Resources: mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=2
| 02:SCAN HDFS [tpch_parquet.orders, RANDOM]
-| partitions=1/1 files=2 size=54.21MB
+| partitions=1/1 files=2 size=54.07MB
| stored statistics:
-| table: rows=1500000 size=54.21MB
+| table: rows=1500000 size=54.07MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=1177197
+| extrapolated-rows=disabled max-scan-range-rows=1177135
| mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=1
| tuple-ids=1 row-size=8B cardinality=1500000
| in pipelines: 02(GETNEXT)
|
11:EXCHANGE [HASH(l_orderkey)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.24MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=78B cardinality=600122
| in pipelines: 01(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=81.00MB mem-reservation=25.00MB thread-reservation=2 runtime-filters-memory=1.00MB
01:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
predicates: l_tax > 10
runtime filters: RF000[bloom] -> l_orderkey
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
parquet statistics predicates: l_tax > 10
parquet dictionary predicates: l_tax > 10
mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1
@@ -3291,15 +3291,15 @@ Per-Host Resources: mem-estimate=81.00MB mem-reservation=25.00MB thread-reservat
in pipelines: 01(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=243.75MB Threads=13
-Per-Host Resource Estimates: Memory=693MB
+Per-Host Resource Estimates: Memory=724MB
F09:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1
+| Per-Host Resources: mem-estimate=10.44MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
| mem-estimate=0B mem-reservation=0B thread-reservation=0
|
17:EXCHANGE [UNPARTITIONED]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.44MB mem-reservation=0B thread-reservation=0
| tuple-ids=7 row-size=70B cardinality=2549844
| in pipelines: 14(GETNEXT), 05(GETNEXT), 08(GETNEXT)
|
@@ -3328,30 +3328,30 @@ Per-Host Resources: mem-estimate=198.00MB mem-reservation=86.00MB thread-reserva
| | | mem-estimate=0B mem-reservation=0B thread-reservation=0
| | |
| | 16:EXCHANGE [BROADCAST]
-| | | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | | mem-estimate=10.05MB mem-reservation=0B thread-reservation=0
| | | tuple-ids=6 row-size=8B cardinality=1500000
| | | in pipelines: 09(GETNEXT)
| | |
| | F07:PLAN FRAGMENT [RANDOM] hosts=2 instances=4
| | Per-Host Resources: mem-estimate=80.00MB mem-reservation=8.00MB thread-reservation=2
| | 09:SCAN HDFS [tpch_parquet.orders, RANDOM]
-| | partitions=1/1 files=2 size=54.21MB
+| | partitions=1/1 files=2 size=54.07MB
| | stored statistics:
-| | table: rows=1500000 size=54.21MB
+| | table: rows=1500000 size=54.07MB
| | columns: all
-| | extrapolated-rows=disabled max-scan-range-rows=1177197
+| | extrapolated-rows=disabled max-scan-range-rows=1177135
| | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=0
| | tuple-ids=6 row-size=8B cardinality=1500000
| | in pipelines: 09(GETNEXT)
| |
| 08:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
-| partitions=1/1 files=3 size=193.99MB
+| partitions=1/1 files=3 size=193.72MB
| predicates: l_shipmode = 'F'
| runtime filters: RF004[bloom] -> l_orderkey
| stored statistics:
-| table: rows=6001215 size=193.99MB
+| table: rows=6001215 size=193.72MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=2141664
+| extrapolated-rows=disabled max-scan-range-rows=2141530
| parquet statistics predicates: l_shipmode = 'F'
| parquet dictionary predicates: l_shipmode = 'F'
| mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=0
@@ -3375,19 +3375,19 @@ Per-Host Resources: mem-estimate=198.00MB mem-reservation=86.00MB thread-reserva
| | | mem-estimate=0B mem-reservation=0B thread-reservation=0
| | |
| | 15:EXCHANGE [BROADCAST]
-| | | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | | mem-estimate=9.41MB mem-reservation=0B thread-reservation=0
| | | tuple-ids=4 row-size=32B cardinality=300000
| | | in pipelines: 06(GETNEXT)
| | |
| | F05:PLAN FRAGMENT [RANDOM] hosts=2 instances=4
| | Per-Host Resources: mem-estimate=80.00MB mem-reservation=16.00MB thread-reservation=2
| | 06:SCAN HDFS [tpch_parquet.orders, RANDOM]
-| | partitions=1/1 files=2 size=54.21MB
+| | partitions=1/1 files=2 size=54.07MB
| | predicates: o_orderpriority = '2-HIGH'
| | stored statistics:
-| | table: rows=1500000 size=54.21MB
+| | table: rows=1500000 size=54.07MB
| | columns: all
-| | extrapolated-rows=disabled max-scan-range-rows=1177197
+| | extrapolated-rows=disabled max-scan-range-rows=1177135
| | parquet statistics predicates: o_orderpriority = '2-HIGH'
| | parquet dictionary predicates: o_orderpriority = '2-HIGH'
| | mem-estimate=40.00MB mem-reservation=8.00MB thread-reservation=0
@@ -3395,12 +3395,12 @@ Per-Host Resources: mem-estimate=198.00MB mem-reservation=86.00MB thread-reserva
| | in pipelines: 06(GETNEXT)
| |
| 05:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
-| partitions=1/1 files=3 size=193.99MB
+| partitions=1/1 files=3 size=193.72MB
| runtime filters: RF002[bloom] -> l_orderkey
| stored statistics:
-| table: rows=6001215 size=193.99MB
+| table: rows=6001215 size=193.72MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=2141664
+| extrapolated-rows=disabled max-scan-range-rows=2141530
| mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=0
| tuple-ids=3 row-size=70B cardinality=6001215
| in pipelines: 05(GETNEXT)
@@ -3412,12 +3412,12 @@ Per-Host Resources: mem-estimate=198.00MB mem-reservation=86.00MB thread-reserva
| in pipelines: 14(GETNEXT), 01(OPEN)
|
13:EXCHANGE [HASH(l_orderkey,l_partkey,l_suppkey,l_linenumber,l_comment)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.44MB mem-reservation=0B thread-reservation=0
| tuple-ids=2 row-size=70B cardinality=575772
| in pipelines: 01(GETNEXT)
|
F02:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=6
-Per-Host Resources: mem-estimate=92.91MB mem-reservation=75.75MB thread-reservation=2 runtime-filters-memory=1.00MB
+Per-Host Resources: mem-estimate=113.87MB mem-reservation=75.75MB thread-reservation=2 runtime-filters-memory=1.00MB
04:AGGREGATE [STREAMING]
| group by: l_orderkey, l_partkey, l_suppkey, l_linenumber, l_comment
| mem-estimate=42.58MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
@@ -3441,37 +3441,37 @@ Per-Host Resources: mem-estimate=92.91MB mem-reservation=75.75MB thread-reservat
| | mem-estimate=0B mem-reservation=0B thread-reservation=0
| |
| 12:EXCHANGE [HASH(o_orderkey)]
-| | mem-estimate=0B mem-reservation=0B thread-reservation=0
+| | mem-estimate=5.77MB mem-reservation=0B thread-reservation=0
| | tuple-ids=1 row-size=8B cardinality=1500000
| | in pipelines: 02(GETNEXT)
| |
| F01:PLAN FRAGMENT [RANDOM] hosts=2 instances=4
| Per-Host Resources: mem-estimate=80.00MB mem-reservation=8.00MB thread-reservation=2
| 02:SCAN HDFS [tpch_parquet.orders, RANDOM]
-| partitions=1/1 files=2 size=54.21MB
+| partitions=1/1 files=2 size=54.07MB
| stored statistics:
-| table: rows=1500000 size=54.21MB
+| table: rows=1500000 size=54.07MB
| columns: all
-| extrapolated-rows=disabled max-scan-range-rows=1177197
+| extrapolated-rows=disabled max-scan-range-rows=1177135
| mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=0
| tuple-ids=1 row-size=8B cardinality=1500000
| in pipelines: 02(GETNEXT)
|
11:EXCHANGE [HASH(l_orderkey)]
-| mem-estimate=0B mem-reservation=0B thread-reservation=0
+| mem-estimate=10.48MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=78B cardinality=600122
| in pipelines: 01(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
Per-Host Resources: mem-estimate=162.00MB mem-reservation=50.00MB thread-reservation=2 runtime-filters-memory=1.00MB
01:SCAN HDFS [tpch_parquet.lineitem, RANDOM]
- partitions=1/1 files=3 size=193.99MB
+ partitions=1/1 files=3 size=193.72MB
predicates: l_tax > 10
runtime filters: RF000[bloom] -> l_orderkey
stored statistics:
- table: rows=6001215 size=193.99MB
+ table: rows=6001215 size=193.72MB
columns: all
- extrapolated-rows=disabled max-scan-range-rows=2141664
+ extrapolated-rows=disabled max-scan-range-rows=2141530
parquet statistics predicates: l_tax > 10
parquet dictionary predicates: l_tax > 10
mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=0
@@ -3609,22 +3609,22 @@ PLAN-ROOT SINK
in pipelines: 02(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=191.12MB Threads=11
-Per-Host Resource Estimates: Memory=524MB
+Per-Host Resource Estimates: Memory=567MB
F07:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
-| Per-Host Resources: mem-es
<TRUNCATED>