Query cf4d6bb50fc9bba7:118d247500000000

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-01 17:29:52.454 2025-09-01 17:29:52.588 133.216ms 0 74.31 MB 358.63 MB 5 / 5 ( 100%) 4 / 4 ( 100%) 5.73 KB 318.00 B 1 root.default 
----------------
Max Per-Host Resource Reservation: Memory=73.98MB Threads=6
Per-Host Resource Estimates: Memory=359MB
WARNING: The following tables are missing relevant table and/or column statistics.
default.people
Analyzed query: SELECT C_0 C_1 FROM (SELECT
C_64656661756c745f70656f706c65.person C_43,
C_64656661756c745f70656f706c65.region C_0 FROM `default`.people
c_64656661756c745f70656f706c65 WHERE (C_64656661756c745f70656f706c65.person =
'Александр Пушкин')) c_4954424c GROUP BY C_0

F05:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=4.02MB mem-reservation=4.00MB thread-reservation=1
PLAN-ROOT SINK
|  output exprs: C_0
|  mem-estimate=4.00MB mem-reservation=4.00MB spill-buffer=2.00MB thread-reservation=0
|
09:EXCHANGE [UNPARTITIONED]
|  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  tuple-ids=2 row-size=12B cardinality=2
|  in pipelines: 08(GETNEXT)
|
F04:PLAN FRAGMENT [HASH(C_0)] hosts=1 instances=1
Per-Host Resources: mem-estimate=128.06MB mem-reservation=34.00MB thread-reservation=1
08:AGGREGATE [FINALIZE]
|  group by: C_0
|  mem-estimate=128.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=2 row-size=12B cardinality=2
|  in pipelines: 08(GETNEXT), 03(OPEN), 00(OPEN)
|
07:EXCHANGE [HASH(C_0)]
|  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  tuple-ids=2 row-size=12B cardinality=2
|  in pipelines: 03(GETNEXT), 00(GETNEXT)
|
F03:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
Per-Host Resources: mem-estimate=194.02MB mem-reservation=35.97MB thread-reservation=2
05:AGGREGATE [STREAMING]
|  group by: C_64656661756c745f70656f706c65.region
|  mem-estimate=128.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=2 row-size=12B cardinality=2
|  in pipelines: 03(GETNEXT), 00(GETNEXT)
|
04:UNION
|  pass-through-operands: all
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|  tuple-ids=0 row-size=44B cardinality=2
|  in pipelines: 03(GETNEXT), 00(GETNEXT)
|
|--02:DELETE EVENTS HASH JOIN [LEFT ANTI JOIN, BROADCAST]
|  |  hash predicates: c_64656661756c745f70656f706c65.file__position = c_64656661756c745f70656f706c65-position-delete.pos, c_64656661756c745f70656f706c65.input__file__name = c_64656661756c745f70656f706c65-position-delete.file_path
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=0 row-size=44B cardinality=1
|  |  in pipelines: 00(GETNEXT), 01(OPEN)
|  |
|  |--06:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=3 row-size=133B cardinality=2
|  |  |  in pipelines: 01(GETNEXT)
|  |  |
|  |  F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.54MB mem-reservation=16.00KB thread-reservation=2
|  |  01:SCAN S3 [default.people-POSITION-DELETE-01 c_64656661756c745f70656f706c65-position-delete, RANDOM]
|  |     S3 partitions=1/1 files=2 size=2.63KB
|  |     Iceberg snapshot id: 1765754243809893860
|  |     stored statistics:
|  |       table: rows=2 size=2.63KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=1
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=3 row-size=133B cardinality=2
|  |     in pipelines: 01(GETNEXT)
|  |
|  00:SCAN S3 [default.people c_64656661756c745f70656f706c65, RANDOM]
|     S3 partitions=1/1 files=1 size=822B
|     predicates: (C_64656661756c745f70656f706c65.person = 'Александр Пушкин')
|     Iceberg snapshot id: 1765754243809893860
|     stored statistics:
|       table: rows=6 size=5.02KB
|       columns missing stats: person, region
|     extrapolated-rows=disabled max-scan-range-rows=6
|     parquet statistics predicates: (C_64656661756c745f70656f706c65.person = 'Александр Пушкин')
|     parquet dictionary predicates: (C_64656661756c745f70656f706c65.person = 'Александр Пушкин')
|     mem-estimate=64.00MB mem-reservation=32.00KB thread-reservation=1
|     tuple-ids=0 row-size=44B cardinality=1
|     in pipelines: 00(GETNEXT)
|
03:SCAN S3 [default.people c_64656661756c745f70656f706c65, RANDOM]
   S3 partitions=1/1 files=2 size=1.58KB
   predicates: (C_64656661756c745f70656f706c65.person = 'Александр Пушкин')
   Iceberg snapshot id: 1765754243809893860
   stored statistics:
     table: rows=6 size=5.02KB
     columns missing stats: person, region
   extrapolated-rows=disabled max-scan-range-rows=3
   parquet statistics predicates: (C_64656661756c745f70656f706c65.person = 'Александр Пушкин')
   parquet dictionary predicates: (C_64656661756c745f70656f706c65.person = 'Александр Пушкин')
   mem-estimate=64.00MB mem-reservation=32.00KB thread-reservation=1
   tuple-ids=0 row-size=44B cardinality=1
   in pipelines: 03(GETNEXT)
----------------