Query (id=cf446a1ab3a5e852:1b1005de00000000): - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Summary: Session ID: 224966adbc71ec42:02e742101fa2c6ab Session Type: HIVESERVER2 HiveServer2 Protocol Version: V6 Start Time: 2022-11-03 16:39:46.849628000 End Time: 2022-11-03 16:39:53.622731000 Query Type: QUERY Query State: FINISHED Impala Query State: FINISHED Query Status: OK Impala Version: impalad version 4.1.1-RELEASE RELEASE (build 1d7b63102ebc8974e8133c964917ea8052148088) User: chenqizhu Connected User: chenqizhu Delegated User: Network Address: 10.21.0.163:36759 Default Db: default Sql Statement: select count(*) from `iceberg`.gamebox_event_iceberg where datekey='20221001' and event='play_game' Coordinator: hdfsn21n163:27000 Query Options (set by configuration): SYNC_DDL=1,MT_DOP=4,DECIMAL_V2=0,DEFAULT_JOIN_DISTRIBUTION_MODE=SHUFFLE,EXEC_TIME_LIMIT_S=300,TIMEZONE=Asia/Shanghai,CLIENT_IDENTIFIER=Impala Shell v4.1.1-RELEASE (1d7b631) built on Thu Oct 27 10:43:10 CST 2022,USE_LOCAL_TZ_FOR_UNIX_TIMESTAMP_CONVERSIONS=1,CONVERT_LEGACY_HIVE_PARQUET_UTC_TIMESTAMPS=1 Query Options (set by configuration and planner): SYNC_DDL=1,MT_DOP=4,DECIMAL_V2=0,DEFAULT_JOIN_DISTRIBUTION_MODE=SHUFFLE,EXEC_TIME_LIMIT_S=300,TIMEZONE=Asia/Shanghai,CLIENT_IDENTIFIER=Impala Shell v4.1.1-RELEASE (1d7b631) built on Thu Oct 27 10:43:10 CST 2022,USE_LOCAL_TZ_FOR_UNIX_TIMESTAMP_CONVERSIONS=1,CONVERT_LEGACY_HIVE_PARQUET_UTC_TIMESTAMPS=1,MINMAX_FILTER_THRESHOLD=0.5,MINMAX_FILTERING_LEVEL=PAGE Plan: ---------------- Max Per-Host Resource Reservation: Memory=12.00MB Threads=2 Per-Host Resource Estimates: Memory=92MB Dedicated Coordinator Resource Estimate: Memory=104MB WARNING: The following tables have potentially corrupt table statistics. Drop and re-compute statistics to resolve this problem. iceberg.gamebox_event_iceberg WARNING: The following tables are missing relevant table and/or column statistics. iceberg.gamebox_event_iceberg Analyzed query: SELECT count(*) FROM `iceberg`.gamebox_event_iceberg WHERE datekey = '20221001' AND event = 'play_game' F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Instance Resources: mem-estimate=4.02MB mem-reservation=4.00MB thread-reservation=1 PLAN-ROOT SINK | output exprs: count(*) | mem-estimate=4.00MB mem-reservation=4.00MB spill-buffer=2.00MB thread-reservation=0 | 03:AGGREGATE [FINALIZE] | output: count:merge(*) | mem-estimate=16.00KB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 03(GETNEXT), 01(OPEN) | 02:EXCHANGE [UNPARTITIONED] | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 01(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=5 instances=5 Per-Instance Resources: mem-estimate=88.02MB mem-reservation=8.00MB thread-reservation=1 01:AGGREGATE | output: count(*) | mem-estimate=16.00KB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [iceberg.gamebox_event_iceberg, RANDOM] HDFS partitions=1/1 files=5 size=481.21MB predicates: datekey = '20221001', event = 'play_game' stored statistics: table: rows=0 size=0B columns: unavailable extrapolated-rows=disabled max-scan-range-rows=0 parquet statistics predicates: datekey = '20221001', event = 'play_game' parquet dictionary predicates: datekey = '20221001', event = 'play_game' mem-estimate=88.00MB mem-reservation=8.00MB thread-reservation=0 tuple-ids=0 row-size=24B cardinality=346.96M in pipelines: 00(GETNEXT) ---------------- Estimated Per-Host Mem: 96501760 Tables Missing Stats: iceberg.gamebox_event_iceberg Tables With Corrupt Table Stats: iceberg.gamebox_event_iceberg Request Pool: root.default Per Host Min Memory Reservation: cdh40:27000(8.00 MB) cdh47:27000(8.00 MB) hdfsn21n234:27000(8.00 MB) hdfsn21n86:27000(8.00 MB) hdfsn21n163:27000(4.00 MB) cdh75:27000(8.00 MB) Per Host Number of Fragment Instances: cdh40:27000(1) cdh47:27000(1) hdfsn21n234:27000(1) hdfsn21n86:27000(1) hdfsn21n163:27000(1) cdh75:27000(1) Admission result: Admitted immediately Cluster Memory Admitted: 564.17 MB Executor Group: default ExecSummary: Operator #Hosts #Inst Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------------------------------------- F01:ROOT 1 1 115.555us 115.555us 4.01 MB 4.00 MB 03:AGGREGATE 1 1 209.578us 209.578us 1 1 16.00 KB 16.00 KB FINALIZE 02:EXCHANGE 1 1 101.625us 101.625us 5 1 48.00 KB 16.00 KB UNPARTITIONED F00:EXCHANGE SENDER 5 5 112.644us 155.605us 32.00 KB 0 01:AGGREGATE 5 5 965.706us 1.038ms 5 1 41.00 KB 16.00 KB 00:SCAN HDFS 5 5 19.475ms 20.966ms 8.00M 346.96M 8.56 MB 88.00 MB iceberg.gamebox_event_iceberg Errors: Query Compilation: 2s370ms - Metadata of all 1 tables cached: 529.857us (529.857us) - Analysis finished: 1.348ms (818.684us) - Authorization finished (noop): 1.430ms (82.333us) - Value transfer graph computed: 1.567ms (136.278us) - Single node plan created: 1s251ms (1s249ms) - Runtime filters computed: 1s251ms (167.207us) - Distributed plan created: 1s251ms (49.186us) - Parallel plans created: 1s251ms (25.727us) - Planning finished: 2s370ms (1s118ms) Query Timeline: 6s773ms - Query submitted: 45.346us (45.346us) - Planning finished: 3s137ms (3s137ms) - Submit for admission: 3s137ms (318.851us) - Completed admission: 3s147ms (9.476ms) - Ready to start on 6 backends: 3s294ms (147.170ms) - All 6 execution backends (6 fragment instances) started: 5s820ms (2s526ms) - Rows available: 6s676ms (855.867ms) - First row fetched: 6s758ms (82.194ms) - Last row fetched: 6s758ms (41.645us) - Released admission control resources: 6s773ms (14.356ms) - Unregister query: 6s773ms (906.047us) - AdmissionControlTimeSinceLastUpdate: 56.000ms - ComputeScanRangeAssignmentTimer: 195.953us - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Frontend: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns ImpalaServer: - ClientFetchWaitTimer: 82.951ms - InactiveTotalTime: 0.000ns - NumRowsFetched: 1 (1) - NumRowsFetchedFromCache: 0 (0) - RowMaterializationRate: 68.00 /sec - RowMaterializationTimer: 14.541ms - TotalTime: 0.000ns Execution Profile cf446a1ab3a5e852:1b1005de00000000: 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: 6, min / max: 602ms / 2s368ms, 25th %-ile: 2s054ms, 50th %-ile: 2s167ms, 75th %-ile: 2s212ms, 90th %-ile: 2s212ms, 95th %-ile: 2s368ms, 99.9th %-ile: 2s368ms Slowest backend to start up: cdh40:27000 Per Node Peak Memory Usage: hdfsn21n163:27000(4.07 MB) cdh75:27000(8.60 MB) hdfsn21n234:27000(8.57 MB) cdh47:27000(8.58 MB) hdfsn21n86:27000(8.62 MB) cdh40:27000(8.57 MB) Per Node Bytes Read: hdfsn21n163:27000(0) cdh75:27000(645.67 KB) hdfsn21n234:27000(603.47 KB) cdh47:27000(626.93 KB) hdfsn21n86:27000(663.93 KB) cdh40:27000(605.75 KB) Per Node User Time: hdfsn21n163:27000(31.854ms) cdh75:27000(78.864ms) hdfsn21n234:27000(81.060ms) cdh47:27000(82.240ms) hdfsn21n86:27000(78.164ms) cdh40:27000(77.441ms) Per Node System Time: hdfsn21n163:27000(3.861ms) cdh75:27000(1.974ms) hdfsn21n234:27000(2.001ms) cdh47:27000(1.984ms) hdfsn21n86:27000(2.946ms) cdh40:27000(4.990ms) - ExchangeScanRatio: 0.00 - FiltersReceived: 0 (0) - FinalizationTimer: 0.000ns - InactiveTotalTime: 0.000ns - InnerNodeSelectivityRatio: 0.00 - NumBackends: 6 (6) - NumCompletedBackends: 6 (6) - NumFragmentInstances: 6 (6) - NumFragments: 2 (2) - TotalBytesRead: 3.07 MB (3221251) - TotalBytesSent: 60.00 B (60) - TotalCpuTime: 447.379ms - TotalInnerBytesSent: 0 - TotalScanBytesSent: 60.00 B (60) - TotalTime: 3s543ms Per Node Profiles: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns hdfsn21n163:27000: - AdmissionSlots: 1 (1) - BloomFilterBytes: 0 - InListFilterItems: 0 (0) - InactiveTotalTime: 0.000ns - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns - TotalTime: 0.000ns - UncompressedScratchBytesWritten: 0 Buffer pool: - AllocTime: 0.000ns - CompressionTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns JVM: - GcCount: 0 (0) - GcNumInfoThresholdExceeded: 0 (0) - GcNumWarnThresholdExceeded: 0 (0) - GcTimeMillis: 0 - GcTotalExtraSleepTimeMillis: 0 - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Fragment F01: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns CodeGen: - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 0 (0) - CodegenTotalWallClockTime: 34.671ms - CodegenSysTime: 2.956ms - CodegenUserTime: 30.965ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 1.754ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 68.730us - LoadTime: 0.000ns - MainThreadCodegenTime: 8.674ms - ModuleBitcodeSize: 4.07 MB (4271328) - NumFunctions: 1 (1) - NumInstructions: 13 (13) - OptimizationTime: 5.743ms - PeakMemoryUsage: 6.50 KB (6656) - PrepareTime: 26.007ms - TotalTime: 34.679ms cdh75:27000: - AdmissionSlots: 1 (1) - BloomFilterBytes: 0 - InListFilterItems: 0 (0) - InactiveTotalTime: 0.000ns - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns - TotalTime: 0.000ns - UncompressedScratchBytesWritten: 0 Buffer pool: - AllocTime: 0.000ns - CompressionTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns JVM: - GcCount: 0 (0) - GcNumInfoThresholdExceeded: 0 (0) - GcNumWarnThresholdExceeded: 0 (0) - GcTimeMillis: 0 - GcTotalExtraSleepTimeMillis: 0 - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Fragment F00: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns CodeGen: - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 0 (0) - CodegenTotalWallClockTime: 65.659ms - CodegenSysTime: 984.000us - CodegenUserTime: 64.858ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 12.669ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 1.975ms - LoadTime: 0.000ns - MainThreadCodegenTime: 42.921ms - ModuleBitcodeSize: 4.07 MB (4271328) - NumFunctions: 35 (35) - NumInstructions: 1.09K (1086) - OptimizationTime: 27.092ms - PeakMemoryUsage: 543.00 KB (556032) - PrepareTime: 22.745ms - TotalTime: 65.667ms hdfsn21n234:27000: - AdmissionSlots: 1 (1) - BloomFilterBytes: 0 - InListFilterItems: 0 (0) - InactiveTotalTime: 0.000ns - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns - TotalTime: 0.000ns - UncompressedScratchBytesWritten: 0 Buffer pool: - AllocTime: 0.000ns - CompressionTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns JVM: - GcCount: 0 (0) - GcNumInfoThresholdExceeded: 0 (0) - GcNumWarnThresholdExceeded: 0 (0) - GcTimeMillis: 0 - GcTotalExtraSleepTimeMillis: 0 - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Fragment F00: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns CodeGen: - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 0 (0) - CodegenTotalWallClockTime: 68.689ms - CodegenSysTime: 1.983ms - CodegenUserTime: 66.438ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 12.843ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 2.029ms - LoadTime: 0.000ns - MainThreadCodegenTime: 44.164ms - ModuleBitcodeSize: 4.07 MB (4271328) - NumFunctions: 35 (35) - NumInstructions: 1.09K (1086) - OptimizationTime: 28.141ms - PeakMemoryUsage: 543.00 KB (556032) - PrepareTime: 24.534ms - TotalTime: 68.698ms cdh47:27000: - AdmissionSlots: 1 (1) - BloomFilterBytes: 0 - InListFilterItems: 0 (0) - InactiveTotalTime: 0.000ns - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns - TotalTime: 0.000ns - UncompressedScratchBytesWritten: 0 Buffer pool: - AllocTime: 0.000ns - CompressionTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns JVM: - GcCount: 0 (0) - GcNumInfoThresholdExceeded: 0 (0) - GcNumWarnThresholdExceeded: 0 (0) - GcTimeMillis: 0 - GcTotalExtraSleepTimeMillis: 2ms - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Fragment F00: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns CodeGen: - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 1 (1) - CodegenTotalWallClockTime: 69.655ms - CodegenSysTime: 1.984ms - CodegenUserTime: 67.482ms - CodegenVoluntaryContextSwitches: 1 (1) - CompileTime: 13.807ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 1.968ms - LoadTime: 0.000ns - MainThreadCodegenTime: 46.090ms - ModuleBitcodeSize: 4.07 MB (4271328) - NumFunctions: 35 (35) - NumInstructions: 1.09K (1086) - OptimizationTime: 29.126ms - PeakMemoryUsage: 543.00 KB (556032) - PrepareTime: 23.573ms - TotalTime: 69.662ms hdfsn21n86:27000: - AdmissionSlots: 1 (1) - BloomFilterBytes: 0 - InListFilterItems: 0 (0) - InactiveTotalTime: 0.000ns - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns - TotalTime: 0.000ns - UncompressedScratchBytesWritten: 0 Buffer pool: - AllocTime: 0.000ns - CompressionTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns JVM: - GcCount: 0 (0) - GcNumInfoThresholdExceeded: 0 (0) - GcNumWarnThresholdExceeded: 0 (0) - GcTimeMillis: 0 - GcTotalExtraSleepTimeMillis: 0 - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Fragment F00: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns CodeGen: - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 0 (0) - CodegenTotalWallClockTime: 65.145ms - CodegenSysTime: 2.890ms - CodegenUserTime: 61.955ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 12.782ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 2.036ms - LoadTime: 0.000ns - MainThreadCodegenTime: 43.190ms - ModuleBitcodeSize: 4.07 MB (4271328) - NumFunctions: 35 (35) - NumInstructions: 1.09K (1086) - OptimizationTime: 27.223ms - PeakMemoryUsage: 543.00 KB (556032) - PrepareTime: 21.964ms - TotalTime: 65.154ms cdh40:27000: - AdmissionSlots: 1 (1) - BloomFilterBytes: 0 - InListFilterItems: 0 (0) - InactiveTotalTime: 0.000ns - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns - TotalTime: 0.000ns - UncompressedScratchBytesWritten: 0 Buffer pool: - AllocTime: 0.000ns - CompressionTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns JVM: - GcCount: 0 (0) - GcNumInfoThresholdExceeded: 0 (0) - GcNumWarnThresholdExceeded: 0 (0) - GcTimeMillis: 0 - GcTotalExtraSleepTimeMillis: 0 - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Fragment F00: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns CodeGen: - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 1 (1) - CodegenTotalWallClockTime: 67.501ms - CodegenSysTime: 3.955ms - CodegenUserTime: 62.867ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 13.390ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 1.919ms - LoadTime: 0.000ns - MainThreadCodegenTime: 44.478ms - ModuleBitcodeSize: 4.07 MB (4271328) - NumFunctions: 35 (35) - NumInstructions: 1.09K (1086) - OptimizationTime: 27.998ms - PeakMemoryUsage: 543.00 KB (556032) - PrepareTime: 23.031ms - TotalTime: 67.508ms Coordinator Fragment F01: Instances: [0] Instance cf446a1ab3a5e852:1b1005de00000000 (host=hdfsn21n163:27000) Last report received time[0]: 2022-11-03 16:39:53.622 - MemoryUsage[0] (500.000ms): 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB Fragment Instance Lifecycle Event Timeline[0]: 1s978ms - Prepare Finished: 606.845us (606.845us) - Open Finished: 1s895ms (1s895ms) - First Batch Produced: 1s895ms (5.917us) - First Batch Sent: 1s895ms (66.802us) - ExecInternal Finished: 1s978ms (82.285ms) - AverageThreadTokens: 0.00 - BytesAssigned: 0 - CompletionTime: 2s718ms - ExchangeScanRatio: 0.00 - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 4.02 MB (4218880) - PeakReservation: 4.00 MB (4194304) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 4.07 MB (4268041) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 1s860ms - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 1s977ms - TotalThreadsSysTime: 3.861ms - TotalThreadsUserTime: 31.854ms - TotalThreadsVoluntaryContextSwitches: 7 (7) - TotalTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 82.318ms - ExecTreeExecTime: 4.696us - InactiveTotalTime: 0.000ns - OpenTime: 1s895ms - ExecTreeOpenTime: 1s860ms - PrepareTime: 250.694us - ExecTreePrepareTime: 139.789us - TotalTime: 0.000ns PLAN_ROOT_SINK:(Total: 82.329ms, non-child: 115.555us, % non-child: 0.14%) - InactiveTotalTime: 82.213ms - PeakMemoryUsage: 4.01 MB (4202496) - RowBatchGetWaitTime: 0.000ns - RowBatchSendWaitTime: 0.000ns - RowsSent: 1 (1) - RowsSentRate: 12.00 /sec - TotalTime: 82.329ms Buffer pool: - AllocTime: 43.163us - CompressionTime: 0.000ns - CumulativeAllocationBytes: 2.00 MB (2097152) - CumulativeAllocations: 1 (1) - EncryptionTime: 0.000ns - InactiveTotalTime: 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: 38.065us - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns AGGREGATION_NODE (id=3):(Total: 1s860ms, non-child: 209.578us, % non-child: 0.01%) Node Lifecycle Event Timeline[0]: 1s895ms - Open Started: 35.417ms (35.417ms) - Open Finished: 1s895ms (1s860ms) - First Batch Requested: 1s895ms (91.684us) - First Batch Returned: 1s895ms (2.427us) - Last Batch Returned: 1s895ms (954.000ns) - Closed: 1s895ms (75.021us) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 1 (1) - RowsReturnedRate: 0 - TotalTime: 1s860ms NonGroupingAggregator 0: - BuildTime: 7.281us - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 1 (1) - TotalTime: 0.000ns EXCHANGE_NODE (id=2):(Total: 1s860ms, non-child: 101.625us, % non-child: 0.01%) Node Lifecycle Event Timeline[0]: 1s895ms - Open Started: 35.420ms (35.420ms) - Open Finished: 1s614ms (1s578ms) - First Batch Requested: 1s614ms (33.243us) - First Batch Returned: 1s895ms (281.248ms) - Last Batch Returned: 1s895ms (476.000ns) - Closed: 1s895ms (47.976us) - ConvertRowBatchTime: 17.340us - InactiveTotalTime: 1s859ms - PeakMemoryUsage: 48.00 KB (49152) - RowsReturned: 5 (5) - RowsReturnedRate: 2.00 /sec - TotalTime: 1s860ms Buffer pool: - AllocTime: 91.074us - CompressionTime: 0.000ns - CumulativeAllocationBytes: 80.00 KB (81920) - CumulativeAllocations: 10 (10) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 48.00 KB (49152) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 48.00 KB (49152) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 65.712us - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: - BytesDequeued[0] (500.000ms): 0, 0, 0, 0 - FirstBatchWaitTime: 1s578ms - InactiveTotalTime: 0.000ns - TotalBytesDequeued: 80.00 B (80) - TotalGetBatchTime: 1s860ms - DataWaitTime: 1s859ms - TotalTime: 0.000ns Enqueue: - BytesReceived[0] (500.000ms): 0, 0, 0, 0 - DeferredQueueSize[0] (500.000ms): 0, 0, 0, 0 - DispatchTime: (Avg: 110.485us ; Min: 87.236us ; Max: 145.407us ; Number of samples: 5) - DeserializeRowBatchTime: 142.530us - InactiveTotalTime: 0.000ns - TotalBatchesEnqueued: 5 (5) - TotalBatchesReceived: 5 (5) - TotalBytesReceived: 60.00 B (60) - TotalEarlySenders: 0 (0) - TotalEosReceived: 5 (5) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) - TotalTime: 0.000ns Fragment F00 [5 instances]: Instances: [0] Instance cf446a1ab3a5e852:1b1005de00000001 (host=cdh75:27000) [1] Instance cf446a1ab3a5e852:1b1005de00000002 (host=hdfsn21n234:27000) [2] Instance cf446a1ab3a5e852:1b1005de00000003 (host=cdh47:27000) [3] Instance cf446a1ab3a5e852:1b1005de00000004 (host=hdfsn21n86:27000) [4] Instance cf446a1ab3a5e852:1b1005de00000005 (host=cdh40:27000) Hdfs split stats (<volume id>:<# splits>/<split lengths>)[2]: 0:1/94.92 MB Hdfs split stats (<volume id>:<# splits>/<split lengths>)[0]: 1:1/100.78 MB Hdfs split stats (<volume id>:<# splits>/<split lengths>)[4]: 1:1/92.33 MB Hdfs split stats (<volume id>:<# splits>/<split lengths>)[3]: 2:1/104.41 MB Hdfs split stats (<volume id>:<# splits>/<split lengths>)[1]: 2:1/88.78 MB Last report received time[1]: 2022-11-03 16:39:53.246 Last report received time[2]: 2022-11-03 16:39:53.323 Last report received time[0]: 2022-11-03 16:39:53.403 Last report received time[4]: 2022-11-03 16:39:53.516 Last report received time[3]: 2022-11-03 16:39:53.527 Fragment Instance Lifecycle Event Timeline[0]: 87.759ms - Prepare Finished: 583.240us (583.240us) - Open Finished: 86.925ms (86.342ms) - First Batch Produced: 86.929ms (3.678us) - First Batch Sent: 86.956ms (27.025us) - ExecInternal Finished: 87.759ms (803.338us) Fragment Instance Lifecycle Event Timeline[1]: 91.830ms - Prepare Finished: 543.152us (543.152us) - Open Finished: 91.058ms (90.515ms) - First Batch Produced: 91.063ms (4.903us) - First Batch Sent: 91.094ms (31.361us) - ExecInternal Finished: 91.830ms (736.115us) Fragment Instance Lifecycle Event Timeline[2]: 89.708ms - Prepare Finished: 471.726us (471.726us) - Open Finished: 88.929ms (88.457ms) - First Batch Produced: 88.933ms (4.054us) - First Batch Sent: 88.960ms (27.413us) - ExecInternal Finished: 89.708ms (747.044us) Fragment Instance Lifecycle Event Timeline[3]: 88.505ms - Prepare Finished: 601.770us (601.770us) - Open Finished: 87.693ms (87.091ms) - First Batch Produced: 87.698ms (4.698us) - First Batch Sent: 87.729ms (31.617us) - ExecInternal Finished: 88.505ms (775.686us) Fragment Instance Lifecycle Event Timeline[4]: 88.022ms - Prepare Finished: 553.841us (553.841us) - Open Finished: 87.118ms (86.565ms) - First Batch Produced: 87.127ms (8.269us) - First Batch Sent: 87.170ms (43.449us) - ExecInternal Finished: 88.022ms (851.856us) - AverageThreadTokens: mean=0.00 min=0.00 max=0.00 - BytesAssigned: mean=96.24 MB (100917830) min=88.78 MB (93087974) max=104.41 MB (109478336) - CompletionTime: mean=903.032ms min=846.251ms max=1s013ms - ExchangeScanRatio: mean=0.00 min=0.00 max=0.00 - ExecutionRate: mean=106.72 MB/sec min=99.79 MB/sec max=111.07 MB/sec - InactiveTotalTime: mean=0.000ns min=0.000ns max=0.000ns - PeakMemoryUsage: mean=8.58 MB (8999703) min=8.56 MB (8973599) max=8.62 MB (9035025) - PeakReservation: mean=8.00 MB (8388608) min=8.00 MB (8388608) max=8.00 MB (8388608) - PeakUsedReservation: mean=0 min=0 max=0 - PerHostPeakMemUsage: mean=8.59 MB (9006466) min=8.57 MB (8989696) max=8.62 MB (9036347) - RowsProduced: mean=1 (1) min=1 (1) max=1 (1) - TotalNetworkReceiveTime: mean=0.000ns min=0.000ns max=0.000ns - TotalNetworkSendTime: mean=702.553us min=657.348us max=793.511us - TotalStorageWaitTime: mean=5.088ms min=3.482ms max=7.181ms - TotalThreadsInvoluntaryContextSwitches: mean=0 (0) min=0 (0) max=1 (1) - TotalThreadsTotalWallClockTime: mean=88.558ms min=87.085ms max=91.251ms - TotalThreadsSysTime: mean=2.779ms min=1.974ms max=4.990ms - TotalThreadsUserTime: mean=79.553ms min=77.441ms max=82.240ms - TotalThreadsVoluntaryContextSwitches: mean=6 (6) min=6 (6) max=7 (7) - TotalTime: mean=0.000ns min=0.000ns max=0.000ns Fragment Instance Lifecycle Timings [5 instances]: - ExecTime: mean=776.428us min=738.499us max=887.851us - ExecTreeExecTime: mean=4.083us min=2.892us max=6.435us - InactiveTotalTime: mean=0.000ns min=0.000ns max=0.000ns - OpenTime: mean=87.788ms min=86.339ms max=90.508ms - ExecTreeOpenTime: mean=20.361ms min=18.721ms max=21.837ms - PrepareTime: mean=192.134us min=172.325us max=216.155us - ExecTreePrepareTime: mean=78.343us min=63.403us max=94.395us - TotalTime: mean=0.000ns min=0.000ns max=0.000ns KrpcDataStreamSender (dst_id=2) [5 instances]:(Total: 815.197us, non-child: 112.644us, % non-child: 13.82%) ExecOption[0-4]: Unpartitioned Sender Codegen Disabled: not needed - NetworkThroughput: (Avg: 31.52 KB/sec ; Min: 27.08 KB/sec ; Max: 35.41 KB/sec ; Number of samples: 5) - RpcNetworkTime: (Avg: 263.291us ; Min: 106.490us ; Max: 432.653us ; Number of samples: 10) - RpcRecvrTime: (Avg: 93.232us ; Min: 18.944us ; Max: 183.435us ; Number of samples: 10) - EosSent: mean=1 (1) min=1 (1) max=1 (1) - InactiveTotalTime: mean=702.553us min=657.348us max=793.511us - PeakMemoryUsage: mean=32.00 KB (32768) min=32.00 KB (32768) max=32.00 KB (32768) - RowsSent: mean=1 (1) min=1 (1) max=1 (1) - RpcFailure: mean=0 (0) min=0 (0) max=0 (0) - RpcRetry: mean=0 (0) min=0 (0) max=0 (0) - SerializeBatchTime: mean=5.716us min=4.152us max=7.481us - TotalBytesSent: mean=12.00 B (12) min=12.00 B (12) max=12.00 B (12) - TotalTime: mean=815.197us min=766.919us max=893.766us - UncompressedRowBatchSize: mean=16.00 B (16) min=16.00 B (16) max=16.00 B (16) AGGREGATION_NODE (id=1) [5 instances]:(Total: 20.441ms, non-child: 965.706us, % non-child: 4.72%) Node Lifecycle Event Timeline[0]: 86.959ms - Open Started: 66.318ms (66.318ms) - Open Finished: 86.916ms (20.597ms) - First Batch Requested: 86.926ms (10.610us) - First Batch Returned: 86.928ms (1.849us) - Last Batch Returned: 86.928ms (158.000ns) - Closed: 86.959ms (30.742us) Node Lifecycle Event Timeline[1]: 91.099ms - Open Started: 69.327ms (69.327ms) - Open Finished: 91.041ms (21.713ms) - First Batch Requested: 91.059ms (18.322us) - First Batch Returned: 91.062ms (2.450us) - Last Batch Returned: 91.062ms (165.000ns) - Closed: 91.099ms (36.429us) Node Lifecycle Event Timeline[2]: 88.964ms - Open Started: 70.199ms (70.199ms) - Open Finished: 88.918ms (18.718ms) - First Batch Requested: 88.930ms (12.411us) - First Batch Returned: 88.932ms (2.210us) - Last Batch Returned: 88.932ms (151.000ns) - Closed: 88.964ms (32.043us) Node Lifecycle Event Timeline[3]: 87.733ms - Open Started: 65.830ms (65.830ms) - Open Finished: 87.665ms (21.835ms) - First Batch Requested: 87.695ms (29.755us) - First Batch Returned: 87.697ms (2.287us) - Last Batch Returned: 87.697ms (365.000ns) - Closed: 87.733ms (35.309us) Node Lifecycle Event Timeline[4]: 87.177ms - Open Started: 68.168ms (68.168ms) - Open Finished: 87.097ms (18.929ms) - First Batch Requested: 87.120ms (23.101us) - First Batch Returned: 87.124ms (3.877us) - Last Batch Returned: 87.125ms (482.000ns) - Closed: 87.177ms (52.608us) - InactiveTotalTime: mean=0.000ns min=0.000ns max=0.000ns - PeakMemoryUsage: mean=41.00 KB (41984) min=41.00 KB (41984) max=41.00 KB (41984) - RowsReturned: mean=1 (1) min=1 (1) max=1 (1) - RowsReturnedRate: mean=48.00 /sec min=45.00 /sec max=53.00 /sec - TotalTime: mean=20.441ms min=18.785ms max=21.931ms NonGroupingAggregator 0 [5 instances]: ExecOption[0-4]: Codegen Enabled - BuildTime: mean=611.094us min=565.022us max=645.424us - InactiveTotalTime: mean=0.000ns min=0.000ns max=0.000ns - PeakMemoryUsage: mean=8.00 KB (8192) min=8.00 KB (8192) max=8.00 KB (8192) - RowsReturned: mean=1 (1) min=1 (1) max=1 (1) - TotalTime: mean=0.000ns min=0.000ns max=0.000ns HDFS_SCAN_NODE (id=0) [5 instances]:(Total: 19.475ms, non-child: 19.475ms, % non-child: 100.00%) ExecOption[0-4]: Codegen enabled: 1 out of 1, PARQUET Codegen Enabled File Formats[0-4]: PARQUET/GZIP:1 Hdfs Read Thread Concurrency Bucket[0-4]: 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% Table Name[0-4]: iceberg.gamebox_event_iceberg Node Lifecycle Event Timeline[0]: 86.915ms - Open Started: 66.320ms (66.320ms) - Open Finished: 66.398ms (77.382us) - First Batch Requested: 66.403ms (5.289us) - First Batch Returned: 73.220ms (6.817ms) - Last Batch Returned: 86.833ms (13.612ms) - Closed: 86.915ms (81.866us) Node Lifecycle Event Timeline[1]: 91.039ms - Open Started: 69.329ms (69.329ms) - Open Finished: 69.413ms (83.895us) - First Batch Requested: 69.419ms (6.428us) - First Batch Returned: 78.308ms (8.889ms) - Last Batch Returned: 91.001ms (12.692ms) - Closed: 91.039ms (37.650us) Node Lifecycle Event Timeline[2]: 88.917ms - Open Started: 70.201ms (70.201ms) - Open Finished: 70.294ms (93.389us) - First Batch Requested: 70.299ms (4.855us) - First Batch Returned: 75.583ms (5.284ms) - Last Batch Returned: 88.842ms (13.258ms) - Closed: 88.917ms (75.013us) Node Lifecycle Event Timeline[3]: 87.664ms - Open Started: 65.832ms (65.832ms) - Open Finished: 65.920ms (87.867us) - First Batch Requested: 65.926ms (6.255us) - First Batch Returned: 73.483ms (7.556ms) - Last Batch Returned: 87.622ms (14.138ms) - Closed: 87.664ms (42.494us) Node Lifecycle Event Timeline[4]: 87.096ms - Open Started: 68.170ms (68.170ms) - Open Finished: 68.252ms (82.682us) - First Batch Requested: 68.259ms (6.684us) - First Batch Returned: 73.396ms (5.137ms) - Last Batch Returned: 86.984ms (13.587ms) - Closed: 87.096ms (111.989us) - ColumnarScannerActualReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 5) - ColumnarScannerIdealReservation: (Avg: 8.00 KB (8192) ; Min: 8.00 KB (8192) ; Max: 8.00 KB (8192) ; Number of samples: 5) - FooterProcessingTime: (Avg: 5.031ms ; Min: 3.489ms ; Max: 7.172ms ; Number of samples: 5) - InitialRangeActualReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 5) - InitialRangeIdealReservation: (Avg: 128.00 KB (131072) ; Min: 128.00 KB (131072) ; Max: 128.00 KB (131072) ; Number of samples: 5) - PageIndexProcessingTime: (Avg: 727.077us ; Min: 672.611us ; Max: 793.346us ; Number of samples: 5) - 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: mean=0.00 min=0.00 max=0.00 - BytesRead: mean=629.15 KB (644250) min=603.47 KB (617949) max=663.93 KB (679869) - BytesReadDataNodeCache: mean=0 min=0 max=0 - BytesReadLocal: mean=629.15 KB (644250) min=603.47 KB (617949) max=663.93 KB (679869) - BytesReadRemoteUnexpected: mean=0 min=0 max=0 - BytesReadShortCircuit: mean=629.15 KB (644250) min=603.47 KB (617949) max=663.93 KB (679869) - CachedFileHandlesHitCount: mean=3 (3) min=3 (3) max=3 (3) - CachedFileHandlesMissCount: mean=0 (0) min=0 (0) max=0 (0) - CollectionItemsRead: mean=0 (0) min=0 (0) max=0 (0) - DataCacheHitBytes: mean=0 min=0 max=0 - DataCacheHitCount: mean=0 (0) min=0 (0) max=0 (0) - DataCacheMissBytes: mean=0 min=0 max=0 - DataCacheMissCount: mean=0 (0) min=0 (0) max=0 (0) - DataCachePartialHitCount: mean=0 (0) min=0 (0) max=0 (0) - DecompressionTime: mean=31.756us min=29.267us max=32.931us - InactiveTotalTime: mean=0.000ns min=0.000ns max=0.000ns - IoReadAsyncBytes: mean=4.35 KB (4450) min=4.15 KB (4251) max=4.64 KB (4748) - IoReadAsyncRequest: mean=162 (162) min=155 (155) max=173 (173) - IoReadSkippedBytes: mean=32.00 B (32) min=32.00 B (32) max=32.00 B (32) - IoReadSyncBytes: mean=524.77 KB (537367) min=499.28 KB (511263) max=559.27 KB (572689) - IoReadSyncRequest: mean=1 (1) min=1 (1) max=1 (1) - IoReadTotalBytes: mean=529.12 KB (541818) min=503.43 KB (515517) max=563.90 KB (577437) - IoReadTotalRequest: mean=163 (163) min=156 (156) max=174 (174) - MaterializeTupleTime: mean=12.098ms min=11.304ms max=12.773ms - MaxCompressedTextFileLength: mean=0 min=0 max=0 - NumBloomFilteredRowGroups: mean=0 (0) min=0 (0) max=0 (0) - NumColumns: mean=1 (1) min=1 (1) max=1 (1) - NumDictFilteredRowGroups: mean=0 (0) min=0 (0) max=0 (0) - NumDisksAccessed: mean=1 (1) min=1 (1) max=1 (1) - NumFileMetadataRead: mean=0 (0) min=0 (0) max=0 (0) - NumPages: mean=80 (80) min=77 (77) max=86 (86) - NumPagesSkippedByLateMaterialization: mean=0 (0) min=0 (0) max=0 (0) - NumRowGroups: mean=1 (1) min=1 (1) max=1 (1) - NumRowGroupsSkippedByUnusefulFilters: mean=0 (0) min=0 (0) max=0 (0) - NumRowGroupsWithPageIndex: mean=1 (1) min=1 (1) max=1 (1) - NumRuntimeFilteredPages: mean=0 (0) min=0 (0) max=0 (0) - NumRuntimeFilteredRowGroups: mean=0 (0) min=0 (0) max=0 (0) - NumScannersWithNoReads: mean=0 (0) min=0 (0) max=0 (0) - NumStatsFilteredPages: mean=0 (0) min=0 (0) max=0 (0) - NumStatsFilteredRowGroups: mean=0 (0) min=0 (0) max=0 (0) - PeakMemoryUsage: mean=8.53 MB (8942359) min=8.50 MB (8916255) max=8.56 MB (8977681) - PerReadThreadRawHdfsThroughput: mean=114.95 MB/sec min=75.16 MB/sec max=148.95 MB/sec - RemoteScanRanges: mean=0 (0) min=0 (0) max=0 (0) - RowsRead: mean=1.60M (1600372) min=1.52M (1523024) max=1.71M (1708871) - RowsReturned: mean=1.60M (1600372) min=1.52M (1523024) max=1.71M (1708871) - RowsReturnedRate: mean=82.46 M/sec min=73.22 M/sec max=88.94 M/sec - ScanRangesComplete: mean=1 (1) min=1 (1) max=1 (1) - ScannerIoWaitTime: mean=5.088ms min=3.482ms max=7.181ms - TotalRawHdfsOpenFileTime: mean=15.905us min=13.556us max=21.383us - TotalRawHdfsReadTime: mean=5.653ms min=3.971ms max=7.840ms - TotalReadThroughput: mean=0.00 /sec min=0.00 /sec max=0.00 /sec - TotalTime: mean=19.475ms min=17.827ms max=20.966ms Buffer pool [5 instances]: - AllocTime: mean=10.308us min=3.099us max=30.950us - CompressionTime: mean=0.000ns min=0.000ns max=0.000ns - CumulativeAllocationBytes: mean=136.00 KB (139264) min=136.00 KB (139264) max=136.00 KB (139264) - CumulativeAllocations: mean=2 (2) min=2 (2) max=2 (2) - EncryptionTime: mean=0.000ns min=0.000ns max=0.000ns - InactiveTotalTime: mean=0.000ns min=0.000ns max=0.000ns - PeakReservation: mean=8.00 MB (8388608) min=8.00 MB (8388608) max=8.00 MB (8388608) - PeakUnpinnedBytes: mean=0 min=0 max=0 - PeakUsedReservation: mean=128.00 KB (131072) min=128.00 KB (131072) max=128.00 KB (131072) - ReadIoBytes: mean=0 min=0 max=0 - ReadIoOps: mean=0 (0) min=0 (0) max=0 (0) - ReadIoWaitTime: mean=0.000ns min=0.000ns max=0.000ns - SystemAllocTime: mean=6.089us min=0.000ns max=24.883us - TotalTime: mean=0.000ns min=0.000ns max=0.000ns - WriteIoBytes: mean=0 min=0 max=0 - WriteIoOps: mean=0 (0) min=0 (0) max=0 (0) - WriteIoWaitTime: mean=0.000ns min=0.000ns max=0.000ns