Query be4e7100835021e7:a7a24f3e00000000
User: psantos
State: FINISHED
Status: OK
| Default Db |
Query Type |
Start Time |
End Time |
Duration |
Queued Duration |
Mem Usage |
Mem Estimate |
Scan Progress |
Query Progress |
Bytes Read |
Bytes Sent |
# rows fetched |
Resource Pool |
| default |
QUERY |
2025-09-18 18:19:36.023 |
2025-09-18 18:19:36.506 |
483.314ms |
0 |
23.19 MB |
183.61 MB |
9 / 9 ( 100%) |
3 / 3 ( 100%) |
1.49 MB |
8.11 MB |
9994 |
root.default |
----------------
Max Per-Host Resource Reservation: Memory=9.31MB Threads=5
Per-Host Resource Estimates: Memory=184MB
WARNING: The following tables are missing relevant table and/or column statistics.
default.orders
Analyzed query: SELECT C_64656661756c745f6f7264657273.rowid C_8,
C_64656661756c745f6f7264657273.orderid C_9,
C_64656661756c745f6f7264657273.orderdate C_13,
C_64656661756c745f6f7264657273.shipdate C_6,
C_64656661756c745f6f7264657273.shipmode C_19,
C_64656661756c745f6f7264657273.customerid C_16,
C_64656661756c745f6f7264657273.customername C_14,
C_64656661756c745f6f7264657273.segment C_7,
C_64656661756c745f6f7264657273.country C_5, C_64656661756c745f6f7264657273.city
C_4, C_64656661756c745f6f7264657273.state C_10,
C_64656661756c745f6f7264657273.postalcode C_0,
C_64656661756c745f6f7264657273.region C_1,
C_64656661756c745f6f7264657273.productid C_17,
C_64656661756c745f6f7264657273.category C_43,
C_64656661756c745f6f7264657273.subcategory C_2,
C_64656661756c745f6f7264657273.productname C_15,
C_64656661756c745f6f7264657273.sales C_12,
C_64656661756c745f6f7264657273.quantity C_3,
C_64656661756c745f6f7264657273.discount C_18,
C_64656661756c745f6f7264657273.profit C_11 FROM `default`.orders
c_64656661756c745f6f7264657273
F04:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
| Per-Host Resources: mem-estimate=14.67MB mem-reservation=4.00MB thread-reservation=1
PLAN-ROOT SINK
| output exprs: C_64656661756c745f6f7264657273.rowid, C_64656661756c745f6f7264657273.orderid, C_64656661756c745f6f7264657273.orderdate, C_64656661756c745f6f7264657273.shipdate, C_64656661756c745f6f7264657273.shipmode, C_64656661756c745f6f7264657273.customerid, C_64656661756c745f6f7264657273.customername, C_64656661756c745f6f7264657273.segment, C_64656661756c745f6f7264657273.country, C_64656661756c745f6f7264657273.city, C_64656661756c745f6f7264657273.state, C_64656661756c745f6f7264657273.postalcode, C_64656661756c745f6f7264657273.region, C_64656661756c745f6f7264657273.productid, C_64656661756c745f6f7264657273.category, C_64656661756c745f6f7264657273.subcategory, C_64656661756c745f6f7264657273.productname, C_64656661756c745f6f7264657273.sales, C_64656661756c745f6f7264657273.quantity, C_64656661756c745f6f7264657273.discount, C_64656661756c745f6f7264657273.profit
| mem-estimate=7.21MB mem-reservation=4.00MB spill-buffer=2.00MB thread-reservation=0
|
06:EXCHANGE [UNPARTITIONED]
| mem-estimate=7.46MB mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=252B cardinality=30.01K
| in pipelines: 03(GETNEXT), 00(GETNEXT)
|
F03:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
Per-Host Resources: mem-estimate=136.40MB mem-reservation=5.25MB thread-reservation=2
04:UNION
| pass-through-operands: all
| mem-estimate=0B mem-reservation=0B thread-reservation=0
| tuple-ids=0 row-size=252B cardinality=30.01K
| in pipelines: 03(GETNEXT), 00(GETNEXT)
|
|--02:DELETE EVENTS HASH JOIN [LEFT ANTI JOIN, BROADCAST]
| | hash predicates: c_64656661756c745f6f7264657273.file__position = c_64656661756c745f6f7264657273-position-delete.pos, c_64656661756c745f6f7264657273.input__file__name = c_64656661756c745f6f7264657273-position-delete.file_path
| | mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
| | tuple-ids=0 row-size=252B cardinality=20.02K
| | in pipelines: 00(GETNEXT), 01(OPEN)
| |
| |--05:EXCHANGE [BROADCAST]
| | | mem-estimate=2.65MB mem-reservation=0B thread-reservation=0
| | | tuple-ids=1 row-size=132B cardinality=20.02K
| | | in pipelines: 01(GETNEXT)
| | |
| | F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
| | Per-Host Resources: mem-estimate=32.53MB mem-reservation=64.00KB thread-reservation=2
| | 01:SCAN S3 [default.orders-POSITION-DELETE-01 c_64656661756c745f6f7264657273-position-delete, RANDOM]
| | S3 partitions=1/1 files=4 size=75.81KB
| | Iceberg snapshot id: 8925916327827828503
| | stored statistics:
| | table: rows=20.02K size=75.81KB
| | columns: all
| | extrapolated-rows=disabled max-scan-range-rows=9.65K
| | mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
| | tuple-ids=1 row-size=132B cardinality=20.02K
| | in pipelines: 01(GETNEXT)
| |
| 00:SCAN S3 [default.orders c_64656661756c745f6f7264657273, RANDOM]
| S3 partitions=1/1 files=4 size=732.15KB
| Iceberg snapshot id: 8925916327827828503
| stored statistics:
| table: rows=30.01K size=1.14MB
| columns missing stats: rowid, orderid, orderdate, shipdate, shipmode, customerid, customername, segment, country, city, state, postalcode, region, productid, category, subcategory, productname, sales, quantity, discount, profit
| extrapolated-rows=disabled max-scan-range-rows=14.68K
| mem-estimate=128.00MB mem-reservation=512.00KB thread-reservation=1
| tuple-ids=0 row-size=252B cardinality=20.02K
| in pipelines: 00(GETNEXT)
|
03:SCAN S3 [default.orders c_64656661756c745f6f7264657273, RANDOM]
S3 partitions=1/1 files=1 size=358.27KB
Iceberg snapshot id: 8925916327827828503
stored statistics:
table: rows=30.01K size=1.14MB
columns missing stats: rowid, orderid, orderdate, shipdate, shipmode, customerid, customername, segment, country, city, state, postalcode, region, productid, category, subcategory, productname, sales, quantity, discount, profit
extrapolated-rows=disabled max-scan-range-rows=30.01K
mem-estimate=128.00MB mem-reservation=512.00KB thread-reservation=1
tuple-ids=0 row-size=252B cardinality=9.99K
in pipelines: 03(GETNEXT)
----------------