+------------+ | sleep(100) | +------------+ | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | | true | +------------+ Query Runtime Profile: Query (id=694f94671571d4d1:cdec9db900000000): DEBUG MODE WARNING: Query profile created while running a DEBUG build of Impala. Use RELEASE builds to measure query performance. - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Summary: Session ID: 2f464722f273aed9:86a98debe50433a5 Session Type: HIVESERVER2 HiveServer2 Protocol Version: V6 Start Time: 2020-10-13 11:13:07.455156000 End Time: 2020-10-13 11:13:10.096253000 Query Type: QUERY Query State: FINISHED Impala Query State: FINISHED Query Status: OK Impala Version: impalad version 4.0.0-SNAPSHOT DEBUG (build b8a2b754669eb7f8d164e8112e594ac413e436ef) User: stakiar Connected User: stakiar Delegated User: Network Address: ::ffff:127.0.0.1:45446 Default Db: default Sql Statement: select sleep(100) from functional.alltypes limit 25 Coordinator: stakiar-desktop:27000 Query Options (set by configuration): TIMEZONE=SystemV/PST8PDT,CLIENT_IDENTIFIER=Impala Shell v4.0.0-SNAPSHOT (b8a2b75) built on Tue Oct 13 11:10:27 PDT 2020 Query Options (set by configuration and planner): NUM_NODES=1,NUM_SCANNER_THREADS=1,RUNTIME_FILTER_MODE=0,MT_DOP=0,TIMEZONE=SystemV/PST8PDT,CLIENT_IDENTIFIER=Impala Shell v4.0.0-SNAPSHOT (b8a2b75) built on Tue Oct 13 11:10:27 PDT 2020 Plan: ---------------- Max Per-Host Resource Reservation: Memory=32.00KB Threads=2 Per-Host Resource Estimates: Memory=16MB Codegen disabled by planner Analyzed query: SELECT sleep(CAST(100 AS INT)) FROM functional.alltypes LIMIT CAST(25 AS TINYINT) F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Host Resources: mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=2 PLAN-ROOT SINK | output exprs: sleep(CAST(100 AS INT)) | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [functional.alltypes] HDFS partitions=24/24 files=24 size=478.45KB stored statistics: table: rows=7.30K size=478.45KB partitions: 24/24 rows=7.30K columns: all extrapolated-rows=disabled max-scan-range-rows=310 limit: 25 mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=1 tuple-ids=0 row-size=0B cardinality=25 in pipelines: 00(GETNEXT) ---------------- Estimated Per-Host Mem: 16777216 Request Pool: default-pool Per Host Min Memory Reservation: stakiar-desktop:27000(32.00 KB) Per Host Number of Fragment Instances: stakiar-desktop:27000(1) Admission result: Admitted immediately Cluster Memory Admitted: 16.00 MB Executor Group: empty group (using coordinator only) ExecSummary: Operator #Hosts #Inst Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------------------ F00:ROOT 1 1 2s503ms 2s503ms 4.00 KB 0 00:SCAN HDFS 1 1 6.032ms 6.032ms 25 25 64.00 KB 16.00 MB functional.alltypes Errors: Query Compilation: 7.380ms - Metadata of all 1 tables cached: 333.016us (333.016us) - Analysis finished: 980.477us (647.461us) - Authorization finished (noop): 1.017ms (36.890us) - Value transfer graph computed: 1.117ms (100.158us) - Single node plan created: 5.991ms (4.873ms) - Distributed plan created: 6.037ms (45.786us) - Planning finished: 7.380ms (1.343ms) Query Timeline: 2s643ms - Query submitted: 36.406us (36.406us) - Planning finished: 8.062ms (8.025ms) - Submit for admission: 8.232ms (170.292us) - Completed admission: 8.552ms (320.102us) - Ready to start on 1 backends: 8.716ms (163.811us) - All 1 execution backends (1 fragment instances) started: 9.507ms (791.392us) - Rows available: 10.567ms (1.059ms) - First row fetched: 2s613ms (2s602ms) - Last row fetched: 2s616ms (3.328ms) - Released admission control resources: 2s641ms (24.304ms) - Unregister query: 2s642ms (1.769ms) - AdmissionControlTimeSinceLastUpdate: 48.000ms - ComputeScanRangeAssignmentTimer: 121.223us - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Frontend: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns ImpalaServer: - ClientFetchWaitTimer: 104.445ms - InactiveTotalTime: 0.000ns - NumRowsFetched: 25 (25) - NumRowsFetchedFromCache: 0 (0) - RowMaterializationRate: 9.00 /sec - RowMaterializationTimer: 2s527ms - TotalTime: 0.000ns Execution Profile 694f94671571d4d1:cdec9db900000000:(Total: 2s529ms, non-child: 0.000ns, % non-child: 0.00%) Backend startup latencies: Count: 1, 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: stakiar-desktop:27000 Per Node Peak Memory Usage: stakiar-desktop:27000(76.00 KB) Per Node Bytes Read: stakiar-desktop:27000(20.36 KB) Per Node User Time: stakiar-desktop:27000(2.151ms) Per Node System Time: stakiar-desktop:27000(0.000ns) - ExchangeScanRatio: 0.00 - FiltersReceived: 0 (0) - FinalizationTimer: 0.000ns - InactiveTotalTime: 0.000ns - InnerNodeSelectivityRatio: 0.00 - NumBackends: 1 (1) - NumCompletedBackends: 1 (1) - NumFragmentInstances: 1 (1) - NumFragments: 1 (1) - TotalBytesRead: 20.36 KB (20853) - TotalBytesSent: 0 - TotalCpuTime: 2.151ms - TotalInnerBytesSent: 0 - TotalScanBytesSent: 0 - TotalTime: 2s529ms Per Node Profiles: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns stakiar-desktop:27000: - AdmissionSlots: 1 (1) - BloomFilterBytes: 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 Averaged Fragment F00:(Total: 2s603ms, non-child: 272.519us, % non-child: 0.01%) split sizes: min: 478.45 KB, max: 478.45 KB, avg: 478.45 KB, stddev: 0 completion times: min:2s629ms max:2s629ms mean: 2s629ms stddev:0.000ns execution rates: min:181.94 KB/sec max:181.94 KB/sec mean:181.94 KB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 0.00 - BytesAssigned: 478.45 KB (489934) - CompletionTime: -1665218428.000ns - ExchangeScanRatio: 0.00 - ExecutionRate: 181.94 KB/sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 76.00 KB (77824) - PeakReservation: 64.00 KB (65536) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 76.00 KB (77824) - RowsProduced: 25 (25) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 5.018ms - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: -1686005515.000ns - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 2.151ms - TotalThreadsVoluntaryContextSwitches: 32 (32) - TotalTime: -1691524485.000ns Fragment Instance Lifecycle Timings: - ExecTime: -1691864190.000ns - ExecTreeExecTime: 5.771ms - InactiveTotalTime: 0.000ns - OpenTime: 138.574us - ExecTreeOpenTime: 120.226us - PrepareTime: 158.683us - ExecTreePrepareTime: 78.466us - TotalTime: 0.000ns PLAN_ROOT_SINK:(Total: 2s597ms, non-child: 2s503ms, % non-child: 96.38%) - InactiveTotalTime: 94.058ms - PeakMemoryUsage: 4.00 KB (4096) - RowsSent: 25 (25) - RowsSentRate: 9.00 /sec - TotalTime: -1697829283.000ns HDFS_SCAN_NODE (id=0):(Total: 6.032ms, non-child: 6.032ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 20.36 KB (20853) - BytesReadDataNodeCache: 0 - BytesReadLocal: 20.36 KB (20853) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 20.36 KB (20853) - CachedFileHandlesHitCount: 0 (0) - CachedFileHandlesMissCount: 1 (1) - CollectionItemsRead: 0 (0) - DataCacheHitBytes: 0 - DataCacheHitCount: 0 (0) - DataCacheMissBytes: 0 - DataCacheMissCount: 0 (0) - DataCachePartialHitCount: 0 (0) - DecompressionTime: 0.000ns - DelimiterParseTime: 109.439us - InactiveTotalTime: 0.000ns - MaterializeTupleTime: 1.311us - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 (1) - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadReservationsDenied: 0 (0) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 64.00 KB (65536) - PeakScannerThreadConcurrency: 1 (1) - PerReadThreadRawHdfsThroughput: 15.43 MB/sec - RemoteScanRanges: 0 (0) - RowBatchBytesEnqueued: 0 - RowBatchQueueGetWaitTime: 5.249ms - RowBatchQueuePeakMemoryUsage: 16.00 KB (16384) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 2 (2) - RowsRead: 310 (310) - RowsReturned: 25 (25) - RowsReturnedRate: 4.14 K/sec - ScanRangesComplete: 1 (1) - ScannerIoWaitTime: 5.018ms - ScannerThreadWorklessLoops: 0 (0) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 5.733ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 389.000us - ScannerThreadsVoluntaryContextSwitches: 4 (4) - TotalRawHdfsOpenFileTime: 3.666ms - TotalRawHdfsReadTime: 1.289ms - TotalReadThroughput: 0.00 /sec - TotalTime: 6.032ms Buffer pool: - AllocTime: 6.760us - CompressionTime: 0.000ns - CumulativeAllocationBytes: 32.00 KB (32768) - CumulativeAllocations: 1 (1) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 64.00 KB (65536) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 32.00 KB (32768) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 4.107us - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Coordinator Fragment F00: - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns Instance 694f94671571d4d1:cdec9db900000000 (host=stakiar-desktop:27000):(Total: 2s603ms, non-child: 272.519us, % non-child: 0.01%) Last report received time: 2020-10-13 11:13:10.094 Hdfs split stats (:<# splits>/): 0:24/478.45 KB Fragment Instance Lifecycle Event Timeline: 2s603ms - Prepare Finished: 309.456us (309.456us) - Open Finished: 454.554us (145.098us) - First Batch Produced: 6.227ms (5.773ms) - First Batch Sent: 2s603ms (2s597ms) - ExecInternal Finished: 2s603ms (340.069us) - MemoryUsage (500.000ms): 52.00 KB, 52.00 KB, 52.00 KB, 52.00 KB, 52.00 KB - AverageThreadTokens: 0.00 - BytesAssigned: 478.45 KB (489934) - CompletionTime: 2s629ms - ExchangeScanRatio: 0.00 - ExecutionRate: 181.94 KB/sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 76.00 KB (77824) - PeakReservation: 64.00 KB (65536) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 76.00 KB (77824) - RowsProduced: 25 (25) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 5.018ms - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 2s608ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 2.151ms - TotalThreadsVoluntaryContextSwitches: 32 (32) - TotalTime: 2s603ms Fragment Instance Lifecycle Timings: - ExecTime: 2s603ms - ExecTreeExecTime: 5.771ms - InactiveTotalTime: 0.000ns - OpenTime: 138.574us - ExecTreeOpenTime: 120.226us - PrepareTime: 158.683us - ExecTreePrepareTime: 78.466us - TotalTime: 0.000ns PLAN_ROOT_SINK:(Total: 2s597ms, non-child: 2s503ms, % non-child: 96.38%) - InactiveTotalTime: 94.058ms - PeakMemoryUsage: 4.00 KB (4096) - RowsSent: 25 (25) - RowsSentRate: 9.00 /sec - TotalTime: 2s597ms HDFS_SCAN_NODE (id=0):(Total: 6.032ms, non-child: 6.032ms, % non-child: 100.00%) Table Name: functional.alltypes Hdfs split stats (:<# splits>/): 0:24/478.45 KB ExecOption: Codegen Disabled: disabled due to optimization hints, Codegen enabled: 0 out of 1 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% File Formats: TEXT/NONE:1 Node Lifecycle Event Timeline: 2s603ms - Open Started: 314.683us (314.683us) - Open Finished: 432.868us (118.185us) - First Batch Requested: 456.867us (23.999us) - First Batch Returned: 6.224ms (5.767ms) - Last Batch Returned: 6.225ms (799.000ns) - Closed: 2s603ms (2s597ms) - InitialRangeActualReservation: (Avg: 32.00 KB (32768) ; Min: 32.00 KB (32768) ; Max: 32.00 KB (32768) ; Number of samples: 1) - InitialRangeIdealReservation: (Avg: 32.00 KB (32768) ; Min: 32.00 KB (32768) ; Max: 32.00 KB (32768) ; Number of samples: 1) - ParquetCompressedBytesReadPerColumn: 0 (Number of samples: 0) - ParquetUncompressedBytesReadPerColumn: 0 (Number of samples: 0) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 20.36 KB (20853) - BytesReadDataNodeCache: 0 - BytesReadLocal: 20.36 KB (20853) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 20.36 KB (20853) - CachedFileHandlesHitCount: 0 (0) - CachedFileHandlesMissCount: 1 (1) - CollectionItemsRead: 0 (0) - DataCacheHitBytes: 0 - DataCacheHitCount: 0 (0) - DataCacheMissBytes: 0 - DataCacheMissCount: 0 (0) - DataCachePartialHitCount: 0 (0) - DecompressionTime: 0.000ns - DelimiterParseTime: 109.439us - InactiveTotalTime: 0.000ns - MaterializeTupleTime: 1.311us - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 (1) - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadReservationsDenied: 0 (0) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 64.00 KB (65536) - PeakScannerThreadConcurrency: 1 (1) - PerReadThreadRawHdfsThroughput: 15.43 MB/sec - RemoteScanRanges: 0 (0) - RowBatchBytesEnqueued: 0 - RowBatchQueueGetWaitTime: 5.249ms - RowBatchQueuePeakMemoryUsage: 16.00 KB (16384) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 2 (2) - RowsRead: 310 (310) - RowsReturned: 25 (25) - RowsReturnedRate: 4.14 K/sec - ScanRangesComplete: 1 (1) - ScannerIoWaitTime: 5.018ms - ScannerThreadWorklessLoops: 0 (0) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 5.733ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 389.000us - ScannerThreadsVoluntaryContextSwitches: 4 (4) - TotalRawHdfsOpenFileTime: 3.666ms - TotalRawHdfsReadTime: 1.289ms - TotalReadThroughput: 0.00 /sec - TotalTime: 6.032ms Buffer pool: - AllocTime: 6.760us - CompressionTime: 0.000ns - CumulativeAllocationBytes: 32.00 KB (32768) - CumulativeAllocations: 1 (1) - EncryptionTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakReservation: 64.00 KB (65536) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 32.00 KB (32768) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 4.107us - TotalTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns