Query cf4d6bb50fc9bba7:118d247500000000
Query (id=cf4d6bb50fc9bba7:118d247500000000):
Summary:
Session ID: 9c49d57adcd8e5e9:d298cf1ca2cbc6a0
Session Type: HIVESERVER2
HiveServer2 Protocol Version: V6
Start Time: 2025-09-01 17:29:52.454995000
End Time: 2025-09-01 17:29:52.588211000
Duration: 133.216ms (133216 us)
Query Type: QUERY
Query State: FINISHED
Impala Query State: FINISHED
Query Status: OK
Impala Version: impalad version 4.4.1-RELEASE RELEASE (build ced4193fbfdc9b5635407157c0f18ce00480327c)
User: psantos
Connected User: psantos
Delegated User:
Network Address: 172.19.147.17:40396
Default Db: default
Sql Statement: SELECT `C_0` AS `C_1` FROM (SELECT `C_64656661756c745f70656f706c65`.`person` AS `C_43`, `C_64656661756c745f70656f706c65`.`region` AS `C_0` FROM `default`.`people` `C_64656661756c745f70656f706c65` WHERE (`C_64656661756c745f70656f706c65`.`person` = 'Александр Пушкин') ) `C_4954424c` GROUP BY `C_0`
Coordinator: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000
Query Options (set by configuration): COMPRESSION_CODEC=TCompressionCodec(codec=ZSTD, compression_level=3),DEFAULT_JOIN_DISTRIBUTION_MODE=SHUFFLE,TIMEZONE=Europe/Moscow,DEFAULT_FILE_FORMAT=PARQUET,DEFAULT_HINTS_INSERT_STATEMENT=NOCLUSTERED,FETCH_ROWS_TIMEOUT_MS=0,ENABLE_OUTER_JOIN_TO_INNER_TRANSFORMATION=1,UTF8_MODE=1
Query Options (set by configuration and planner): COMPRESSION_CODEC=TCompressionCodec(codec=ZSTD, compression_level=3),MT_DOP=0,DEFAULT_JOIN_DISTRIBUTION_MODE=SHUFFLE,TIMEZONE=Europe/Moscow,DEFAULT_FILE_FORMAT=PARQUET,DEFAULT_HINTS_INSERT_STATEMENT=NOCLUSTERED,FETCH_ROWS_TIMEOUT_MS=0,ENABLE_OUTER_JOIN_TO_INNER_TRANSFORMATION=1,UTF8_MODE=1,MINMAX_FILTER_THRESHOLD=0.5,MINMAX_FILTERING_LEVEL=PAGE
Tables Queried: default.people
Plan:
----------------
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)
----------------
Estimated Per-Host Mem: 376049664
Tables Missing Stats: default.people
Request Pool: root.default
Per Host Min Memory Reservation: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(73.98 MB)
Per Host Number of Fragment Instances: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(4)
Admission result: Admitted immediately
Cluster Memory Admitted: 358.63 MB
Executor Group: default
Number of running queries in designated executor group when admitted: 1
ExecSummary:
Operator #Hosts #Inst Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
F05:ROOT 1 1 68.389us 68.389us 4.01 MB 4.00 MB
09:EXCHANGE 1 1 10.884us 10.884us 1 2 16.00 KB 16.00 KB UNPARTITIONED
F04:EXCHANGE SENDER 1 1 83.559us 83.559us 9.87 KB 64.00 KB
08:AGGREGATE 1 1 1.407ms 1.407ms 1 2 34.02 MB 128.00 MB FINALIZE
07:EXCHANGE 1 1 13.887us 13.887us 1 2 16.00 KB 16.00 KB HASH(C_0)
F03:EXCHANGE SENDER 1 1 58.851us 58.851us 9.87 KB 64.00 KB
05:AGGREGATE 1 1 801.126us 801.126us 1 2 34.08 MB 128.00 MB STREAMING
04:UNION 1 1 0.000ns 0.000ns 1 2 0 0
|--02:DELETE EVENTS HASH JOIN 1 1 659.531us 659.531us 0 1 2.01 MB 1.94 MB LEFT ANTI JOIN, BROADCAST
| |--06:EXCHANGE 1 1 21.709us 21.709us 2 2 24.00 KB 16.00 KB BROADCAST
| | F02:EXCHANGE SENDER 1 1 145.497us 145.497us 6.36 KB 548.00 KB
| | 01:SCAN S3 1 1 30.774ms 30.774ms 2 2 89.02 KB 32.00 MB default.people-POSITION-DELETE-01 c_64656661756c745f70656f706c65-position-delete
| 00:SCAN S3 1 1 7.430ms 7.430ms 0 1 64.00 KB 64.00 MB default.people c_64656661756c745f70656f706c65
03:SCAN S3 1 1 23.087ms 23.087ms 1 1 129.02 KB 64.00 MB default.people c_64656661756c745f70656f706c65
Errors:
Query Compilation: 4.572ms
- Metadata of all 1 tables cached: 856.394us (856.394us)
- Analysis finished: 1.350ms (493.928us)
- Authorization finished (noop): 1.470ms (119.894us)
- Value transfer graph computed: 1.541ms (71.185us)
- Single node plan created: 3.048ms (1.507ms)
- Runtime filters computed: 3.180ms (131.339us)
- Distributed plan created: 3.199ms (19.673us)
- Lineage info computed: 3.241ms (41.416us)
- Planning finished: 4.572ms (1.331ms)
Query Timeline: 158.242ms
- Query submitted: 56.439us (56.439us)
- Planning finished: 5.444ms (5.388ms)
- Submit for admission: 5.648ms (203.886us)
- Completed admission: 18.573ms (12.925ms)
- Ready to start on 1 backends: 18.771ms (198.283us)
- All 1 execution backends (4 fragment instances) started: 19.667ms (896.129us)
- Rows available: 92.854ms (73.186ms)
- First row fetched: 130.112ms (37.257ms)
- Last row fetched: 130.116ms (3.687us)
- Released admission control resources: 133.213ms (3.097ms)
- Unregister query: 158.242ms (25.028ms)
- AdmissionControlTimeSinceLastUpdate: 48.000ms
- ComputeScanRangeAssignmentTimer: 91.281us
Memory Reserve:
Frontend:
Referenced Tables: default.people
Expr memory estimated bytes: 450
- CatalogFetch.ColumnStats.Hits: 4
- CatalogFetch.ColumnStats.Misses: 0
- CatalogFetch.ColumnStats.Requests: 4
- CatalogFetch.ColumnStats.Time: 0
- CatalogFetch.Config.Hits: 1
- CatalogFetch.Config.Misses: 0
- CatalogFetch.Config.Requests: 1
- CatalogFetch.Config.Time: 0
- CatalogFetch.DatabaseList.Hits: 1
- CatalogFetch.DatabaseList.Misses: 0
- CatalogFetch.DatabaseList.Requests: 1
- CatalogFetch.DatabaseList.Time: 0
- CatalogFetch.PartitionLists.Hits: 1
- CatalogFetch.PartitionLists.Misses: 0
- CatalogFetch.PartitionLists.Requests: 1
- CatalogFetch.PartitionLists.Time: 0
- CatalogFetch.Partitions.Hits: 6
- CatalogFetch.Partitions.Misses: 0
- CatalogFetch.Partitions.Requests: 6
- CatalogFetch.Partitions.Time: 0
- CatalogFetch.TableList.Hits: 1
- CatalogFetch.TableList.Misses: 0
- CatalogFetch.TableList.Requests: 1
- CatalogFetch.TableList.Time: 0
- CatalogFetch.Tables.Hits: 3
- CatalogFetch.Tables.Misses: 0
- CatalogFetch.Tables.Requests: 3
- CatalogFetch.Tables.Time: 0
- ExecutorGroupsConsidered: 1 (1)
Executor group 1:
Verdict: Match
- MemoryAsk: 358.63 MB (376049664)
- MemoryMax: 8589934592.00 GB (9223372036854775807)
ImpalaServer:
- ClientFetchWaitTimeStats: (Avg: 37.230ms ; Min: 37.230ms ; Max: 37.230ms ; Number of samples: 1)
- GetInFlightProfileTimeStats: 0.000ns (Number of samples: 0)
- ClientFetchLockWaitTimer: 343.000ns
- ClientFetchWaitTimer: 37.230ms
- NumRowsFetched: 1 (1)
- NumRowsFetchedFromCache: 0 (0)
- RPCCount: 8 (8)
- RPCReadTimer: 18.000us
- RPCWriteTimer: 339.000us
- RowMaterializationRate: 301.00 /sec
- RowMaterializationTimer: 3.322ms
Execution Profile cf4d6bb50fc9bba7:118d247500000000:
Number of filters: 0
Filter routing table:
ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled Bloom Size Est fpp Min value Max value In-list size
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Backend startup latencies: Count: 1, sum: 1ms, min / max: 1ms / 1ms, 25th %-ile: 1ms, 50th %-ile: 1ms, 75th %-ile: 1ms, 90th %-ile: 1ms, 95th %-ile: 1ms, 99.9th %-ile: 1ms
Slowest backend to start up: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000
Per Node Peak Memory Usage: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(74.31 MB)
Per Node Bytes Read: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(5.73 KB)
Per Node User Time: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(134.027ms)
Per Node System Time: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(3.982ms)
- ExchangeScanRatio: 0.05
- FiltersReceived: 0 (0)
- FinalizationTimer: 0.000ns
- InnerNodeSelectivityRatio: 0.07
- NumBackends: 1 (1)
- NumCompletedBackends: 1 (1)
- NumFragmentInstances: 4 (4)
- NumFragments: 4 (4)
- TotalBytesRead: 5.73 KB (5867)
- TotalBytesSent: 318.00 B (318)
- TotalCpuTime: 138.009ms
- TotalInnerBytesSent: 21.00 B (21)
- TotalScanBytesSent: 297.00 B (297)
Per Node Profiles:
impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000:
- HostCpuIoWaitPercentage (50.000ms): 0, 0, 0
- HostCpuSysPercentage (50.000ms): 1, 1, 1
- HostCpuUserPercentage (50.000ms): 5, 5, 5
- HostDiskReadThroughput (50.000ms): 0.00 /sec, 0.00 /sec, 0.00 /sec
- HostDiskWriteThroughput (50.000ms): 0.00 /sec, 0.00 /sec, 0.00 /sec
- HostNetworkRx (50.000ms): 969.23 KB/sec, 969.23 KB/sec, 969.23 KB/sec
- HostNetworkTx (50.000ms): 720.58 KB/sec, 720.58 KB/sec, 720.58 KB/sec
- AdmissionSlots: 1 (1)
- BloomFilterBytes: 0
- InListFilterItems: 0 (0)
- ScratchBytesRead: 0
- ScratchBytesReadUseLocalDisk: 0
- ScratchBytesReadUseMem: 0
- ScratchBytesWritten: 0
- ScratchFileUsedBytes: 0
- ScratchReads: 0 (0)
- ScratchReadsUseLocalDisk: 0 (0)
- ScratchReadsUseMem: 0 (0)
- ScratchWrites: 0 (0)
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
- UncompressedScratchBytesWritten: 0
Buffer pool:
- AllocTime: 0.000ns
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 0
- CumulativeAllocations: 0 (0)
- EncryptionTime: 0.000ns
- PeakReservation: 0
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 0
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- ReservationLimit: 0
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
JVM:
- GcCount: 0 (0)
- GcNumInfoThresholdExceeded: 0 (0)
- GcNumWarnThresholdExceeded: 0 (0)
- GcTimeMillis: 0
- GcTotalExtraSleepTimeMillis: 0
Fragment F05:
CodeGen:
- CodegenCacheLookupTime: 1.195ms
- CodegenCacheSaveTime: 0.000ns
- CodegenCompileThreadInvoluntaryContextSwitches: 0 (0)
- CodegenCompileThreadTotalWallClockTime: 0.000ns
- CodegenCompileThreadSysTime: 0.000ns
- CodegenCompileThreadUserTime: 0.000ns
- CodegenCompileThreadVoluntaryContextSwitches: 0 (0)
- CodegenInvoluntaryContextSwitches: 1 (1)
- CodegenTotalWallClockTime: 31.222ms
- CodegenSysTime: 3.782ms
- CodegenUserTime: 26.208ms
- CodegenVoluntaryContextSwitches: 0 (0)
- CompileTime: 87.024us
- FunctionPruneTime: 2.698ms
- InactiveTotalTime: 0.000ns
- IrGenerationTime: 127.154us
- LoadTime: 0.000ns
- MainThreadCodegenTime: 5.291ms
- ModuleBitcodeGenTime: 1.126ms
- ModuleBitcodeSize: 3.20 MB (3355244)
- NumCachedFunctions: 1 (1)
- NumFunctions: 3 (3)
- NumInstructions: 55 (55)
- NumOptimizedFunctions: 1 (1)
- NumOptimizedInstructions: 32 (32)
- OptimizationTime: 0.000ns
- PeakMemoryUsage: 112.00 B (112)
- PrepareTime: 25.940ms
- TotalTime: 31.231ms
Fragment F04:
CodeGen:
- CodegenCacheLookupTime: 1.941ms
- CodegenCacheSaveTime: 0.000ns
- CodegenCompileThreadInvoluntaryContextSwitches: 0 (0)
- CodegenCompileThreadTotalWallClockTime: 0.000ns
- CodegenCompileThreadSysTime: 0.000ns
- CodegenCompileThreadUserTime: 0.000ns
- CodegenCompileThreadVoluntaryContextSwitches: 0 (0)
- CodegenInvoluntaryContextSwitches: 1 (1)
- CodegenTotalWallClockTime: 26.321ms
- CodegenSysTime: 0.000ns
- CodegenUserTime: 26.109ms
- CodegenVoluntaryContextSwitches: 0 (0)
- CompileTime: 168.155us
- FunctionPruneTime: 2.204ms
- InactiveTotalTime: 0.000ns
- IrGenerationTime: 2.069ms
- LoadTime: 0.000ns
- MainThreadCodegenTime: 7.493ms
- ModuleBitcodeGenTime: 1.860ms
- ModuleBitcodeSize: 3.20 MB (3355244)
- NumCachedFunctions: 20 (20)
- NumFunctions: 41 (41)
- NumInstructions: 783 (783)
- NumOptimizedFunctions: 20 (20)
- NumOptimizedInstructions: 515 (515)
- OptimizationTime: 0.000ns
- PeakMemoryUsage: 1.94 KB (1984)
- PrepareTime: 18.841ms
- TotalTime: 26.333ms
Fragment F03:
CodeGen:
- CodegenCacheLookupTime: 5.863ms
- CodegenCacheSaveTime: 0.000ns
- CodegenCompileThreadInvoluntaryContextSwitches: 0 (0)
- CodegenCompileThreadTotalWallClockTime: 0.000ns
- CodegenCompileThreadSysTime: 0.000ns
- CodegenCompileThreadUserTime: 0.000ns
- CodegenCompileThreadVoluntaryContextSwitches: 0 (0)
- CodegenInvoluntaryContextSwitches: 0 (0)
- CodegenTotalWallClockTime: 37.903ms
- CodegenSysTime: 0.000ns
- CodegenUserTime: 38.224ms
- CodegenVoluntaryContextSwitches: 0 (0)
- CompileTime: 242.361us
- FunctionPruneTime: 3.107ms
- InactiveTotalTime: 0.000ns
- IrGenerationTime: 8.626ms
- LoadTime: 0.000ns
- MainThreadCodegenTime: 19.046ms
- ModuleBitcodeGenTime: 5.752ms
- ModuleBitcodeSize: 3.20 MB (3355244)
- NumCachedFunctions: 44 (44)
- NumFunctions: 107 (107)
- NumInstructions: 5.00K (5005)
- NumOptimizedFunctions: 44 (44)
- NumOptimizedInstructions: 3.90K (3899)
- OptimizationTime: 0.000ns
- PeakMemoryUsage: 14.14 KB (14484)
- PrepareTime: 18.867ms
- TotalTime: 37.914ms
Fragment F02:
CodeGen:
- CodegenCacheLookupTime: 1.765ms
- CodegenCacheSaveTime: 0.000ns
- CodegenCompileThreadInvoluntaryContextSwitches: 0 (0)
- CodegenCompileThreadTotalWallClockTime: 0.000ns
- CodegenCompileThreadSysTime: 0.000ns
- CodegenCompileThreadUserTime: 0.000ns
- CodegenCompileThreadVoluntaryContextSwitches: 0 (0)
- CodegenInvoluntaryContextSwitches: 0 (0)
- CodegenTotalWallClockTime: 32.412ms
- CodegenSysTime: 0.000ns
- CodegenUserTime: 30.297ms
- CodegenVoluntaryContextSwitches: 0 (0)
- CompileTime: 57.251us
- FunctionPruneTime: 3.021ms
- InactiveTotalTime: 0.000ns
- IrGenerationTime: 373.234us
- LoadTime: 0.000ns
- MainThreadCodegenTime: 6.328ms
- ModuleBitcodeGenTime: 1.681ms
- ModuleBitcodeSize: 3.20 MB (3355244)
- NumCachedFunctions: 1 (1)
- NumFunctions: 3 (3)
- NumInstructions: 102 (102)
- NumOptimizedFunctions: 1 (1)
- NumOptimizedInstructions: 74 (74)
- OptimizationTime: 0.000ns
- PeakMemoryUsage: 258.00 B (258)
- PrepareTime: 26.096ms
- TotalTime: 32.425ms
Averaged Fragment F05:(Total: 109.928ms, non-child: 31.430ms, % non-child: 28.59%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:112.312ms max:112.312ms mean: 112.312ms stddev:0.000ns
execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 0.00
- BytesAssigned: 0
- CompletionTime: 112.312ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 0.00 /sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 4.03 MB (4227072)
- PeakReservation: 4.00 MB (4194304)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.31 MB (77920115)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 41.280ms
- TotalNetworkSendTime: 0.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 109.789ms
- TotalThreadsSysTime: 3.982ms
- TotalThreadsUserTime: 27.593ms
- TotalThreadsVoluntaryContextSwitches: 3 (3)
- TotalTime: 109.928ms
Fragment Instance Lifecycle Timings:
- ExecTime: 37.288ms
- ExecTreeExecTime: 118.410us
- OpenTime: 72.510ms
- ExecTreeOpenTime: 41.170ms
- PrepareTime: 102.340us
- ExecTreePrepareTime: 56.980us
PLAN_ROOT_SINK:(Total: 37.211ms, non-child: 68.389us, % non-child: 0.18%)
- CreateResultSetTime: 2.911us
- InactiveTotalTime: 37.142ms
- PeakMemoryUsage: 4.01 MB (4202496)
- RowBatchGetWaitTime: 0.000ns
- RowBatchSendWaitTime: 0.000ns
- RowsSent: 1 (1)
- RowsSentRate: 26.00 /sec
- TotalTime: 37.211ms
Buffer pool:
- AllocTime: 1.613us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 2.00 MB (2097152)
- CumulativeAllocations: 1 (1)
- EncryptionTime: 0.000ns
- PeakReservation: 4.00 MB (4194304)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 2.00 MB (2097152)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- ReservationLimit: 100.00 MB (104857600)
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
EXCHANGE_NODE (id=9):(Total: 41.286ms, non-child: 10.884us, % non-child: 0.03%)
- ConvertRowBatchTime: 512.000ns
- InactiveTotalTime: 41.275ms
- PeakMemoryUsage: 16.00 KB (16384)
- RowsReturned: 1 (1)
- RowsReturnedRate: 24.00 /sec
- TotalTime: 41.286ms
Buffer pool:
- AllocTime: 1.144us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 16.00 KB (16384)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 16.00 KB (16384)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 16.00 KB (16384)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 41.162ms
- TotalBytesDequeued: 25.00 B (25)
- TotalGetBatchTime: 41.279ms
- DataWaitTime: 41.275ms
Enqueue:
- DispatchTime: (Avg: 28.706us ; Min: 28.706us ; Max: 28.706us ; Number of samples: 1)
- DeserializeRowBatchTime: 5.099us
- TotalBatchesEnqueued: 1 (1)
- TotalBatchesReceived: 1 (1)
- TotalBytesReceived: 21.00 B (21)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
Coordinator Fragment F05:
Instance cf4d6bb50fc9bba7:118d247500000000 (host=impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000):
Last report received time: 2025-09-01 17:29:52.586
Fragment Instance Lifecycle Event Timeline: 110.391ms
- Prepare Finished: 516.679us (516.679us)
- Open Finished: 73.035ms (72.518ms)
- First Batch Produced: 73.154ms (119.162us)
- First Batch Sent: 73.161ms (6.587us)
- ExecInternal Finished: 110.391ms (37.230ms)
- MemoryUsage (50.000ms): 8.00 KB, 8.00 KB
- AverageThreadTokens: 0.00
- BytesAssigned: 0
- CompletionTime: 112.312ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 0.00 /sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 4.03 MB (4227072)
- PeakReservation: 4.00 MB (4194304)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.31 MB (77920115)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 41.280ms
- TotalNetworkSendTime: 0.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 109.789ms
- TotalThreadsSysTime: 3.982ms
- TotalThreadsUserTime: 27.593ms
- TotalThreadsVoluntaryContextSwitches: 3 (3)
- TotalTime: 109.928ms
Fragment Instance Lifecycle Timings:
- ExecTime: 37.288ms
- ExecTreeExecTime: 118.410us
- OpenTime: 72.510ms
- ExecTreeOpenTime: 41.170ms
- PrepareTime: 102.340us
- ExecTreePrepareTime: 56.980us
PLAN_ROOT_SINK:
- CreateResultSetTime: 2.911us
- InactiveTotalTime: 37.142ms
- PeakMemoryUsage: 4.01 MB (4202496)
- RowBatchGetWaitTime: 0.000ns
- RowBatchSendWaitTime: 0.000ns
- RowsSent: 1 (1)
- RowsSentRate: 26.00 /sec
- TotalTime: 37.211ms
Buffer pool:
- AllocTime: 1.613us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 2.00 MB (2097152)
- CumulativeAllocations: 1 (1)
- EncryptionTime: 0.000ns
- PeakReservation: 4.00 MB (4194304)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 2.00 MB (2097152)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- ReservationLimit: 100.00 MB (104857600)
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
EXCHANGE_NODE (id=9):
Node Lifecycle Event Timeline: 73.168ms
- Open Started: 31.818ms (31.818ms)
- Open Finished: 72.985ms (41.167ms)
- First Batch Requested: 73.036ms (51.241us)
- First Batch Returned: 73.153ms (116.737us)
- Last Batch Returned: 73.153ms (194.000ns)
- Closed: 73.168ms (15.090us)
- ConvertRowBatchTime: 512.000ns
- InactiveTotalTime: 41.275ms
- PeakMemoryUsage: 16.00 KB (16384)
- RowsReturned: 1 (1)
- RowsReturnedRate: 24.00 /sec
- TotalTime: 41.286ms
Buffer pool:
- AllocTime: 1.144us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 16.00 KB (16384)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 16.00 KB (16384)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 16.00 KB (16384)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 41.162ms
- TotalBytesDequeued: 25.00 B (25)
- TotalGetBatchTime: 41.279ms
- DataWaitTime: 41.275ms
Enqueue:
- DispatchTime: (Avg: 28.706us ; Min: 28.706us ; Max: 28.706us ; Number of samples: 1)
- DeserializeRowBatchTime: 5.099us
- TotalBatchesEnqueued: 1 (1)
- TotalBatchesReceived: 1 (1)
- TotalBytesReceived: 21.00 B (21)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
Averaged Fragment F04:(Total: 72.898ms, non-child: 26.525ms, % non-child: 36.39%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:112.404ms max:112.404ms mean: 112.404ms stddev:0.000ns
execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 1.00
- BytesAssigned: 0
- CompletionTime: 112.404ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 0.00 /sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.06 MB (35711968)
- PeakReservation: 34.00 MB (35651584)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.31 MB (77920115)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 44.632ms
- TotalNetworkSendTime: 241.045us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 72.653ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 28.145ms
- TotalThreadsVoluntaryContextSwitches: 3 (3)
- TotalTime: 72.898ms
Fragment Instance Lifecycle Timings:
- ExecTime: 349.238us
- ExecTreeExecTime: 22.379us
- OpenTime: 72.311ms
- ExecTreeOpenTime: 45.909ms
- PrepareTime: 205.823us
- ExecTreePrepareTime: 119.472us
KrpcDataStreamSender (dst_id=9):(Total: 324.604us, non-child: 83.559us, % non-child: 25.74%)
- NetworkThroughput: (Avg: 172.33 KB/sec ; Min: 172.33 KB/sec ; Max: 172.33 KB/sec ; Number of samples: 1)
- RpcNetworkTime: (Avg: 109.763us ; Min: 100.526us ; Max: 119.000us ; Number of samples: 2)
- RpcRecvrTime: (Avg: 33.742us ; Min: 25.612us ; Max: 41.872us ; Number of samples: 2)
- EosSent: 1 (1)
- InactiveTotalTime: 241.045us
- PeakMemoryUsage: 9.87 KB (10111)
- RowsSent: 1 (1)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 2.846us
- TotalBytesSent: 21.00 B (21)
- TotalTime: 324.604us
- UncompressedRowBatchSize: 25.00 B (25)
AGGREGATION_NODE (id=8):(Total: 46.048ms, non-child: 1.407ms, % non-child: 3.06%)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.02 MB (35677312)
- RowsReturned: 1 (1)
- RowsReturnedRate: 21.00 /sec
- TotalTime: 46.048ms
GroupingAggregator 0:
- BuildTime: 378.250us
- GetResultsTime: 8.599us
- HTResizeTime: 775.000ns
- LargestPartitionPercent: 100 (100)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 34.02 MB (35673216)
- PeakReservation: 34.00 MB (35651584)
- PeakUsedReservation: 0
- RowsRepartitioned: 0 (0)
- RowsReturned: 1 (1)
- SpilledPartitions: 0 (0)
Buffer pool:
- AllocTime: 30.690us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 4.00 MB (4194304)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 34.00 MB (35651584)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 4.00 MB (4194304)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 26.808us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Table:
- HashBuckets: 1.02K (1024)
- HashCollisions: 0 (0)
- Probes: 1 (1)
- Resizes: 0 (0)
- Travel: 0 (0)
EXCHANGE_NODE (id=7):(Total: 44.640ms, non-child: 13.887us, % non-child: 0.03%)
- ConvertRowBatchTime: 852.000ns
- InactiveTotalTime: 44.626ms
- PeakMemoryUsage: 16.00 KB (16384)
- RowsReturned: 1 (1)
- RowsReturnedRate: 22.00 /sec
- TotalTime: 44.640ms
Buffer pool:
- AllocTime: 1.513us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 16.00 KB (16384)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 16.00 KB (16384)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 16.00 KB (16384)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 44.626ms
- TotalBytesDequeued: 25.00 B (25)
- TotalGetBatchTime: 44.630ms
- DataWaitTime: 44.626ms
Enqueue:
- DispatchTime: (Avg: 29.104us ; Min: 29.104us ; Max: 29.104us ; Number of samples: 1)
- DeserializeRowBatchTime: 4.164us
- TotalBatchesEnqueued: 1 (1)
- TotalBatchesReceived: 1 (1)
- TotalBytesReceived: 21.00 B (21)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
Fragment F04:
Instance cf4d6bb50fc9bba7:118d247500000003 (host=impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000):
Last report received time: 2025-09-01 17:29:52.586
Fragment Instance Lifecycle Event Timeline: 73.207ms
- Prepare Finished: 535.636us (535.636us)
- Open Finished: 72.851ms (72.316ms)
- First Batch Produced: 72.865ms (13.292us)
- First Batch Sent: 72.897ms (32.202us)
- ExecInternal Finished: 73.207ms (310.318us)
- MemoryUsage (50.000ms): 34.97 KB, 34.97 KB
- ThreadUsage (50.000ms): 1, 1
- AverageThreadTokens: 1.00
- BytesAssigned: 0
- CompletionTime: 112.404ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 0.00 /sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.06 MB (35711968)
- PeakReservation: 34.00 MB (35651584)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.31 MB (77920115)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 44.632ms
- TotalNetworkSendTime: 241.045us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 72.653ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 28.145ms
- TotalThreadsVoluntaryContextSwitches: 3 (3)
- TotalTime: 72.898ms
Fragment Instance Lifecycle Timings:
- ExecTime: 349.238us
- ExecTreeExecTime: 22.379us
- OpenTime: 72.311ms
- ExecTreeOpenTime: 45.909ms
- PrepareTime: 205.823us
- ExecTreePrepareTime: 119.472us
KrpcDataStreamSender (dst_id=9):
ExecOption: Unpartitioned Sender Codegen Disabled: not needed
- BytesSent (50.000ms): 0, 0
- NetworkThroughput: (Avg: 172.33 KB/sec ; Min: 172.33 KB/sec ; Max: 172.33 KB/sec ; Number of samples: 1)
- RpcNetworkTime: (Avg: 109.763us ; Min: 100.526us ; Max: 119.000us ; Number of samples: 2)
- RpcRecvrTime: (Avg: 33.742us ; Min: 25.612us ; Max: 41.872us ; Number of samples: 2)
- EosSent: 1 (1)
- InactiveTotalTime: 241.045us
- PeakMemoryUsage: 9.87 KB (10111)
- RowsSent: 1 (1)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 2.846us
- TotalBytesSent: 21.00 B (21)
- TotalTime: 324.604us
- UncompressedRowBatchSize: 25.00 B (25)
AGGREGATION_NODE (id=8):
Node Lifecycle Event Timeline: 72.935ms
- Open Started: 26.931ms (26.931ms)
- Open Finished: 72.838ms (45.907ms)
- First Batch Requested: 72.853ms (15.103us)
- First Batch Returned: 72.864ms (11.046us)
- Last Batch Returned: 72.905ms (41.027us)
- Closed: 72.935ms (30.329us)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.02 MB (35677312)
- RowsReturned: 1 (1)
- RowsReturnedRate: 21.00 /sec
- TotalTime: 46.048ms
GroupingAggregator 0:
ExecOption: Codegen Enabled
- BuildTime: 378.250us
- GetResultsTime: 8.599us
- HTResizeTime: 775.000ns
- LargestPartitionPercent: 100 (100)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 34.02 MB (35673216)
- PeakReservation: 34.00 MB (35651584)
- PeakUsedReservation: 0
- RowsRepartitioned: 0 (0)
- RowsReturned: 1 (1)
- SpilledPartitions: 0 (0)
Buffer pool:
- AllocTime: 30.690us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 4.00 MB (4194304)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 34.00 MB (35651584)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 4.00 MB (4194304)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 26.808us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Table:
- HashBuckets: 1.02K (1024)
- HashCollisions: 0 (0)
- Probes: 1 (1)
- Resizes: 0 (0)
- Travel: 0 (0)
EXCHANGE_NODE (id=7):
Node Lifecycle Event Timeline: 72.686ms
- Open Started: 26.933ms (26.933ms)
- Open Finished: 71.565ms (44.632ms)
- First Batch Requested: 72.286ms (721.175us)
- First Batch Returned: 72.291ms (5.223us)
- Last Batch Returned: 72.292ms (238.000ns)
- Closed: 72.686ms (393.883us)
- ConvertRowBatchTime: 852.000ns
- InactiveTotalTime: 44.626ms
- PeakMemoryUsage: 16.00 KB (16384)
- RowsReturned: 1 (1)
- RowsReturnedRate: 22.00 /sec
- TotalTime: 44.640ms
Buffer pool:
- AllocTime: 1.513us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 16.00 KB (16384)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 16.00 KB (16384)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 16.00 KB (16384)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 44.626ms
- TotalBytesDequeued: 25.00 B (25)
- TotalGetBatchTime: 44.630ms
- DataWaitTime: 44.626ms
Enqueue:
- DispatchTime: (Avg: 29.104us ; Min: 29.104us ; Max: 29.104us ; Number of samples: 1)
- DeserializeRowBatchTime: 4.164us
- TotalBatchesEnqueued: 1 (1)
- TotalBatchesReceived: 1 (1)
- TotalBytesReceived: 21.00 B (21)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
Averaged Fragment F03:(Total: 71.536ms, non-child: 38.130ms, % non-child: 53.30%)
split sizes: min: 2.39 KB, max: 2.39 KB, avg: 2.39 KB, stddev: 0
completion times: min:112.491ms max:112.491ms mean: 112.491ms stddev:0.000ns
execution rates: min:21.21 KB/sec max:21.21 KB/sec mean:21.21 KB/sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 1.00
- BytesAssigned: 2.39 KB (2443)
- CompletionTime: 112.491ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 21.21 KB/sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 36.11 MB (37866720)
- PeakReservation: 35.97 MB (37715968)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.31 MB (77920115)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 1.133ms
- TotalNetworkSendTime: 228.320us
- TotalStorageWaitTime: 27.806ms
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 108.870ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 42.979ms
- TotalThreadsVoluntaryContextSwitches: 33 (33)
- TotalTime: 71.536ms
Fragment Instance Lifecycle Timings:
- ExecTime: 32.881ms
- ExecTreeExecTime: 32.591ms
- OpenTime: 38.252ms
- ExecTreeOpenTime: 257.848us
- PrepareTime: 373.372us
- ExecTreePrepareTime: 272.455us
KrpcDataStreamSender (dst_id=7):(Total: 287.171us, non-child: 58.851us, % non-child: 20.49%)
- NetworkThroughput: (Avg: 153.77 KB/sec ; Min: 153.77 KB/sec ; Max: 153.77 KB/sec ; Number of samples: 1)
- RpcNetworkTime: (Avg: 95.672us ; Min: 57.977us ; Max: 133.368us ; Number of samples: 2)
- RpcRecvrTime: (Avg: 28.978us ; Min: 16.972us ; Max: 40.984us ; Number of samples: 2)
- EosSent: 1 (1)
- InactiveTotalTime: 228.320us
- PeakMemoryUsage: 9.87 KB (10111)
- RowsSent: 1 (1)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 2.772us
- TotalBytesSent: 21.00 B (21)
- TotalTime: 287.171us
- UncompressedRowBatchSize: 25.00 B (25)
AGGREGATION_NODE (id=5):(Total: 33.118ms, non-child: 801.126us, % non-child: 2.42%)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.08 MB (35731584)
- RowsReturned: 1 (1)
- RowsReturnedRate: 30.00 /sec
- TotalTime: 33.118ms
GroupingAggregator 0:
- BuildTime: 0.000ns
- GetResultsTime: 6.493us
- HTResizeTime: 0.000ns
- LargestPartitionPercent: 100 (100)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 34.02 MB (35669120)
- PeakReservation: 34.00 MB (35651584)
- PeakUsedReservation: 0
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- StreamingTime: 437.204us
Buffer pool:
- AllocTime: 24.446us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 4.00 MB (4194304)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 34.00 MB (35651584)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 4.00 MB (4194304)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 20.294us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Table:
- HashBuckets: 1.02K (1024)
- HashCollisions: 0 (0)
- Probes: 1 (1)
- Resizes: 0 (0)
- Travel: 0 (0)
UNION_NODE (id=4):(Total: 32.204ms, non-child: 0.000ns, % non-child: 0.00%)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 0
- RowsReturned: 1 (1)
- RowsReturnedRate: 31.00 /sec
- TotalTime: 32.204ms
HASH_JOIN_NODE (id=2):(Total: 9.229ms, non-child: 659.531us, % non-child: 7.15%)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 2.01 MB (2109696)
- ProbeRows: 0 (0)
- ProbeRowsPartitioned: 0 (0)
- ProbeTime: 746.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- TotalTime: 9.229ms
Buffer pool:
- AllocTime: 2.381us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 192.00 KB (196608)
- CumulativeAllocations: 3 (3)
- EncryptionTime: 0.000ns
- PeakReservation: 1.94 MB (2031616)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 192.00 KB (196608)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Join Builder (join_node_id=2):(Total: 399.793us, non-child: 399.793us, % non-child: 100.00%)
- BuildRows: 2 (2)
- BuildRowsPartitionTime: 12.305us
- HashTablesBuildTime: 27.610us
- InactiveTotalTime: 0.000ns
- LargestPartitionPercent: 50 (50)
- MaxPartitionLevel: 0 (0)
- NumHashTableBuildsSkipped: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 34.12 KB (34944)
- RepartitionTime: 0.000ns
- SpilledPartitions: 0 (0)
- TotalTime: 399.793us
Hash Table:
- HashBuckets: 2 (2)
- HashCollisions: 0 (0)
- Probes: 2 (2)
- Resizes: 0 (0)
- Travel: 0 (0)
EXCHANGE_NODE (id=6):(Total: 1.146ms, non-child: 21.709us, % non-child: 1.89%)
- ConvertRowBatchTime: 3.055us
- InactiveTotalTime: 1.124ms
- PeakMemoryUsage: 24.00 KB (24576)
- RowsReturned: 2 (2)
- RowsReturnedRate: 1.75 K/sec
- TotalTime: 1.146ms
Buffer pool:
- AllocTime: 5.062us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 32.00 KB (32768)
- CumulativeAllocations: 4 (4)
- EncryptionTime: 0.000ns
- PeakReservation: 24.00 KB (24576)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 24.00 KB (24576)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 0.000ns
- TotalBytesDequeued: 284.00 B (284)
- TotalGetBatchTime: 1.130ms
- DataWaitTime: 1.124ms
Enqueue:
- DispatchTime: (Avg: 54.000us ; Min: 53.227us ; Max: 54.774us ; Number of samples: 2)
- DeserializeRowBatchTime: 16.230us
- TotalBatchesEnqueued: 2 (2)
- TotalBatchesReceived: 2 (2)
- TotalBytesReceived: 276.00 B (276)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
HDFS_SCAN_NODE (id=0):(Total: 7.430ms, non-child: 7.430ms, % non-child: 100.00%)
- ColumnarScannerActualReservation: 0 (Number of samples: 0)
- ColumnarScannerIdealReservation: 0 (Number of samples: 0)
- FooterProcessingTime: (Avg: 6.399ms ; Min: 6.399ms ; Max: 6.399ms ; Number of samples: 1)
- InitialRangeActualReservation: (Avg: 32.00 KB (32768) ; Min: 32.00 KB (32768) ; Max: 32.00 KB (32768) ; Number of samples: 1)
- InitialRangeIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 1)
- PageIndexProcessingTime: 0.000ns (Number of samples: 0)
- ParquetCompressedBytesReadPerColumn: 0 (Number of samples: 0)
- ParquetCompressedPageSize: 0 (Number of samples: 0)
- ParquetUncompressedBytesReadPerColumn: 0 (Number of samples: 0)
- ParquetUncompressedPageSize: 0 (Number of samples: 0)
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 822.00 B (822)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 1 (1)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 0.000ns
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 0
- IoReadAsyncRequest: 0 (0)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 0
- IoReadSyncRequest: 0 (0)
- IoReadTotalBytes: 0
- IoReadTotalRequest: 0 (0)
- MaterializeTupleTime: 310.000ns
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 2 (2)
- NumDictFilteredRowGroups: 0 (0)
- NumDisksAccessed: 1 (1)
- NumFileMetadataRead: 0 (0)
- NumPages: 0 (0)
- NumPagesSkippedByLateMaterialization: 0 (0)
- NumRowGroups: 1 (1)
- NumRowGroupsSkippedByUnusefulFilters: 0 (0)
- NumRowGroupsWithPageIndex: 1 (1)
- NumRuntimeFilteredPages: 0 (0)
- NumRuntimeFilteredRowGroups: 0 (0)
- NumScannerThreadMemUnavailable: 0 (0)
- NumScannerThreadReservationsDenied: 0 (0)
- NumScannerThreadsStarted: 1 (1)
- NumScannersWithNoReads: 0 (0)
- NumStatsFilteredPages: 0 (0)
- NumStatsFilteredRowGroups: 1 (1)
- PeakMemoryUsage: 64.00 KB (65536)
- PeakScannerThreadConcurrency: 1 (1)
- PerReadThreadRawHdfsThroughput: 127.71 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 4.00 KB (4096)
- RowBatchQueueGetWaitTime: 6.804ms
- RowBatchQueuePeakMemoryUsage: 20.00 KB (20480)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 2 (2)
- RowsRead: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- ScanRangesComplete: 1 (1)
- ScannerIoWaitTime: 6.365ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 6.961ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 389.000us
- ScannerThreadsVoluntaryContextSwitches: 1 (1)
- TotalRawHdfsOpenFileTime: 3.363us
- TotalRawHdfsReadTime: 6.285ms
- TotalReadThroughput: 0.00 /sec
- TotalTime: 7.430ms
Buffer pool:
- AllocTime: 808.000ns
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 8.00 KB (8192)
- CumulativeAllocations: 1 (1)
- EncryptionTime: 0.000ns
- PeakReservation: 32.00 KB (32768)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 8.00 KB (8192)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
HDFS_SCAN_NODE (id=3):(Total: 23.087ms, non-child: 23.087ms, % non-child: 100.00%)
- ColumnarScannerActualReservation: (Avg: 32.00 KB (32768) ; Min: 32.00 KB (32768) ; Max: 32.00 KB (32768) ; Number of samples: 1)
- ColumnarScannerIdealReservation: (Avg: 16.00 KB (16384) ; Min: 16.00 KB (16384) ; Max: 16.00 KB (16384) ; Number of samples: 1)
- FooterProcessingTime: (Avg: 5.489ms ; Min: 5.009ms ; Max: 5.970ms ; Number of samples: 2)
- InitialRangeActualReservation: (Avg: 32.00 KB (32768) ; Min: 32.00 KB (32768) ; Max: 32.00 KB (32768) ; Number of samples: 2)
- InitialRangeIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 2)
- PageIndexProcessingTime: (Avg: 4.781ms ; Min: 4.781ms ; Max: 4.781ms ; Number of samples: 1)
- ParquetCompressedBytesReadPerColumn: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 2)
- ParquetCompressedPageSize: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 2)
- ParquetUncompressedBytesReadPerColumn: (Avg: 9.00 B (9) ; Min: 9.00 B (9) ; Max: 9.00 B (9) ; Number of samples: 2)
- ParquetUncompressedPageSize: (Avg: 9.00 B (9) ; Min: 9.00 B (9) ; Max: 9.00 B (9) ; Number of samples: 2)
- AverageHdfsReadThreadConcurrency: 1.00
- AverageScannerThreadConcurrency: 1.00
- BytesRead: 1.85 KB (1899)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 5 (5)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 8.604us
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 157.00 B (157)
- IoReadAsyncRequest: 8 (8)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 121.00 B (121)
- IoReadSyncRequest: 1 (1)
- IoReadTotalBytes: 278.00 B (278)
- IoReadTotalRequest: 9 (9)
- MaterializeTupleTime: 46.563us
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 2 (2)
- NumDictFilteredRowGroups: 0 (0)
- NumDisksAccessed: 1 (1)
- NumFileMetadataRead: 0 (0)
- NumPages: 2 (2)
- NumPagesSkippedByLateMaterialization: 0 (0)
- NumRowGroups: 2 (2)
- NumRowGroupsSkippedByUnusefulFilters: 0 (0)
- NumRowGroupsWithPageIndex: 2 (2)
- NumRuntimeFilteredPages: 0 (0)
- NumRuntimeFilteredRowGroups: 0 (0)
- NumScannerThreadMemUnavailable: 0 (0)
- NumScannerThreadReservationsDenied: 0 (0)
- NumScannerThreadsStarted: 2 (2)
- NumScannersWithNoReads: 0 (0)
- NumStatsFilteredPages: 0 (0)
- NumStatsFilteredRowGroups: 1 (1)
- PeakMemoryUsage: 129.02 KB (132120)
- PeakScannerThreadConcurrency: 2 (2)
- PerReadThreadRawHdfsThroughput: 73.64 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 65.00 KB (66560)
- RowBatchQueueGetWaitTime: 22.211ms
- RowBatchQueuePeakMemoryUsage: 73.00 KB (74752)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 5 (5)
- RowsRead: 1 (1)
- RowsReturned: 1 (1)
- RowsReturnedRate: 43.00 /sec
- ScanRangesComplete: 2 (2)
- ScannerIoWaitTime: 21.441ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 29.213ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 1.584ms
- ScannerThreadsVoluntaryContextSwitches: 17 (17)
- TotalRawHdfsOpenFileTime: 15.473us
- TotalRawHdfsReadTime: 25.184ms
- TotalReadThroughput: 17.91 KB/sec
- TotalTime: 23.087ms
Buffer pool:
- AllocTime: 18.533us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 32.00 KB (32768)
- CumulativeAllocations: 4 (4)
- EncryptionTime: 0.000ns
- PeakReservation: 64.00 KB (65536)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 16.00 KB (16384)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 10.157us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Fragment F03:
Instance cf4d6bb50fc9bba7:118d247500000002 (host=impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000):
Last report received time: 2025-09-01 17:29:52.586
Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:3/2.39 KB
Fragment Instance Lifecycle Event Timeline: 71.719ms
- Prepare Finished: 575.722us (575.722us)
- Open Finished: 38.830ms (38.254ms)
- First Batch Produced: 71.411ms (32.581ms)
- First Batch Sent: 71.413ms (1.934us)
- ExecInternal Finished: 71.719ms (305.905us)
- MemoryUsage (50.000ms): 103.22 KB, 34.18 MB
- ThreadUsage (50.000ms): 1, 2
- AverageThreadTokens: 1.50
- BytesAssigned: 2.39 KB (2443)
- CompletionTime: 112.491ms
- ExchangeScanRatio: 0.01
- ExecutionRate: 21.21 KB/sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 36.11 MB (37866720)
- PeakReservation: 35.97 MB (37715968)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.31 MB (77920115)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 1.133ms
- TotalNetworkSendTime: 228.320us
- TotalStorageWaitTime: 27.806ms
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 108.870ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 42.979ms
- TotalThreadsVoluntaryContextSwitches: 33 (33)
- TotalTime: 71.536ms
Fragment Instance Lifecycle Timings:
- ExecTime: 32.881ms
- ExecTreeExecTime: 32.591ms
- OpenTime: 38.252ms
- ExecTreeOpenTime: 257.848us
- PrepareTime: 373.372us
- ExecTreePrepareTime: 272.455us
KrpcDataStreamSender (dst_id=7):
ExecOption: Hash Partitioned Sender Codegen Enabled
- BytesSent (50.000ms): 0, 0
- NetworkThroughput: (Avg: 153.77 KB/sec ; Min: 153.77 KB/sec ; Max: 153.77 KB/sec ; Number of samples: 1)
- RpcNetworkTime: (Avg: 95.672us ; Min: 57.977us ; Max: 133.368us ; Number of samples: 2)
- RpcRecvrTime: (Avg: 28.978us ; Min: 16.972us ; Max: 40.984us ; Number of samples: 2)
- EosSent: 1 (1)
- InactiveTotalTime: 228.320us
- PeakMemoryUsage: 9.87 KB (10111)
- RowsSent: 1 (1)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 2.772us
- TotalBytesSent: 21.00 B (21)
- TotalTime: 287.171us
- UncompressedRowBatchSize: 25.00 B (25)
AGGREGATION_NODE (id=5):
Node Lifecycle Event Timeline: 71.470ms
- Open Started: 38.566ms (38.566ms)
- Open Finished: 38.822ms (255.594us)
- First Batch Requested: 38.832ms (9.730us)
- First Batch Returned: 71.409ms (32.577ms)
- Last Batch Returned: 71.452ms (42.637us)
- Closed: 71.470ms (18.296us)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.08 MB (35731584)
- RowsReturned: 1 (1)
- RowsReturnedRate: 30.00 /sec
- TotalTime: 33.118ms
GroupingAggregator 0:
ExecOption: Streaming Preaggregation, Codegen Enabled
- BuildTime: 0.000ns
- GetResultsTime: 6.493us
- HTResizeTime: 0.000ns
- LargestPartitionPercent: 100 (100)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 34.02 MB (35669120)
- PeakReservation: 34.00 MB (35651584)
- PeakUsedReservation: 0
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- StreamingTime: 437.204us
Buffer pool:
- AllocTime: 24.446us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 4.00 MB (4194304)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 34.00 MB (35651584)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 4.00 MB (4194304)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 20.294us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Table:
- HashBuckets: 1.02K (1024)
- HashCollisions: 0 (0)
- Probes: 1 (1)
- Resizes: 0 (0)
- Travel: 0 (0)
UNION_NODE (id=4):
ExecOption: Codegen Enabled
Node Lifecycle Event Timeline: 71.282ms
- Open Started: 38.569ms (38.569ms)
- Open Finished: 38.656ms (86.957us)
- First Batch Requested: 38.834ms (178.302us)
- First Batch Returned: 45.979ms (7.145ms)
- Last Batch Returned: 71.158ms (25.178ms)
- Closed: 71.282ms (124.951us)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 0
- RowsReturned: 1 (1)
- RowsReturnedRate: 31.00 /sec
- TotalTime: 32.204ms
HASH_JOIN_NODE (id=2):
ExecOption: Join Build-Side Prepared Asynchronously, Probe Side Codegen Enabled
Node Lifecycle Event Timeline: 71.281ms
- Open Started: 62.189ms (62.189ms)
- Open Finished: 71.126ms (8.936ms)
- First Batch Requested: 71.128ms (1.647us)
- First Batch Returned: 71.156ms (28.311us)
- Last Batch Returned: 71.156ms (199.000ns)
- Closed: 71.281ms (125.271us)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 2.01 MB (2109696)
- ProbeRows: 0 (0)
- ProbeRowsPartitioned: 0 (0)
- ProbeTime: 746.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- TotalTime: 9.229ms
Buffer pool:
- AllocTime: 2.381us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 192.00 KB (196608)
- CumulativeAllocations: 3 (3)
- EncryptionTime: 0.000ns
- PeakReservation: 1.94 MB (2031616)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 192.00 KB (196608)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Join Builder (join_node_id=2):
ExecOption: Build Side Codegen Enabled, Hash Table Construction Codegen Enabled
- BuildRows: 2 (2)
- BuildRowsPartitionTime: 12.305us
- HashTablesBuildTime: 27.610us
- InactiveTotalTime: 0.000ns
- LargestPartitionPercent: 50 (50)
- MaxPartitionLevel: 0 (0)
- NumHashTableBuildsSkipped: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 34.12 KB (34944)
- RepartitionTime: 0.000ns
- SpilledPartitions: 0 (0)
- TotalTime: 399.793us
Hash Table:
- HashBuckets: 2 (2)
- HashCollisions: 0 (0)
- Probes: 2 (2)
- Resizes: 0 (0)
- Travel: 0 (0)
EXCHANGE_NODE (id=6):
Node Lifecycle Event Timeline: 63.856ms
- Open Started: 62.283ms (62.283ms)
- Open Finished: 62.287ms (4.144us)
- First Batch Requested: 62.534ms (247.302us)
- First Batch Returned: 63.673ms (1.138ms)
- Last Batch Returned: 63.674ms (479.000ns)
- Closed: 63.856ms (182.484us)
- ConvertRowBatchTime: 3.055us
- InactiveTotalTime: 1.124ms
- PeakMemoryUsage: 24.00 KB (24576)
- RowsReturned: 2 (2)
- RowsReturnedRate: 1.75 K/sec
- TotalTime: 1.146ms
Buffer pool:
- AllocTime: 5.062us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 32.00 KB (32768)
- CumulativeAllocations: 4 (4)
- EncryptionTime: 0.000ns
- PeakReservation: 24.00 KB (24576)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 24.00 KB (24576)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 0.000ns
- TotalBytesDequeued: 284.00 B (284)
- TotalGetBatchTime: 1.130ms
- DataWaitTime: 1.124ms
Enqueue:
- DispatchTime: (Avg: 54.000us ; Min: 53.227us ; Max: 54.774us ; Number of samples: 2)
- DeserializeRowBatchTime: 16.230us
- TotalBatchesEnqueued: 2 (2)
- TotalBatchesReceived: 2 (2)
- TotalBytesReceived: 276.00 B (276)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
HDFS_SCAN_NODE (id=0):
Table Name: default.people
Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:1/822.00 B
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0%
File Formats: PARQUET/NONE:1
ExecOption: Codegen enabled: 1 out of 1, PARQUET Codegen Enabled
Node Lifecycle Event Timeline: 71.279ms
- Open Started: 62.284ms (62.284ms)
- Open Finished: 62.399ms (114.804us)
- First Batch Requested: 63.902ms (1.503ms)
- First Batch Returned: 70.934ms (7.031ms)
- Last Batch Returned: 71.121ms (187.151us)
- Closed: 71.279ms (158.433us)
- BytesReadSeries (50.000ms): 0, 0
- ColumnarScannerActualReservation: 0 (Number of samples: 0)
- ColumnarScannerIdealReservation: 0 (Number of samples: 0)
- FooterProcessingTime: (Avg: 6.399ms ; Min: 6.399ms ; Max: 6.399ms ; Number of samples: 1)
- InitialRangeActualReservation: (Avg: 32.00 KB (32768) ; Min: 32.00 KB (32768) ; Max: 32.00 KB (32768) ; Number of samples: 1)
- InitialRangeIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 1)
- PageIndexProcessingTime: 0.000ns (Number of samples: 0)
- ParquetCompressedBytesReadPerColumn: 0 (Number of samples: 0)
- ParquetCompressedPageSize: 0 (Number of samples: 0)
- ParquetUncompressedBytesReadPerColumn: 0 (Number of samples: 0)
- ParquetUncompressedPageSize: 0 (Number of samples: 0)
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 822.00 B (822)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 1 (1)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 0.000ns
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 0
- IoReadAsyncRequest: 0 (0)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 0
- IoReadSyncRequest: 0 (0)
- IoReadTotalBytes: 0
- IoReadTotalRequest: 0 (0)
- MaterializeTupleTime: 310.000ns
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 2 (2)
- NumDictFilteredRowGroups: 0 (0)
- NumDisksAccessed: 1 (1)
- NumFileMetadataRead: 0 (0)
- NumPages: 0 (0)
- NumPagesSkippedByLateMaterialization: 0 (0)
- NumRowGroups: 1 (1)
- NumRowGroupsSkippedByUnusefulFilters: 0 (0)
- NumRowGroupsWithPageIndex: 1 (1)
- NumRuntimeFilteredPages: 0 (0)
- NumRuntimeFilteredRowGroups: 0 (0)
- NumScannerThreadMemUnavailable: 0 (0)
- NumScannerThreadReservationsDenied: 0 (0)
- NumScannerThreadsStarted: 1 (1)
- NumScannersWithNoReads: 0 (0)
- NumStatsFilteredPages: 0 (0)
- NumStatsFilteredRowGroups: 1 (1)
- PeakMemoryUsage: 64.00 KB (65536)
- PeakScannerThreadConcurrency: 1 (1)
- PerReadThreadRawHdfsThroughput: 127.71 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 4.00 KB (4096)
- RowBatchQueueGetWaitTime: 6.804ms
- RowBatchQueuePeakMemoryUsage: 20.00 KB (20480)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 2 (2)
- RowsRead: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- ScanRangesComplete: 1 (1)
- ScannerIoWaitTime: 6.365ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 6.961ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 389.000us
- ScannerThreadsVoluntaryContextSwitches: 1 (1)
- TotalRawHdfsOpenFileTime: 3.363us
- TotalRawHdfsReadTime: 6.285ms
- TotalReadThroughput: 0.00 /sec
- TotalTime: 7.430ms
Buffer pool:
- AllocTime: 808.000ns
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 8.00 KB (8192)
- CumulativeAllocations: 1 (1)
- EncryptionTime: 0.000ns
- PeakReservation: 32.00 KB (32768)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 8.00 KB (8192)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
HDFS_SCAN_NODE (id=3):
Table Name: default.people
Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:2/1.58 KB
Hdfs Read Thread Concurrency Bucket: 0:0% 1:100% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0%
File Formats: PARQUET/NONE:1 PARQUET/ZSTD:1
ExecOption: Codegen enabled: 2 out of 2, PARQUET Codegen Enabled
Node Lifecycle Event Timeline: 62.188ms
- Open Started: 38.573ms (38.573ms)
- Open Finished: 38.655ms (82.204us)
- First Batch Requested: 38.835ms (179.884us)
- First Batch Returned: 45.977ms (7.142ms)
- Last Batch Returned: 62.161ms (16.184ms)
- Closed: 62.188ms (26.394us)
- BytesReadSeries (50.000ms): 0, 1.79 KB
- ColumnarScannerActualReservation: (Avg: 32.00 KB (32768) ; Min: 32.00 KB (32768) ; Max: 32.00 KB (32768) ; Number of samples: 1)
- ColumnarScannerIdealReservation: (Avg: 16.00 KB (16384) ; Min: 16.00 KB (16384) ; Max: 16.00 KB (16384) ; Number of samples: 1)
- FooterProcessingTime: (Avg: 5.489ms ; Min: 5.009ms ; Max: 5.970ms ; Number of samples: 2)
- InitialRangeActualReservation: (Avg: 32.00 KB (32768) ; Min: 32.00 KB (32768) ; Max: 32.00 KB (32768) ; Number of samples: 2)
- InitialRangeIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 2)
- PageIndexProcessingTime: (Avg: 4.781ms ; Min: 4.781ms ; Max: 4.781ms ; Number of samples: 1)
- ParquetCompressedBytesReadPerColumn: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 2)
- ParquetCompressedPageSize: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 2)
- ParquetUncompressedBytesReadPerColumn: (Avg: 9.00 B (9) ; Min: 9.00 B (9) ; Max: 9.00 B (9) ; Number of samples: 2)
- ParquetUncompressedPageSize: (Avg: 9.00 B (9) ; Min: 9.00 B (9) ; Max: 9.00 B (9) ; Number of samples: 2)
- AverageHdfsReadThreadConcurrency: 1.00
- AverageScannerThreadConcurrency: 1.00
- BytesRead: 1.85 KB (1899)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 5 (5)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 8.604us
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 157.00 B (157)
- IoReadAsyncRequest: 8 (8)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 121.00 B (121)
- IoReadSyncRequest: 1 (1)
- IoReadTotalBytes: 278.00 B (278)
- IoReadTotalRequest: 9 (9)
- MaterializeTupleTime: 46.563us
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 2 (2)
- NumDictFilteredRowGroups: 0 (0)
- NumDisksAccessed: 1 (1)
- NumFileMetadataRead: 0 (0)
- NumPages: 2 (2)
- NumPagesSkippedByLateMaterialization: 0 (0)
- NumRowGroups: 2 (2)
- NumRowGroupsSkippedByUnusefulFilters: 0 (0)
- NumRowGroupsWithPageIndex: 2 (2)
- NumRuntimeFilteredPages: 0 (0)
- NumRuntimeFilteredRowGroups: 0 (0)
- NumScannerThreadMemUnavailable: 0 (0)
- NumScannerThreadReservationsDenied: 0 (0)
- NumScannerThreadsStarted: 2 (2)
- NumScannersWithNoReads: 0 (0)
- NumStatsFilteredPages: 0 (0)
- NumStatsFilteredRowGroups: 1 (1)
- PeakMemoryUsage: 129.02 KB (132120)
- PeakScannerThreadConcurrency: 2 (2)
- PerReadThreadRawHdfsThroughput: 73.64 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 65.00 KB (66560)
- RowBatchQueueGetWaitTime: 22.211ms
- RowBatchQueuePeakMemoryUsage: 73.00 KB (74752)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 5 (5)
- RowsRead: 1 (1)
- RowsReturned: 1 (1)
- RowsReturnedRate: 43.00 /sec
- ScanRangesComplete: 2 (2)
- ScannerIoWaitTime: 21.441ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 29.213ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 1.584ms
- ScannerThreadsVoluntaryContextSwitches: 17 (17)
- TotalRawHdfsOpenFileTime: 15.473us
- TotalRawHdfsReadTime: 25.184ms
- TotalReadThroughput: 17.91 KB/sec
- TotalTime: 23.087ms
Buffer pool:
- AllocTime: 18.533us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 32.00 KB (32768)
- CumulativeAllocations: 4 (4)
- EncryptionTime: 0.000ns
- PeakReservation: 64.00 KB (65536)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 16.00 KB (16384)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 10.157us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Averaged Fragment F02:(Total: 63.615ms, non-child: 32.562ms, % non-child: 51.19%)
split sizes: min: 2.63 KB, max: 2.63 KB, avg: 2.63 KB, stddev: 0
completion times: min:112.769ms max:112.769ms mean: 112.769ms stddev:0.000ns
execution rates: min:23.33 KB/sec max:23.33 KB/sec mean:23.33 KB/sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 1.00
- BytesAssigned: 2.63 KB (2694)
- CompletionTime: 112.769ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 23.33 KB/sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 103.11 KB (105588)
- PeakReservation: 32.00 KB (32768)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.31 MB (77920115)
- RowsProduced: 2 (2)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 133.212us
- TotalStorageWaitTime: 39.643ms
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 106.146ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 35.310ms
- TotalThreadsVoluntaryContextSwitches: 25 (25)
- TotalTime: 63.615ms
Fragment Instance Lifecycle Timings:
- ExecTime: 30.893ms
- ExecTreeExecTime: 30.619ms
- OpenTime: 32.566ms
- ExecTreeOpenTime: 64.897us
- PrepareTime: 132.359us
- ExecTreePrepareTime: 57.550us
KrpcDataStreamSender (dst_id=6):(Total: 278.709us, non-child: 145.497us, % non-child: 52.20%)
- NetworkThroughput: (Avg: 697.62 KB/sec ; Min: 647.73 KB/sec ; Max: 747.51 KB/sec ; Number of samples: 2)
- RpcNetworkTime: (Avg: 152.223us ; Min: 68.325us ; Max: 208.057us ; Number of samples: 3)
- RpcRecvrTime: (Avg: 57.174us ; Min: 33.146us ; Max: 72.006us ; Number of samples: 3)
- EosSent: 1 (1)
- InactiveTotalTime: 133.212us
- PeakMemoryUsage: 6.36 KB (6510)
- RowsSent: 2 (2)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 8.141us
- TotalBytesSent: 276.00 B (276)
- TotalTime: 278.709us
- UncompressedRowBatchSize: 284.00 B (284)
HDFS_SCAN_NODE (id=1):(Total: 30.774ms, non-child: 30.774ms, % non-child: 100.00%)
- ColumnarScannerActualReservation: (Avg: 16.00 KB (16384) ; Min: 16.00 KB (16384) ; Max: 16.00 KB (16384) ; Number of samples: 2)
- ColumnarScannerIdealReservation: (Avg: 16.00 KB (16384) ; Min: 16.00 KB (16384) ; Max: 16.00 KB (16384) ; Number of samples: 2)
- FooterProcessingTime: (Avg: 13.253ms ; Min: 5.159ms ; Max: 21.347ms ; Number of samples: 2)
- InitialRangeActualReservation: (Avg: 16.00 KB (16384) ; Min: 16.00 KB (16384) ; Max: 16.00 KB (16384) ; Number of samples: 2)
- InitialRangeIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 2)
- PageIndexProcessingTime: 0.000ns (Number of samples: 0)
- ParquetCompressedBytesReadPerColumn: (Avg: 36.00 B (36) ; Min: 36.00 B (36) ; Max: 36.00 B (36) ; Number of samples: 2)
- ParquetCompressedPageSize: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 4)
- ParquetUncompressedBytesReadPerColumn: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 2)
- ParquetUncompressedPageSize: (Avg: 9.00 B (9) ; Min: 9.00 B (9) ; Max: 9.00 B (9) ; Number of samples: 4)
- AverageHdfsReadThreadConcurrency: 1.00
- AverageScannerThreadConcurrency: 1.00
- BytesRead: 3.07 KB (3146)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 6 (6)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 9.342us
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 452.00 B (452)
- IoReadAsyncRequest: 16 (16)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 0
- IoReadSyncRequest: 0 (0)
- IoReadTotalBytes: 452.00 B (452)
- IoReadTotalRequest: 16 (16)
- MaterializeTupleTime: 42.810us
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 2 (2)
- NumDictFilteredRowGroups: 0 (0)
- NumDisksAccessed: 1 (1)
- NumFileMetadataRead: 0 (0)
- NumPages: 4 (4)
- NumPagesSkippedByLateMaterialization: 0 (0)
- NumRowGroups: 2 (2)
- NumRowGroupsSkippedByUnusefulFilters: 0 (0)
- NumRowGroupsWithPageIndex: 2 (2)
- NumRuntimeFilteredPages: 0 (0)
- NumRuntimeFilteredRowGroups: 0 (0)
- NumScannerThreadMemUnavailable: 0 (0)
- NumScannerThreadReservationsDenied: 0 (0)
- NumScannerThreadsStarted: 2 (2)
- NumScannersWithNoReads: 0 (0)
- NumStatsFilteredPages: 0 (0)
- NumStatsFilteredRowGroups: 0 (0)
- PeakMemoryUsage: 89.02 KB (91156)
- PeakScannerThreadConcurrency: 2 (2)
- PerReadThreadRawHdfsThroughput: 63.16 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 66.00 KB (67584)
- RowBatchQueueGetWaitTime: 29.816ms
- RowBatchQueuePeakMemoryUsage: 57.00 KB (58368)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 6 (6)
- RowsRead: 2 (2)
- RowsReturned: 2 (2)
- RowsReturnedRate: 64.00 /sec
- ScanRangesComplete: 2 (2)
- ScannerIoWaitTime: 39.643ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 42.699ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 1.733ms
- ScannerThreadsVoluntaryContextSwitches: 17 (17)
- TotalRawHdfsOpenFileTime: 17.526us
- TotalRawHdfsReadTime: 48.640ms
- TotalReadThroughput: 30.09 KB/sec
- TotalTime: 30.774ms
Buffer pool:
- AllocTime: 11.444us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 48.00 KB (49152)
- CumulativeAllocations: 6 (6)
- EncryptionTime: 0.000ns
- PeakReservation: 32.00 KB (32768)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 24.00 KB (24576)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Fragment F02:
Instance cf4d6bb50fc9bba7:118d247500000001 (host=impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000):
Last report received time: 2025-09-01 17:29:52.586
Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:2/2.63 KB
Fragment Instance Lifecycle Event Timeline: 63.725ms
- Prepare Finished: 258.921us (258.921us)
- Open Finished: 32.822ms (32.563ms)
- First Batch Produced: 45.800ms (12.978ms)
- First Batch Sent: 45.858ms (58.487us)
- ExecInternal Finished: 63.725ms (17.866ms)
- MemoryUsage (50.000ms): 14.09 KB, 46.24 KB
- ThreadUsage (50.000ms): 1, 2
- AverageThreadTokens: 1.50
- BytesAssigned: 2.63 KB (2694)
- CompletionTime: 112.769ms
- ExchangeScanRatio: 0.09
- ExecutionRate: 23.33 KB/sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 103.11 KB (105588)
- PeakReservation: 32.00 KB (32768)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.31 MB (77920115)
- RowsProduced: 2 (2)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 133.212us
- TotalStorageWaitTime: 39.643ms
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 106.146ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 35.310ms
- TotalThreadsVoluntaryContextSwitches: 25 (25)
- TotalTime: 63.615ms
Fragment Instance Lifecycle Timings:
- ExecTime: 30.893ms
- ExecTreeExecTime: 30.619ms
- OpenTime: 32.566ms
- ExecTreeOpenTime: 64.897us
- PrepareTime: 132.359us
- ExecTreePrepareTime: 57.550us
KrpcDataStreamSender (dst_id=6):
ExecOption: Unpartitioned Sender Codegen Disabled: not needed
- BytesSent (50.000ms): 0, 138.00 B
- NetworkThroughput: (Avg: 697.62 KB/sec ; Min: 647.73 KB/sec ; Max: 747.51 KB/sec ; Number of samples: 2)
- RpcNetworkTime: (Avg: 152.223us ; Min: 68.325us ; Max: 208.057us ; Number of samples: 3)
- RpcRecvrTime: (Avg: 57.174us ; Min: 33.146us ; Max: 72.006us ; Number of samples: 3)
- EosSent: 1 (1)
- InactiveTotalTime: 133.212us
- PeakMemoryUsage: 6.36 KB (6510)
- RowsSent: 2 (2)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 8.141us
- TotalBytesSent: 276.00 B (276)
- TotalTime: 278.709us
- UncompressedRowBatchSize: 284.00 B (284)
HDFS_SCAN_NODE (id=1):
Table Name: default.people
Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:2/2.63 KB
Hdfs Read Thread Concurrency Bucket: 0:0% 1:100% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0%
File Formats: PARQUET/ZSTD:2
ExecOption: Codegen enabled: 2 out of 2, PARQUET Codegen Enabled
Node Lifecycle Event Timeline: 63.567ms
- Open Started: 32.752ms (32.752ms)
- Open Finished: 32.815ms (63.082us)
- First Batch Requested: 32.823ms (7.842us)
- First Batch Returned: 45.798ms (12.974ms)
- Last Batch Returned: 63.551ms (17.753ms)
- Closed: 63.567ms (15.486us)
- BytesReadSeries (50.000ms): 0, 3.01 KB
- ColumnarScannerActualReservation: (Avg: 16.00 KB (16384) ; Min: 16.00 KB (16384) ; Max: 16.00 KB (16384) ; Number of samples: 2)
- ColumnarScannerIdealReservation: (Avg: 16.00 KB (16384) ; Min: 16.00 KB (16384) ; Max: 16.00 KB (16384) ; Number of samples: 2)
- FooterProcessingTime: (Avg: 13.253ms ; Min: 5.159ms ; Max: 21.347ms ; Number of samples: 2)
- InitialRangeActualReservation: (Avg: 16.00 KB (16384) ; Min: 16.00 KB (16384) ; Max: 16.00 KB (16384) ; Number of samples: 2)
- InitialRangeIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 2)
- PageIndexProcessingTime: 0.000ns (Number of samples: 0)
- ParquetCompressedBytesReadPerColumn: (Avg: 36.00 B (36) ; Min: 36.00 B (36) ; Max: 36.00 B (36) ; Number of samples: 2)
- ParquetCompressedPageSize: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 4)
- ParquetUncompressedBytesReadPerColumn: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 2)
- ParquetUncompressedPageSize: (Avg: 9.00 B (9) ; Min: 9.00 B (9) ; Max: 9.00 B (9) ; Number of samples: 4)
- AverageHdfsReadThreadConcurrency: 1.00
- AverageScannerThreadConcurrency: 1.00
- BytesRead: 3.07 KB (3146)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 6 (6)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 9.342us
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 452.00 B (452)
- IoReadAsyncRequest: 16 (16)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 0
- IoReadSyncRequest: 0 (0)
- IoReadTotalBytes: 452.00 B (452)
- IoReadTotalRequest: 16 (16)
- MaterializeTupleTime: 42.810us
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 2 (2)
- NumDictFilteredRowGroups: 0 (0)
- NumDisksAccessed: 1 (1)
- NumFileMetadataRead: 0 (0)
- NumPages: 4 (4)
- NumPagesSkippedByLateMaterialization: 0 (0)
- NumRowGroups: 2 (2)
- NumRowGroupsSkippedByUnusefulFilters: 0 (0)
- NumRowGroupsWithPageIndex: 2 (2)
- NumRuntimeFilteredPages: 0 (0)
- NumRuntimeFilteredRowGroups: 0 (0)
- NumScannerThreadMemUnavailable: 0 (0)
- NumScannerThreadReservationsDenied: 0 (0)
- NumScannerThreadsStarted: 2 (2)
- NumScannersWithNoReads: 0 (0)
- NumStatsFilteredPages: 0 (0)
- NumStatsFilteredRowGroups: 0 (0)
- PeakMemoryUsage: 89.02 KB (91156)
- PeakScannerThreadConcurrency: 2 (2)
- PerReadThreadRawHdfsThroughput: 63.16 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 66.00 KB (67584)
- RowBatchQueueGetWaitTime: 29.816ms
- RowBatchQueuePeakMemoryUsage: 57.00 KB (58368)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 6 (6)
- RowsRead: 2 (2)
- RowsReturned: 2 (2)
- RowsReturnedRate: 64.00 /sec
- ScanRangesComplete: 2 (2)
- ScannerIoWaitTime: 39.643ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 42.699ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 1.733ms
- ScannerThreadsVoluntaryContextSwitches: 17 (17)
- TotalRawHdfsOpenFileTime: 17.526us
- TotalRawHdfsReadTime: 48.640ms
- TotalReadThroughput: 30.09 KB/sec
- TotalTime: 30.774ms
Buffer pool:
- AllocTime: 11.444us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 48.00 KB (49152)
- CumulativeAllocations: 6 (6)
- EncryptionTime: 0.000ns
- PeakReservation: 32.00 KB (32768)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 24.00 KB (24576)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns