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