Query 7a4d8709f8ad3b25:c0c8559300000000
Query (id=7a4d8709f8ad3b25:c0c8559300000000):
Summary:
Session ID: 4347e1b12301c681:8b12484e79d9ecb2
Session Type: HIVESERVER2
HiveServer2 Protocol Version: V6
Start Time: 2025-09-01 17:28:51.889318000
End Time: 2025-09-01 17:28:52.041179000
Duration: 151.861ms (151861 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:37100
Default Db: default
Sql Statement: SELECT `C_64656661756c745f70656f706c65`.`region` AS `C_43` FROM `default`.`people` `C_64656661756c745f70656f706c65` GROUP BY `C_64656661756c745f70656f706c65`.`region`
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=343MB
WARNING: The following tables are missing relevant table and/or column statistics.
default.people
Analyzed query: SELECT C_64656661756c745f70656f706c65.region C_43 FROM
`default`.people c_64656661756c745f70656f706c65 GROUP BY
C_64656661756c745f70656f706c65.region
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_64656661756c745f70656f706c65.region
| 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=1 row-size=12B cardinality=6
| in pipelines: 08(GETNEXT)
|
F04:PLAN FRAGMENT [HASH(C_64656661756c745f70656f706c65.region)] hosts=1 instances=1
Per-Host Resources: mem-estimate=128.06MB mem-reservation=34.00MB thread-reservation=1
08:AGGREGATE [FINALIZE]
| group by: C_64656661756c745f70656f706c65.region
| mem-estimate=128.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
| tuple-ids=1 row-size=12B cardinality=6
| in pipelines: 08(GETNEXT), 03(OPEN), 00(OPEN)
|
07:EXCHANGE [HASH(C_64656661756c745f70656f706c65.region)]
| mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=12B cardinality=6
| in pipelines: 03(GETNEXT), 00(GETNEXT)
|
F03:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
Per-Host Resources: mem-estimate=178.02MB mem-reservation=35.96MB 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=1 row-size=12B cardinality=6
| 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=32B cardinality=6
| 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=32B cardinality=4
| | in pipelines: 00(GETNEXT), 01(OPEN)
| |
| |--06:EXCHANGE [BROADCAST]
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
| | | tuple-ids=2 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=2 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
| Iceberg snapshot id: 1765754243809893860
| stored statistics:
| table: rows=6 size=5.02KB
| columns missing stats: region
| extrapolated-rows=disabled max-scan-range-rows=6
| mem-estimate=48.00MB mem-reservation=24.00KB thread-reservation=1
| tuple-ids=0 row-size=32B cardinality=4
| in pipelines: 00(GETNEXT)
|
03:SCAN S3 [default.people c_64656661756c745f70656f706c65, RANDOM]
S3 partitions=1/1 files=2 size=1.58KB
Iceberg snapshot id: 1765754243809893860
stored statistics:
table: rows=6 size=5.02KB
columns missing stats: region
extrapolated-rows=disabled max-scan-range-rows=3
mem-estimate=48.00MB mem-reservation=24.00KB thread-reservation=1
tuple-ids=0 row-size=32B cardinality=2
in pipelines: 03(GETNEXT)
----------------
Estimated Per-Host Mem: 359272448
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: 342.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 450.383us 450.383us 4.01 MB 4.00 MB
09:EXCHANGE 1 1 19.514us 19.514us 4 6 40.00 KB 16.00 KB UNPARTITIONED
F04:EXCHANGE SENDER 1 1 98.335us 98.335us 9.90 KB 64.00 KB
08:AGGREGATE 1 1 2.909ms 2.909ms 4 6 34.02 MB 128.00 MB FINALIZE
07:EXCHANGE 1 1 19.413us 19.413us 4 6 64.00 KB 16.00 KB HASH(C_64656661756c745f70656f706c65.region)
F03:EXCHANGE SENDER 1 1 98.083us 98.083us 9.90 KB 64.00 KB
05:AGGREGATE 1 1 1.530ms 1.530ms 4 6 34.07 MB 128.00 MB STREAMING
04:UNION 1 1 0.000ns 0.000ns 4 6 0 0
|--02:DELETE EVENTS HASH JOIN 1 1 742.357us 742.357us 2 4 2.03 MB 1.94 MB LEFT ANTI JOIN, BROADCAST
| |--06:EXCHANGE 1 1 19.701us 19.701us 2 2 24.00 KB 16.00 KB BROADCAST
| | F02:EXCHANGE SENDER 1 1 127.467us 127.467us 6.36 KB 548.00 KB
| | 01:SCAN S3 1 1 17.718ms 17.718ms 2 2 101.03 KB 32.00 MB default.people-POSITION-DELETE-01 c_64656661756c745f70656f706c65-position-delete
| 00:SCAN S3 1 1 10.624ms 10.624ms 4 4 97.00 KB 48.00 MB default.people c_64656661756c745f70656f706c65
03:SCAN S3 1 1 13.084ms 13.084ms 2 2 125.01 KB 48.00 MB default.people c_64656661756c745f70656f706c65
Errors:
Query Compilation: 3.444ms
- Metadata of all 1 tables cached: 736.462us (736.462us)
- Analysis finished: 1.107ms (371.175us)
- Authorization finished (noop): 1.230ms (122.459us)
- Value transfer graph computed: 1.295ms (65.254us)
- Single node plan created: 2.012ms (717.486us)
- Runtime filters computed: 2.147ms (135.121us)
- Distributed plan created: 2.169ms (21.677us)
- Lineage info computed: 2.206ms (36.945us)
- Planning finished: 3.444ms (1.237ms)
Query Timeline: 183.556ms
- Query submitted: 54.270us (54.270us)
- Planning finished: 4.256ms (4.202ms)
- Submit for admission: 4.467ms (211.295us)
- Completed admission: 14.365ms (9.898ms)
- Ready to start on 1 backends: 14.529ms (163.329us)
- All 1 execution backends (4 fragment instances) started: 15.412ms (883.220us)
- Rows available: 80.904ms (65.491ms)
- First row fetched: 148.777ms (67.872ms)
- Last row fetched: 148.780ms (3.949us)
- Released admission control resources: 151.859ms (3.078ms)
- Unregister query: 183.556ms (31.697ms)
- AdmissionControlTimeSinceLastUpdate: 24.000ms
- ComputeScanRangeAssignmentTimer: 57.860us
Memory Reserve:
Frontend:
Referenced Tables: default.people
Expr memory estimated bytes: 150
- 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: 342.63 MB (359272448)
- MemoryMax: 8589934592.00 GB (9223372036854775807)
ImpalaServer:
- ClientFetchWaitTimeStats: (Avg: 67.841ms ; Min: 67.841ms ; Max: 67.841ms ; Number of samples: 1)
- GetInFlightProfileTimeStats: 0.000ns (Number of samples: 0)
- ClientFetchLockWaitTimer: 251.000ns
- ClientFetchWaitTimer: 67.841ms
- NumRowsFetched: 4 (4)
- NumRowsFetchedFromCache: 0 (0)
- RPCCount: 8 (8)
- RPCReadTimer: 19.000us
- RPCWriteTimer: 564.000us
- RowMaterializationRate: 1.20 K/sec
- RowMaterializationTimer: 3.341ms
Execution Profile 7a4d8709f8ad3b25:c0c8559300000000:
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.30 MB)
Per Node Bytes Read: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(5.68 KB)
Per Node User Time: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(120.540ms)
Per Node System Time: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000(16.498ms)
- ExchangeScanRatio: 0.06
- FiltersReceived: 0 (0)
- FinalizationTimer: 0.000ns
- InnerNodeSelectivityRatio: 0.24
- NumBackends: 1 (1)
- NumCompletedBackends: 1 (1)
- NumFragmentInstances: 4 (4)
- NumFragments: 4 (4)
- TotalBytesRead: 5.68 KB (5813)
- TotalBytesSent: 452.00 B (452)
- TotalCpuTime: 137.038ms
- TotalInnerBytesSent: 88.00 B (88)
- TotalScanBytesSent: 364.00 B (364)
Per Node Profiles:
impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000:
- HostCpuIoWaitPercentage (50.000ms): 0, 0, 0
- HostCpuSysPercentage (50.000ms): 0, 0, 0
- HostCpuUserPercentage (50.000ms): 1, 1, 1
- HostDiskReadThroughput (50.000ms): 0.00 /sec, 0.00 /sec, 0.00 /sec
- HostDiskWriteThroughput (50.000ms): 87.82 KB/sec, 87.82 KB/sec, 87.82 KB/sec
- HostNetworkRx (50.000ms): 368.79 KB/sec, 368.79 KB/sec, 368.79 KB/sec
- HostNetworkTx (50.000ms): 269.76 KB/sec, 269.76 KB/sec, 269.76 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.239ms
- CodegenCacheSaveTime: 0.000ns
- CodegenCompileThreadInvoluntaryContextSwitches: 0 (0)
- CodegenCompileThreadTotalWallClockTime: 0.000ns
- CodegenCompileThreadSysTime: 0.000ns
- CodegenCompileThreadUserTime: 0.000ns
- CodegenCompileThreadVoluntaryContextSwitches: 0 (0)
- CodegenInvoluntaryContextSwitches: 1 (1)
- CodegenTotalWallClockTime: 31.295ms
- CodegenSysTime: 4.306ms
- CodegenUserTime: 23.646ms
- CodegenVoluntaryContextSwitches: 1 (1)
- CompileTime: 102.689us
- FunctionPruneTime: 2.782ms
- InactiveTotalTime: 0.000ns
- IrGenerationTime: 128.390us
- LoadTime: 0.000ns
- MainThreadCodegenTime: 5.547ms
- ModuleBitcodeGenTime: 1.162ms
- 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.756ms
- TotalTime: 31.303ms
Fragment F04:
CodeGen:
- CodegenCacheLookupTime: 1.972ms
- CodegenCacheSaveTime: 0.000ns
- CodegenCompileThreadInvoluntaryContextSwitches: 0 (0)
- CodegenCompileThreadTotalWallClockTime: 0.000ns
- CodegenCompileThreadSysTime: 0.000ns
- CodegenCompileThreadUserTime: 0.000ns
- CodegenCompileThreadVoluntaryContextSwitches: 0 (0)
- CodegenInvoluntaryContextSwitches: 1 (1)
- CodegenTotalWallClockTime: 26.292ms
- CodegenSysTime: 3.436ms
- CodegenUserTime: 20.544ms
- CodegenVoluntaryContextSwitches: 1 (1)
- CompileTime: 139.043us
- FunctionPruneTime: 2.291ms
- InactiveTotalTime: 0.000ns
- IrGenerationTime: 2.073ms
- LoadTime: 0.000ns
- MainThreadCodegenTime: 7.322ms
- ModuleBitcodeGenTime: 1.888ms
- 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.981ms
- TotalTime: 26.302ms
Fragment F03:
CodeGen:
- CodegenCacheLookupTime: 5.656ms
- CodegenCacheSaveTime: 0.000ns
- CodegenCompileThreadInvoluntaryContextSwitches: 0 (0)
- CodegenCompileThreadTotalWallClockTime: 0.000ns
- CodegenCompileThreadSysTime: 0.000ns
- CodegenCompileThreadUserTime: 0.000ns
- CodegenCompileThreadVoluntaryContextSwitches: 0 (0)
- CodegenInvoluntaryContextSwitches: 2 (2)
- CodegenTotalWallClockTime: 34.994ms
- CodegenSysTime: 0.000ns
- CodegenUserTime: 32.314ms
- CodegenVoluntaryContextSwitches: 0 (0)
- CompileTime: 178.160us
- FunctionPruneTime: 2.842ms
- InactiveTotalTime: 0.000ns
- IrGenerationTime: 7.480ms
- LoadTime: 0.000ns
- MainThreadCodegenTime: 17.502ms
- ModuleBitcodeGenTime: 5.549ms
- ModuleBitcodeSize: 3.20 MB (3355244)
- NumCachedFunctions: 37 (37)
- NumFunctions: 84 (84)
- NumInstructions: 4.48K (4476)
- NumOptimizedFunctions: 37 (37)
- NumOptimizedInstructions: 3.53K (3527)
- OptimizationTime: 0.000ns
- PeakMemoryUsage: 12.37 KB (12669)
- PrepareTime: 17.505ms
- TotalTime: 35.007ms
Fragment F02:
CodeGen:
- CodegenCacheLookupTime: 1.893ms
- CodegenCacheSaveTime: 0.000ns
- CodegenCompileThreadInvoluntaryContextSwitches: 0 (0)
- CodegenCompileThreadTotalWallClockTime: 0.000ns
- CodegenCompileThreadSysTime: 0.000ns
- CodegenCompileThreadUserTime: 0.000ns
- CodegenCompileThreadVoluntaryContextSwitches: 0 (0)
- CodegenInvoluntaryContextSwitches: 1 (1)
- CodegenTotalWallClockTime: 32.328ms
- CodegenSysTime: 0.000ns
- CodegenUserTime: 31.971ms
- CodegenVoluntaryContextSwitches: 3 (3)
- CompileTime: 58.545us
- FunctionPruneTime: 2.844ms
- InactiveTotalTime: 0.000ns
- IrGenerationTime: 392.707us
- LoadTime: 0.000ns
- MainThreadCodegenTime: 6.321ms
- ModuleBitcodeGenTime: 1.824ms
- 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.018ms
- TotalTime: 32.339ms
Averaged Fragment F05:(Total: 132.877ms, non-child: 31.584ms, % non-child: 23.77%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:135.215ms max:135.215ms mean: 135.215ms 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: 135.215ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 0.00 /sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 4.05 MB (4251648)
- PeakReservation: 4.00 MB (4194304)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.30 MB (77910114)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 33.784ms
- TotalNetworkSendTime: 0.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 132.716ms
- TotalThreadsSysTime: 4.595ms
- TotalThreadsUserTime: 27.571ms
- TotalThreadsVoluntaryContextSwitches: 7 (7)
- TotalTime: 132.877ms
Fragment Instance Lifecycle Timings:
- ExecTime: 67.923ms
- ExecTreeExecTime: 428.735us
- OpenTime: 64.801ms
- ExecTreeOpenTime: 33.368ms
- PrepareTime: 123.951us
- ExecTreePrepareTime: 78.198us
PLAN_ROOT_SINK:(Total: 67.498ms, non-child: 450.383us, % non-child: 0.67%)
- CreateResultSetTime: 3.611us
- InactiveTotalTime: 67.047ms
- PeakMemoryUsage: 4.01 MB (4202496)
- RowBatchGetWaitTime: 0.000ns
- RowBatchSendWaitTime: 0.000ns
- RowsSent: 4 (4)
- RowsSentRate: 59.00 /sec
- TotalTime: 67.498ms
Buffer pool:
- AllocTime: 16.736us
- 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: 14.819us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
EXCHANGE_NODE (id=9):(Total: 33.794ms, non-child: 19.514us, % non-child: 0.06%)
- ConvertRowBatchTime: 1.935us
- InactiveTotalTime: 33.774ms
- PeakMemoryUsage: 40.00 KB (40960)
- RowsReturned: 4 (4)
- RowsReturnedRate: 118.00 /sec
- TotalTime: 33.794ms
Buffer pool:
- AllocTime: 3.461us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 64.00 KB (65536)
- CumulativeAllocations: 8 (8)
- EncryptionTime: 0.000ns
- PeakReservation: 40.00 KB (40960)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 40.00 KB (40960)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 33.359ms
- TotalBytesDequeued: 104.00 B (104)
- TotalGetBatchTime: 33.782ms
- DataWaitTime: 33.774ms
Enqueue:
- DispatchTime: (Avg: 25.982us ; Min: 16.350us ; Max: 41.667us ; Number of samples: 4)
- DeserializeRowBatchTime: 11.553us
- TotalBatchesEnqueued: 4 (4)
- TotalBatchesReceived: 4 (4)
- TotalBytesReceived: 88.00 B (88)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
Coordinator Fragment F05:
Instance 7a4d8709f8ad3b25:c0c8559300000000 (host=impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000):
Last report received time: 2025-09-01 17:28:52.039
Fragment Instance Lifecycle Event Timeline: 133.339ms
- Prepare Finished: 554.241us (554.241us)
- Open Finished: 65.371ms (64.817ms)
- First Batch Produced: 65.801ms (429.850us)
- First Batch Sent: 66.215ms (413.575us)
- ExecInternal Finished: 133.339ms (67.124ms)
- MemoryUsage (50.000ms): 8.00 KB, 4.02 MB, 4.02 MB
- AverageThreadTokens: 0.00
- BytesAssigned: 0
- CompletionTime: 135.215ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 0.00 /sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 4.05 MB (4251648)
- PeakReservation: 4.00 MB (4194304)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.30 MB (77910114)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 33.784ms
- TotalNetworkSendTime: 0.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 132.716ms
- TotalThreadsSysTime: 4.595ms
- TotalThreadsUserTime: 27.571ms
- TotalThreadsVoluntaryContextSwitches: 7 (7)
- TotalTime: 132.877ms
Fragment Instance Lifecycle Timings:
- ExecTime: 67.923ms
- ExecTreeExecTime: 428.735us
- OpenTime: 64.801ms
- ExecTreeOpenTime: 33.368ms
- PrepareTime: 123.951us
- ExecTreePrepareTime: 78.198us
PLAN_ROOT_SINK:
- CreateResultSetTime: 3.611us
- InactiveTotalTime: 67.047ms
- PeakMemoryUsage: 4.01 MB (4202496)
- RowBatchGetWaitTime: 0.000ns
- RowBatchSendWaitTime: 0.000ns
- RowsSent: 4 (4)
- RowsSentRate: 59.00 /sec
- TotalTime: 67.498ms
Buffer pool:
- AllocTime: 16.736us
- 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: 14.819us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
EXCHANGE_NODE (id=9):
Node Lifecycle Event Timeline: 66.235ms
- Open Started: 31.935ms (31.935ms)
- Open Finished: 65.301ms (33.365ms)
- First Batch Requested: 65.373ms (72.455us)
- First Batch Returned: 65.800ms (426.499us)
- Last Batch Returned: 65.800ms (285.000ns)
- Closed: 66.235ms (434.808us)
- ConvertRowBatchTime: 1.935us
- InactiveTotalTime: 33.774ms
- PeakMemoryUsage: 40.00 KB (40960)
- RowsReturned: 4 (4)
- RowsReturnedRate: 118.00 /sec
- TotalTime: 33.794ms
Buffer pool:
- AllocTime: 3.461us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 64.00 KB (65536)
- CumulativeAllocations: 8 (8)
- EncryptionTime: 0.000ns
- PeakReservation: 40.00 KB (40960)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 40.00 KB (40960)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 33.359ms
- TotalBytesDequeued: 104.00 B (104)
- TotalGetBatchTime: 33.782ms
- DataWaitTime: 33.774ms
Enqueue:
- DispatchTime: (Avg: 25.982us ; Min: 16.350us ; Max: 41.667us ; Number of samples: 4)
- DeserializeRowBatchTime: 11.553us
- TotalBatchesEnqueued: 4 (4)
- TotalBatchesReceived: 4 (4)
- TotalBytesReceived: 88.00 B (88)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
Averaged Fragment F04:(Total: 65.521ms, non-child: 26.541ms, % non-child: 40.51%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:135.305ms max:135.305ms mean: 135.305ms 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: 135.305ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 0.00 /sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.10 MB (35761120)
- PeakReservation: 34.00 MB (35651584)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.30 MB (77910114)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 35.436ms
- TotalNetworkSendTime: 524.111us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 65.253ms
- TotalThreadsSysTime: 7.420ms
- TotalThreadsUserTime: 22.189ms
- TotalThreadsVoluntaryContextSwitches: 7 (7)
- TotalTime: 65.521ms
Fragment Instance Lifecycle Timings:
- ExecTime: 700.360us
- ExecTreeExecTime: 63.415us
- OpenTime: 64.559ms
- ExecTreeOpenTime: 38.185ms
- PrepareTime: 201.212us
- ExecTreePrepareTime: 113.293us
KrpcDataStreamSender (dst_id=9):(Total: 622.447us, non-child: 98.335us, % non-child: 15.80%)
- NetworkThroughput: (Avg: 273.03 KB/sec ; Min: 145.07 KB/sec ; Max: 474.79 KB/sec ; Number of samples: 4)
- RpcNetworkTime: (Avg: 86.537us ; Min: 49.364us ; Max: 141.364us ; Number of samples: 5)
- RpcRecvrTime: (Avg: 33.552us ; Min: 24.427us ; Max: 57.809us ; Number of samples: 5)
- EosSent: 1 (1)
- InactiveTotalTime: 524.111us
- PeakMemoryUsage: 9.90 KB (10142)
- RowsSent: 4 (4)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 4.895us
- TotalBytesSent: 88.00 B (88)
- TotalTime: 622.447us
- UncompressedRowBatchSize: 104.00 B (104)
AGGREGATION_NODE (id=8):(Total: 38.357ms, non-child: 2.909ms, % non-child: 7.58%)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.02 MB (35677312)
- RowsReturned: 4 (4)
- RowsReturnedRate: 104.00 /sec
- TotalTime: 38.357ms
GroupingAggregator 0:
- BuildTime: 1.568ms
- GetResultsTime: 26.711us
- HTResizeTime: 707.000ns
- LargestPartitionPercent: 25 (25)
- 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: 4 (4)
- SpilledPartitions: 0 (0)
Buffer pool:
- AllocTime: 72.582us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 10.00 MB (10485760)
- CumulativeAllocations: 5 (5)
- EncryptionTime: 0.000ns
- PeakReservation: 34.00 MB (35651584)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 10.00 MB (10485760)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 67.102us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Table:
- HashBuckets: 4.10K (4096)
- HashCollisions: 0 (0)
- Probes: 4 (4)
- Resizes: 0 (0)
- Travel: 0 (0)
EXCHANGE_NODE (id=7):(Total: 35.448ms, non-child: 19.413us, % non-child: 0.05%)
- ConvertRowBatchTime: 1.862us
- InactiveTotalTime: 35.428ms
- PeakMemoryUsage: 64.00 KB (65536)
- RowsReturned: 4 (4)
- RowsReturnedRate: 112.00 /sec
- TotalTime: 35.448ms
Buffer pool:
- AllocTime: 6.907us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 64.00 KB (65536)
- CumulativeAllocations: 8 (8)
- EncryptionTime: 0.000ns
- PeakReservation: 64.00 KB (65536)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 64.00 KB (65536)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 2.788us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 35.428ms
- TotalBytesDequeued: 104.00 B (104)
- TotalGetBatchTime: 35.434ms
- DataWaitTime: 35.428ms
Enqueue:
- DispatchTime: (Avg: 25.025us ; Min: 15.871us ; Max: 44.340us ; Number of samples: 4)
- DeserializeRowBatchTime: 16.888us
- TotalBatchesEnqueued: 4 (4)
- TotalBatchesReceived: 4 (4)
- TotalBytesReceived: 88.00 B (88)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
Fragment F04:
Instance 7a4d8709f8ad3b25:c0c8559300000003 (host=impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000):
Last report received time: 2025-09-01 17:28:52.039
Fragment Instance Lifecycle Event Timeline: 65.843ms
- Prepare Finished: 571.837us (571.837us)
- Open Finished: 65.137ms (64.565ms)
- First Batch Produced: 65.152ms (14.992us)
- First Batch Sent: 65.183ms (31.702us)
- ExecInternal Finished: 65.843ms (659.677us)
- MemoryUsage (50.000ms): 34.97 KB
- ThreadUsage (50.000ms): 1
- AverageThreadTokens: 1.00
- BytesAssigned: 0
- CompletionTime: 135.305ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 0.00 /sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.10 MB (35761120)
- PeakReservation: 34.00 MB (35651584)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.30 MB (77910114)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 35.436ms
- TotalNetworkSendTime: 524.111us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 65.253ms
- TotalThreadsSysTime: 7.420ms
- TotalThreadsUserTime: 22.189ms
- TotalThreadsVoluntaryContextSwitches: 7 (7)
- TotalTime: 65.521ms
Fragment Instance Lifecycle Timings:
- ExecTime: 700.360us
- ExecTreeExecTime: 63.415us
- OpenTime: 64.559ms
- ExecTreeOpenTime: 38.185ms
- PrepareTime: 201.212us
- ExecTreePrepareTime: 113.293us
KrpcDataStreamSender (dst_id=9):
ExecOption: Unpartitioned Sender Codegen Disabled: not needed
- BytesSent (50.000ms): 0
- NetworkThroughput: (Avg: 273.03 KB/sec ; Min: 145.07 KB/sec ; Max: 474.79 KB/sec ; Number of samples: 4)
- RpcNetworkTime: (Avg: 86.537us ; Min: 49.364us ; Max: 141.364us ; Number of samples: 5)
- RpcRecvrTime: (Avg: 33.552us ; Min: 24.427us ; Max: 57.809us ; Number of samples: 5)
- EosSent: 1 (1)
- InactiveTotalTime: 524.111us
- PeakMemoryUsage: 9.90 KB (10142)
- RowsSent: 4 (4)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 4.895us
- TotalBytesSent: 88.00 B (88)
- TotalTime: 622.447us
- UncompressedRowBatchSize: 104.00 B (104)
AGGREGATION_NODE (id=8):
Node Lifecycle Event Timeline: 65.705ms
- Open Started: 26.940ms (26.940ms)
- Open Finished: 65.122ms (38.181ms)
- First Batch Requested: 65.138ms (16.461us)
- First Batch Returned: 65.151ms (12.950us)
- Last Batch Returned: 65.669ms (518.065us)
- Closed: 65.705ms (35.610us)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.02 MB (35677312)
- RowsReturned: 4 (4)
- RowsReturnedRate: 104.00 /sec
- TotalTime: 38.357ms
GroupingAggregator 0:
ExecOption: Codegen Enabled
- BuildTime: 1.568ms
- GetResultsTime: 26.711us
- HTResizeTime: 707.000ns
- LargestPartitionPercent: 25 (25)
- 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: 4 (4)
- SpilledPartitions: 0 (0)
Buffer pool:
- AllocTime: 72.582us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 10.00 MB (10485760)
- CumulativeAllocations: 5 (5)
- EncryptionTime: 0.000ns
- PeakReservation: 34.00 MB (35651584)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 10.00 MB (10485760)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 67.102us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Table:
- HashBuckets: 4.10K (4096)
- HashCollisions: 0 (0)
- Probes: 4 (4)
- Resizes: 0 (0)
- Travel: 0 (0)
EXCHANGE_NODE (id=7):
Node Lifecycle Event Timeline: 64.827ms
- Open Started: 26.942ms (26.942ms)
- Open Finished: 62.377ms (35.435ms)
- First Batch Requested: 63.226ms (848.161us)
- First Batch Returned: 63.235ms (9.673us)
- Last Batch Returned: 63.236ms (277.000ns)
- Closed: 64.827ms (1.591ms)
- ConvertRowBatchTime: 1.862us
- InactiveTotalTime: 35.428ms
- PeakMemoryUsage: 64.00 KB (65536)
- RowsReturned: 4 (4)
- RowsReturnedRate: 112.00 /sec
- TotalTime: 35.448ms
Buffer pool:
- AllocTime: 6.907us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 64.00 KB (65536)
- CumulativeAllocations: 8 (8)
- EncryptionTime: 0.000ns
- PeakReservation: 64.00 KB (65536)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 64.00 KB (65536)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 2.788us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 35.428ms
- TotalBytesDequeued: 104.00 B (104)
- TotalGetBatchTime: 35.434ms
- DataWaitTime: 35.428ms
Enqueue:
- DispatchTime: (Avg: 25.025us ; Min: 15.871us ; Max: 44.340us ; Number of samples: 4)
- DeserializeRowBatchTime: 16.888us
- TotalBatchesEnqueued: 4 (4)
- TotalBatchesReceived: 4 (4)
- TotalBytesReceived: 88.00 B (88)
- TotalEarlySenders: 0 (0)
- TotalEosReceived: 1 (1)
- TotalHasDeferredRPCsTime: 0.000ns
- TotalRPCsDeferred: 0 (0)
Averaged Fragment F03:(Total: 62.537ms, non-child: 35.277ms, % non-child: 56.41%)
split sizes: min: 2.39 KB, max: 2.39 KB, avg: 2.39 KB, stddev: 0
completion times: min:135.385ms max:135.385ms mean: 135.385ms stddev:0.000ns
execution rates: min:17.62 KB/sec max:17.62 KB/sec mean:17.62 KB/sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 1.00
- BytesAssigned: 2.39 KB (2443)
- CompletionTime: 135.385ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 17.62 KB/sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 36.13 MB (37888224)
- PeakReservation: 35.96 MB (37707776)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.30 MB (77910114)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 737.216us
- TotalNetworkSendTime: 436.740us
- TotalStorageWaitTime: 31.866ms
- TotalThreadsInvoluntaryContextSwitches: 2 (2)
- TotalThreadsTotalWallClockTime: 97.887ms
- TotalThreadsSysTime: 4.483ms
- TotalThreadsUserTime: 35.759ms
- TotalThreadsVoluntaryContextSwitches: 34 (34)
- TotalTime: 62.537ms
Fragment Instance Lifecycle Timings:
- ExecTime: 26.723ms
- ExecTreeExecTime: 26.160ms
- OpenTime: 35.314ms
- ExecTreeOpenTime: 228.157us
- PrepareTime: 470.683us
- ExecTreePrepareTime: 340.399us
KrpcDataStreamSender (dst_id=7):(Total: 534.823us, non-child: 98.083us, % non-child: 18.34%)
- NetworkThroughput: (Avg: 338.86 KB/sec ; Min: 131.89 KB/sec ; Max: 424.46 KB/sec ; Number of samples: 4)
- RpcNetworkTime: (Avg: 74.005us ; Min: 48.147us ; Max: 162.901us ; Number of samples: 5)
- RpcRecvrTime: (Avg: 30.066us ; Min: 19.439us ; Max: 61.693us ; Number of samples: 5)
- EosSent: 1 (1)
- InactiveTotalTime: 436.740us
- PeakMemoryUsage: 9.90 KB (10142)
- RowsSent: 4 (4)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 5.517us
- TotalBytesSent: 88.00 B (88)
- TotalTime: 534.823us
- UncompressedRowBatchSize: 104.00 B (104)
AGGREGATION_NODE (id=5):(Total: 26.725ms, non-child: 1.530ms, % non-child: 5.73%)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.07 MB (35723392)
- RowsReturned: 4 (4)
- RowsReturnedRate: 149.00 /sec
- TotalTime: 26.725ms
GroupingAggregator 0:
- BuildTime: 0.000ns
- GetResultsTime: 26.718us
- HTResizeTime: 0.000ns
- LargestPartitionPercent: 25 (25)
- 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: 4 (4)
- StreamingTime: 1.186ms
Buffer pool:
- AllocTime: 58.943us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 10.00 MB (10485760)
- CumulativeAllocations: 5 (5)
- EncryptionTime: 0.000ns
- PeakReservation: 34.00 MB (35651584)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 10.00 MB (10485760)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 50.542us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Table:
- HashBuckets: 4.10K (4096)
- HashCollisions: 0 (0)
- Probes: 4 (4)
- Resizes: 0 (0)
- Travel: 0 (0)
UNION_NODE (id=4):(Total: 25.093ms, non-child: 0.000ns, % non-child: 0.00%)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 0
- RowsReturned: 4 (4)
- RowsReturnedRate: 159.00 /sec
- TotalTime: 25.093ms
HASH_JOIN_NODE (id=2):(Total: 12.110ms, non-child: 742.357us, % non-child: 6.13%)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 2.03 MB (2131200)
- ProbeRows: 4 (4)
- ProbeRowsPartitioned: 0 (0)
- ProbeTime: 4.043us
- RowsReturned: 2 (2)
- RowsReturnedRate: 165.00 /sec
- TotalTime: 12.110ms
Buffer pool:
- AllocTime: 18.328us
- 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: 16.318us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Join Builder (join_node_id=2):(Total: 349.586us, non-child: 349.586us, % non-child: 100.00%)
- BuildRows: 2 (2)
- BuildRowsPartitionTime: 24.094us
- HashTablesBuildTime: 21.775us
- 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: 349.586us
Hash Table:
- HashBuckets: 2 (2)
- HashCollisions: 0 (0)
- Probes: 4 (4)
- Resizes: 0 (0)
- Travel: 0 (0)
EXCHANGE_NODE (id=6):(Total: 749.515us, non-child: 19.701us, % non-child: 2.63%)
- ConvertRowBatchTime: 2.513us
- InactiveTotalTime: 729.814us
- PeakMemoryUsage: 24.00 KB (24576)
- RowsReturned: 2 (2)
- RowsReturnedRate: 2.67 K/sec
- TotalTime: 749.515us
Buffer pool:
- AllocTime: 6.306us
- 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: 1.109us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 0.000ns
- TotalBytesDequeued: 284.00 B (284)
- TotalGetBatchTime: 735.241us
- DataWaitTime: 729.814us
Enqueue:
- DispatchTime: (Avg: 70.815us ; Min: 36.825us ; Max: 104.805us ; Number of samples: 2)
- DeserializeRowBatchTime: 16.447us
- 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: 10.624ms, non-child: 10.624ms, % non-child: 100.00%)
- ColumnarScannerActualReservation: (Avg: 24.00 KB (24576) ; Min: 24.00 KB (24576) ; Max: 24.00 KB (24576) ; Number of samples: 1)
- ColumnarScannerIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 1)
- FooterProcessingTime: (Avg: 4.639ms ; Min: 4.639ms ; Max: 4.639ms ; Number of samples: 1)
- InitialRangeActualReservation: (Avg: 24.00 KB (24576) ; Min: 24.00 KB (24576) ; Max: 24.00 KB (24576) ; 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: (Avg: 19.00 B (19) ; Min: 19.00 B (19) ; Max: 19.00 B (19) ; Number of samples: 1)
- ParquetCompressedPageSize: (Avg: 19.00 B (19) ; Min: 19.00 B (19) ; Max: 19.00 B (19) ; Number of samples: 1)
- ParquetUncompressedBytesReadPerColumn: (Avg: 10.00 B (10) ; Min: 10.00 B (10) ; Max: 10.00 B (10) ; Number of samples: 1)
- ParquetUncompressedPageSize: (Avg: 10.00 B (10) ; Min: 10.00 B (10) ; Max: 10.00 B (10) ; Number of samples: 1)
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 916.00 B (916)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 2 (2)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 5.049us
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 94.00 B (94)
- IoReadAsyncRequest: 4 (4)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 0
- IoReadSyncRequest: 0 (0)
- IoReadTotalBytes: 94.00 B (94)
- IoReadTotalRequest: 4 (4)
- MaterializeTupleTime: 45.837us
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 1 (1)
- NumDictFilteredRowGroups: 0 (0)
- NumDisksAccessed: 1 (1)
- NumFileMetadataRead: 0 (0)
- NumPages: 1 (1)
- 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: 0 (0)
- PeakMemoryUsage: 97.00 KB (99328)
- PeakScannerThreadConcurrency: 1 (1)
- PerReadThreadRawHdfsThroughput: 98.24 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 45.00 KB (46080)
- RowBatchQueueGetWaitTime: 9.987ms
- RowBatchQueuePeakMemoryUsage: 69.00 KB (70656)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 3 (3)
- RowsRead: 4 (4)
- RowsReturned: 4 (4)
- RowsReturnedRate: 376.00 /sec
- ScanRangesComplete: 1 (1)
- ScannerIoWaitTime: 9.351ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 10.173ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 598.000us
- ScannerThreadsVoluntaryContextSwitches: 3 (3)
- TotalRawHdfsOpenFileTime: 6.768us
- TotalRawHdfsReadTime: 9.105ms
- TotalReadThroughput: 0.00 /sec
- TotalTime: 10.624ms
Buffer pool:
- AllocTime: 2.912us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 16.00 KB (16384)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 24.00 KB (24576)
- 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: 13.084ms, non-child: 13.084ms, % non-child: 100.00%)
- ColumnarScannerActualReservation: (Avg: 24.00 KB (24576) ; Min: 24.00 KB (24576) ; Max: 24.00 KB (24576) ; Number of samples: 2)
- ColumnarScannerIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 2)
- FooterProcessingTime: (Avg: 5.083ms ; Min: 4.677ms ; Max: 5.489ms ; Number of samples: 2)
- InitialRangeActualReservation: (Avg: 24.00 KB (24576) ; Min: 24.00 KB (24576) ; Max: 24.00 KB (24576) ; 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: 1)
- ParquetCompressedPageSize: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 2)
- ParquetUncompressedBytesReadPerColumn: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 1)
- ParquetUncompressedPageSize: (Avg: 9.00 B (9) ; Min: 9.00 B (9) ; Max: 9.00 B (9) ; Number of samples: 2)
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 1.71 KB (1751)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 4 (4)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 6.906us
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 130.00 B (130)
- IoReadAsyncRequest: 8 (8)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 0
- IoReadSyncRequest: 0 (0)
- IoReadTotalBytes: 130.00 B (130)
- IoReadTotalRequest: 8 (8)
- MaterializeTupleTime: 69.958us
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 1 (1)
- 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: 0 (0)
- PeakMemoryUsage: 125.01 KB (128012)
- PeakScannerThreadConcurrency: 2 (2)
- PerReadThreadRawHdfsThroughput: 78.43 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 90.00 KB (92160)
- RowBatchQueueGetWaitTime: 12.351ms
- RowBatchQueuePeakMemoryUsage: 45.00 KB (46080)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 6 (6)
- RowsRead: 2 (2)
- RowsReturned: 2 (2)
- RowsReturnedRate: 152.00 /sec
- ScanRangesComplete: 2 (2)
- ScannerIoWaitTime: 22.515ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 24.569ms
- ScannerThreadsSysTime: 628.000us
- ScannerThreadsUserTime: 613.000us
- ScannerThreadsVoluntaryContextSwitches: 12 (12)
- TotalRawHdfsOpenFileTime: 11.968us
- TotalRawHdfsReadTime: 21.803ms
- TotalReadThroughput: 0.00 /sec
- TotalTime: 13.084ms
Buffer pool:
- AllocTime: 18.438us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 32.00 KB (32768)
- CumulativeAllocations: 4 (4)
- EncryptionTime: 0.000ns
- PeakReservation: 48.00 KB (49152)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 16.00 KB (16384)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 11.282us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Fragment F03:
Instance 7a4d8709f8ad3b25:c0c8559300000002 (host=impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000):
Last report received time: 2025-09-01 17:28:52.039
Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:3/2.39 KB
Fragment Instance Lifecycle Event Timeline: 62.786ms
- Prepare Finished: 739.250us (739.250us)
- Open Finished: 36.056ms (35.317ms)
- First Batch Produced: 62.180ms (26.124ms)
- First Batch Sent: 62.182ms (2.115us)
- ExecInternal Finished: 62.786ms (604.320us)
- MemoryUsage (50.000ms): 103.22 KB
- ThreadUsage (50.000ms): 1
- AverageThreadTokens: 1.00
- BytesAssigned: 2.39 KB (2443)
- CompletionTime: 135.385ms
- ExchangeScanRatio: 0.03
- ExecutionRate: 17.62 KB/sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 36.13 MB (37888224)
- PeakReservation: 35.96 MB (37707776)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.30 MB (77910114)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 737.216us
- TotalNetworkSendTime: 436.740us
- TotalStorageWaitTime: 31.866ms
- TotalThreadsInvoluntaryContextSwitches: 2 (2)
- TotalThreadsTotalWallClockTime: 97.887ms
- TotalThreadsSysTime: 4.483ms
- TotalThreadsUserTime: 35.759ms
- TotalThreadsVoluntaryContextSwitches: 34 (34)
- TotalTime: 62.537ms
Fragment Instance Lifecycle Timings:
- ExecTime: 26.723ms
- ExecTreeExecTime: 26.160ms
- OpenTime: 35.314ms
- ExecTreeOpenTime: 228.157us
- PrepareTime: 470.683us
- ExecTreePrepareTime: 340.399us
KrpcDataStreamSender (dst_id=7):
ExecOption: Hash Partitioned Sender Codegen Enabled
- BytesSent (50.000ms): 0
- NetworkThroughput: (Avg: 338.86 KB/sec ; Min: 131.89 KB/sec ; Max: 424.46 KB/sec ; Number of samples: 4)
- RpcNetworkTime: (Avg: 74.005us ; Min: 48.147us ; Max: 162.901us ; Number of samples: 5)
- RpcRecvrTime: (Avg: 30.066us ; Min: 19.439us ; Max: 61.693us ; Number of samples: 5)
- EosSent: 1 (1)
- InactiveTotalTime: 436.740us
- PeakMemoryUsage: 9.90 KB (10142)
- RowsSent: 4 (4)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 5.517us
- TotalBytesSent: 88.00 B (88)
- TotalTime: 534.823us
- UncompressedRowBatchSize: 104.00 B (104)
AGGREGATION_NODE (id=5):
Node Lifecycle Event Timeline: 62.666ms
- Open Started: 35.822ms (35.822ms)
- Open Finished: 36.049ms (226.354us)
- First Batch Requested: 36.057ms (8.567us)
- First Batch Returned: 62.178ms (26.120ms)
- Last Batch Returned: 62.624ms (446.094us)
- Closed: 62.666ms (41.792us)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 34.07 MB (35723392)
- RowsReturned: 4 (4)
- RowsReturnedRate: 149.00 /sec
- TotalTime: 26.725ms
GroupingAggregator 0:
ExecOption: Streaming Preaggregation, Codegen Enabled
- BuildTime: 0.000ns
- GetResultsTime: 26.718us
- HTResizeTime: 0.000ns
- LargestPartitionPercent: 25 (25)
- 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: 4 (4)
- StreamingTime: 1.186ms
Buffer pool:
- AllocTime: 58.943us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 10.00 MB (10485760)
- CumulativeAllocations: 5 (5)
- EncryptionTime: 0.000ns
- PeakReservation: 34.00 MB (35651584)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 10.00 MB (10485760)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 50.542us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Hash Table:
- HashBuckets: 4.10K (4096)
- HashCollisions: 0 (0)
- Probes: 4 (4)
- Resizes: 0 (0)
- Travel: 0 (0)
UNION_NODE (id=4):
ExecOption: Codegen Enabled
Node Lifecycle Event Timeline: 62.069ms
- Open Started: 35.825ms (35.825ms)
- Open Finished: 35.881ms (56.639us)
- First Batch Requested: 36.059ms (177.856us)
- First Batch Returned: 48.457ms (12.397ms)
- Last Batch Returned: 61.271ms (12.814ms)
- Closed: 62.069ms (797.797us)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 0
- RowsReturned: 4 (4)
- RowsReturnedRate: 159.00 /sec
- TotalTime: 25.093ms
HASH_JOIN_NODE (id=2):
ExecOption: Join Build-Side Prepared Asynchronously, Probe Side Codegen Enabled
Node Lifecycle Event Timeline: 62.067ms
- Open Started: 49.484ms (49.484ms)
- Open Finished: 61.020ms (11.536ms)
- First Batch Requested: 61.023ms (2.670us)
- First Batch Returned: 61.269ms (245.902us)
- Last Batch Returned: 61.269ms (190.000ns)
- Closed: 62.067ms (797.775us)
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 2.03 MB (2131200)
- ProbeRows: 4 (4)
- ProbeRowsPartitioned: 0 (0)
- ProbeTime: 4.043us
- RowsReturned: 2 (2)
- RowsReturnedRate: 165.00 /sec
- TotalTime: 12.110ms
Buffer pool:
- AllocTime: 18.328us
- 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: 16.318us
- 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: 24.094us
- HashTablesBuildTime: 21.775us
- 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: 349.586us
Hash Table:
- HashBuckets: 2 (2)
- HashCollisions: 0 (0)
- Probes: 4 (4)
- Resizes: 0 (0)
- Travel: 0 (0)
EXCHANGE_NODE (id=6):
Node Lifecycle Event Timeline: 50.699ms
- Open Started: 49.582ms (49.582ms)
- Open Finished: 49.585ms (3.723us)
- First Batch Requested: 49.793ms (208.124us)
- First Batch Returned: 50.535ms (741.699us)
- Last Batch Returned: 50.536ms (517.000ns)
- Closed: 50.699ms (163.682us)
- ConvertRowBatchTime: 2.513us
- InactiveTotalTime: 729.814us
- PeakMemoryUsage: 24.00 KB (24576)
- RowsReturned: 2 (2)
- RowsReturnedRate: 2.67 K/sec
- TotalTime: 749.515us
Buffer pool:
- AllocTime: 6.306us
- 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: 1.109us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Dequeue:
- FirstBatchWaitTime: 0.000ns
- TotalBytesDequeued: 284.00 B (284)
- TotalGetBatchTime: 735.241us
- DataWaitTime: 729.814us
Enqueue:
- DispatchTime: (Avg: 70.815us ; Min: 36.825us ; Max: 104.805us ; Number of samples: 2)
- DeserializeRowBatchTime: 16.447us
- 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/ZSTD:1
ExecOption: Codegen enabled: 1 out of 1, PARQUET Codegen Enabled
Node Lifecycle Event Timeline: 62.064ms
- Open Started: 49.582ms (49.582ms)
- Open Finished: 49.647ms (64.575us)
- First Batch Requested: 50.741ms (1.093ms)
- First Batch Returned: 61.018ms (10.276ms)
- Last Batch Returned: 61.239ms (221.057us)
- Closed: 62.064ms (824.729us)
- BytesReadSeries (50.000ms): 0
- ColumnarScannerActualReservation: (Avg: 24.00 KB (24576) ; Min: 24.00 KB (24576) ; Max: 24.00 KB (24576) ; Number of samples: 1)
- ColumnarScannerIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 1)
- FooterProcessingTime: (Avg: 4.639ms ; Min: 4.639ms ; Max: 4.639ms ; Number of samples: 1)
- InitialRangeActualReservation: (Avg: 24.00 KB (24576) ; Min: 24.00 KB (24576) ; Max: 24.00 KB (24576) ; 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: (Avg: 19.00 B (19) ; Min: 19.00 B (19) ; Max: 19.00 B (19) ; Number of samples: 1)
- ParquetCompressedPageSize: (Avg: 19.00 B (19) ; Min: 19.00 B (19) ; Max: 19.00 B (19) ; Number of samples: 1)
- ParquetUncompressedBytesReadPerColumn: (Avg: 10.00 B (10) ; Min: 10.00 B (10) ; Max: 10.00 B (10) ; Number of samples: 1)
- ParquetUncompressedPageSize: (Avg: 10.00 B (10) ; Min: 10.00 B (10) ; Max: 10.00 B (10) ; Number of samples: 1)
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 916.00 B (916)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 2 (2)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 5.049us
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 94.00 B (94)
- IoReadAsyncRequest: 4 (4)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 0
- IoReadSyncRequest: 0 (0)
- IoReadTotalBytes: 94.00 B (94)
- IoReadTotalRequest: 4 (4)
- MaterializeTupleTime: 45.837us
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 1 (1)
- NumDictFilteredRowGroups: 0 (0)
- NumDisksAccessed: 1 (1)
- NumFileMetadataRead: 0 (0)
- NumPages: 1 (1)
- 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: 0 (0)
- PeakMemoryUsage: 97.00 KB (99328)
- PeakScannerThreadConcurrency: 1 (1)
- PerReadThreadRawHdfsThroughput: 98.24 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 45.00 KB (46080)
- RowBatchQueueGetWaitTime: 9.987ms
- RowBatchQueuePeakMemoryUsage: 69.00 KB (70656)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 3 (3)
- RowsRead: 4 (4)
- RowsReturned: 4 (4)
- RowsReturnedRate: 376.00 /sec
- ScanRangesComplete: 1 (1)
- ScannerIoWaitTime: 9.351ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 10.173ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 598.000us
- ScannerThreadsVoluntaryContextSwitches: 3 (3)
- TotalRawHdfsOpenFileTime: 6.768us
- TotalRawHdfsReadTime: 9.105ms
- TotalReadThroughput: 0.00 /sec
- TotalTime: 10.624ms
Buffer pool:
- AllocTime: 2.912us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 16.00 KB (16384)
- CumulativeAllocations: 2 (2)
- EncryptionTime: 0.000ns
- PeakReservation: 24.00 KB (24576)
- 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: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/ZSTD:2
ExecOption: Codegen enabled: 2 out of 2, PARQUET Codegen Enabled
Node Lifecycle Event Timeline: 49.483ms
- Open Started: 35.827ms (35.827ms)
- Open Finished: 35.881ms (53.531us)
- First Batch Requested: 36.061ms (180.124us)
- First Batch Returned: 48.454ms (12.393ms)
- Last Batch Returned: 49.464ms (1.010ms)
- Closed: 49.483ms (18.392us)
- BytesReadSeries (50.000ms): 0
- ColumnarScannerActualReservation: (Avg: 24.00 KB (24576) ; Min: 24.00 KB (24576) ; Max: 24.00 KB (24576) ; Number of samples: 2)
- ColumnarScannerIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 2)
- FooterProcessingTime: (Avg: 5.083ms ; Min: 4.677ms ; Max: 5.489ms ; Number of samples: 2)
- InitialRangeActualReservation: (Avg: 24.00 KB (24576) ; Min: 24.00 KB (24576) ; Max: 24.00 KB (24576) ; 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: 1)
- ParquetCompressedPageSize: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 2)
- ParquetUncompressedBytesReadPerColumn: (Avg: 18.00 B (18) ; Min: 18.00 B (18) ; Max: 18.00 B (18) ; Number of samples: 1)
- ParquetUncompressedPageSize: (Avg: 9.00 B (9) ; Min: 9.00 B (9) ; Max: 9.00 B (9) ; Number of samples: 2)
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 1.71 KB (1751)
- BytesReadDataNodeCache: 0
- BytesReadEncrypted: 0
- BytesReadErasureCoded: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 4 (4)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- DecompressionTime: 6.906us
- InactiveTotalTime: 0.000ns
- IoReadAsyncBytes: 130.00 B (130)
- IoReadAsyncRequest: 8 (8)
- IoReadSkippedBytes: 0
- IoReadSyncBytes: 0
- IoReadSyncRequest: 0 (0)
- IoReadTotalBytes: 130.00 B (130)
- IoReadTotalRequest: 8 (8)
- MaterializeTupleTime: 69.958us
- MaxCompressedTextFileLength: 0
- NumBloomFilteredRowGroups: 0 (0)
- NumColumns: 1 (1)
- 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: 0 (0)
- PeakMemoryUsage: 125.01 KB (128012)
- PeakScannerThreadConcurrency: 2 (2)
- PerReadThreadRawHdfsThroughput: 78.43 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 90.00 KB (92160)
- RowBatchQueueGetWaitTime: 12.351ms
- RowBatchQueuePeakMemoryUsage: 45.00 KB (46080)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 6 (6)
- RowsRead: 2 (2)
- RowsReturned: 2 (2)
- RowsReturnedRate: 152.00 /sec
- ScanRangesComplete: 2 (2)
- ScannerIoWaitTime: 22.515ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 24.569ms
- ScannerThreadsSysTime: 628.000us
- ScannerThreadsUserTime: 613.000us
- ScannerThreadsVoluntaryContextSwitches: 12 (12)
- TotalRawHdfsOpenFileTime: 11.968us
- TotalRawHdfsReadTime: 21.803ms
- TotalReadThroughput: 0.00 /sec
- TotalTime: 13.084ms
Buffer pool:
- AllocTime: 18.438us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 32.00 KB (32768)
- CumulativeAllocations: 4 (4)
- EncryptionTime: 0.000ns
- PeakReservation: 48.00 KB (49152)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 16.00 KB (16384)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 11.282us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Averaged Fragment F02:(Total: 50.465ms, non-child: 32.491ms, % non-child: 64.38%)
split sizes: min: 2.63 KB, max: 2.63 KB, avg: 2.63 KB, stddev: 0
completion times: min:135.663ms max:135.663ms mean: 135.663ms stddev:0.000ns
execution rates: min:19.39 KB/sec max:19.39 KB/sec mean:19.39 KB/sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 1.00
- BytesAssigned: 2.63 KB (2694)
- CompletionTime: 135.663ms
- ExchangeScanRatio: 0.00
- ExecutionRate: 19.39 KB/sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 115.12 KB (117888)
- PeakReservation: 32.00 KB (32768)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.30 MB (77910114)
- RowsProduced: 2 (2)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 128.145us
- TotalStorageWaitTime: 27.983ms
- TotalThreadsInvoluntaryContextSwitches: 3 (3)
- TotalThreadsTotalWallClockTime: 82.029ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 35.021ms
- TotalThreadsVoluntaryContextSwitches: 23 (23)
- TotalTime: 50.465ms
Fragment Instance Lifecycle Timings:
- ExecTime: 17.810ms
- ExecTreeExecTime: 17.550ms
- OpenTime: 32.514ms
- ExecTreeOpenTime: 72.166us
- PrepareTime: 119.858us
- ExecTreePrepareTime: 55.478us
KrpcDataStreamSender (dst_id=6):(Total: 255.612us, non-child: 127.467us, % non-child: 49.87%)
- NetworkThroughput: (Avg: 743.46 KB/sec ; Min: 636.44 KB/sec ; Max: 850.49 KB/sec ; Number of samples: 2)
- RpcNetworkTime: (Avg: 152.603us ; Min: 87.603us ; Max: 211.750us ; Number of samples: 3)
- RpcRecvrTime: (Avg: 68.669us ; Min: 33.596us ; Max: 118.547us ; Number of samples: 3)
- EosSent: 1 (1)
- InactiveTotalTime: 128.145us
- PeakMemoryUsage: 6.36 KB (6510)
- RowsSent: 2 (2)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 7.085us
- TotalBytesSent: 276.00 B (276)
- TotalTime: 255.612us
- UncompressedRowBatchSize: 284.00 B (284)
HDFS_SCAN_NODE (id=1):(Total: 17.718ms, non-child: 17.718ms, % 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: 6.078ms ; Min: 5.624ms ; Max: 6.532ms ; 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: 0.00
- AverageScannerThreadConcurrency: 0.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: 8.096us
- 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: 38.150us
- 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: 101.03 KB (103456)
- PeakScannerThreadConcurrency: 2 (2)
- PerReadThreadRawHdfsThroughput: 80.73 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 66.00 KB (67584)
- RowBatchQueueGetWaitTime: 16.743ms
- RowBatchQueuePeakMemoryUsage: 45.00 KB (46080)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 6 (6)
- RowsRead: 2 (2)
- RowsReturned: 2 (2)
- RowsReturnedRate: 112.00 /sec
- ScanRangesComplete: 2 (2)
- ScannerIoWaitTime: 27.983ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 2 (2)
- ScannerThreadsTotalWallClockTime: 31.718ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 1.573ms
- ScannerThreadsVoluntaryContextSwitches: 13 (13)
- TotalRawHdfsOpenFileTime: 20.821us
- TotalRawHdfsReadTime: 38.057ms
- TotalReadThroughput: 0.00 /sec
- TotalTime: 17.718ms
Buffer pool:
- AllocTime: 27.127us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 48.00 KB (49152)
- CumulativeAllocations: 6 (6)
- EncryptionTime: 0.000ns
- PeakReservation: 32.00 KB (32768)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 32.00 KB (32768)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 16.464us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Fragment F02:
Instance 7a4d8709f8ad3b25:c0c8559300000001 (host=impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000):
Last report received time: 2025-09-01 17:28:52.039
Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:2/2.63 KB
Fragment Instance Lifecycle Event Timeline: 50.604ms
- Prepare Finished: 270.353us (270.353us)
- Open Finished: 32.786ms (32.515ms)
- First Batch Produced: 47.764ms (14.978ms)
- First Batch Sent: 47.818ms (53.816us)
- ExecInternal Finished: 50.604ms (2.786ms)
- MemoryUsage (50.000ms): 30.09 KB
- ThreadUsage (50.000ms): 1
- AverageThreadTokens: 1.00
- BytesAssigned: 2.63 KB (2694)
- CompletionTime: 135.663ms
- ExchangeScanRatio: 0.09
- ExecutionRate: 19.39 KB/sec
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 115.12 KB (117888)
- PeakReservation: 32.00 KB (32768)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 74.30 MB (77910114)
- RowsProduced: 2 (2)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 128.145us
- TotalStorageWaitTime: 27.983ms
- TotalThreadsInvoluntaryContextSwitches: 3 (3)
- TotalThreadsTotalWallClockTime: 82.029ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 35.021ms
- TotalThreadsVoluntaryContextSwitches: 23 (23)
- TotalTime: 50.465ms
Fragment Instance Lifecycle Timings:
- ExecTime: 17.810ms
- ExecTreeExecTime: 17.550ms
- OpenTime: 32.514ms
- ExecTreeOpenTime: 72.166us
- PrepareTime: 119.858us
- ExecTreePrepareTime: 55.478us
KrpcDataStreamSender (dst_id=6):
ExecOption: Unpartitioned Sender Codegen Disabled: not needed
- BytesSent (50.000ms): 0
- NetworkThroughput: (Avg: 743.46 KB/sec ; Min: 636.44 KB/sec ; Max: 850.49 KB/sec ; Number of samples: 2)
- RpcNetworkTime: (Avg: 152.603us ; Min: 87.603us ; Max: 211.750us ; Number of samples: 3)
- RpcRecvrTime: (Avg: 68.669us ; Min: 33.596us ; Max: 118.547us ; Number of samples: 3)
- EosSent: 1 (1)
- InactiveTotalTime: 128.145us
- PeakMemoryUsage: 6.36 KB (6510)
- RowsSent: 2 (2)
- RpcFailure: 0 (0)
- RpcRetry: 0 (0)
- SerializeBatchTime: 7.085us
- TotalBytesSent: 276.00 B (276)
- TotalTime: 255.612us
- 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:100% 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/ZSTD:2
ExecOption: Codegen enabled: 2 out of 2, PARQUET Codegen Enabled
Node Lifecycle Event Timeline: 50.444ms
- Open Started: 32.707ms (32.707ms)
- Open Finished: 32.778ms (70.275us)
- First Batch Requested: 32.787ms (9.649us)
- First Batch Returned: 47.761ms (14.973ms)
- Last Batch Returned: 50.426ms (2.665ms)
- Closed: 50.444ms (17.387us)
- BytesReadSeries (50.000ms): 0
- 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: 6.078ms ; Min: 5.624ms ; Max: 6.532ms ; 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: 0.00
- AverageScannerThreadConcurrency: 0.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: 8.096us
- 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: 38.150us
- 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: 101.03 KB (103456)
- PeakScannerThreadConcurrency: 2 (2)
- PerReadThreadRawHdfsThroughput: 80.73 KB/sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 66.00 KB (67584)
- RowBatchQueueGetWaitTime: 16.743ms
- RowBatchQueuePeakMemoryUsage: 45.00 KB (46080)
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 6 (6)
- RowsRead: 2 (2)
- RowsReturned: 2 (2)
- RowsReturnedRate: 112.00 /sec
- ScanRangesComplete: 2 (2)
- ScannerIoWaitTime: 27.983ms
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 2 (2)
- ScannerThreadsTotalWallClockTime: 31.718ms
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 1.573ms
- ScannerThreadsVoluntaryContextSwitches: 13 (13)
- TotalRawHdfsOpenFileTime: 20.821us
- TotalRawHdfsReadTime: 38.057ms
- TotalReadThroughput: 0.00 /sec
- TotalTime: 17.718ms
Buffer pool:
- AllocTime: 27.127us
- CompressionTime: 0.000ns
- CumulativeAllocationBytes: 48.00 KB (49152)
- CumulativeAllocations: 6 (6)
- EncryptionTime: 0.000ns
- PeakReservation: 32.00 KB (32768)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 32.00 KB (32768)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 16.464us
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns