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