Query (id=704edd1edd4e5463:b6c7786e00000000): Summary: Session ID: 90416b72f645a83b:ec759befe3b37a96 Session Type: BEESWAX Start Time: 2018-04-26 21:34:31.118478000 End Time: 2018-04-26 21:34:31.358624000 Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 3.0.0-SNAPSHOT RELEASE (build 0349f6215ef2ffb8c462393ddd3024b350c545a9) User: gaborkaszab Connected User: gaborkaszab Delegated User: Network Address: ::ffff:127.0.0.1:40884 Default Db: tpch_kudu Sql Statement: SELECT * FROM (SELECT Rank() OVER(ORDER BY l_orderkey) AS rank, Rank() OVER(ORDER BY l_partkey) AS rank2 FROM lineitem WHERE l_shipdate < '1992-05-09') a WHERE rank < 10 ORDER BY rank Coordinator: gaborkaszabdesktop:22000 Query Options (set by configuration): ABORT_ON_ERROR=1,BUFFER_POOL_LIMIT=18874368,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,SCRATCH_LIMIT=0,DISABLE_CODEGEN_ROWS_THRESHOLD=0,DEFAULT_SPILLABLE_BUFFER_SIZE=65536 Query Options (set by configuration and planner): ABORT_ON_ERROR=1,BUFFER_POOL_LIMIT=18874368,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,MT_DOP=0,SCRATCH_LIMIT=0,DISABLE_CODEGEN_ROWS_THRESHOLD=0,DEFAULT_SPILLABLE_BUFFER_SIZE=65536 Plan: ---------------- Max Per-Host Resource Reservation: Memory=16.00MB Per-Host Resource Estimates: Memory=16.00MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Host Resources: mem-estimate=10.00MB mem-reservation=10.00MB PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B | 06:SORT | order by: rank ASC | mem-estimate=3.00MB mem-reservation=3.00MB spill-buffer=512.00KB | tuple-ids=4 row-size=16B cardinality=60012 | 05:SELECT | predicates: rank() < 10 | mem-estimate=0B mem-reservation=0B | tuple-ids=11,8 row-size=58B cardinality=60012 | 04:ANALYTIC | functions: rank() | order by: l_partkey ASC | window: RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW | mem-estimate=1.00MB mem-reservation=1.00MB spill-buffer=512.00KB | tuple-ids=11,8 row-size=58B cardinality=600121 | 03:SORT | order by: l_partkey ASC | mem-estimate=6.00MB mem-reservation=6.00MB spill-buffer=512.00KB | tuple-ids=11 row-size=50B cardinality=600121 | 02:ANALYTIC | functions: rank() | order by: l_orderkey ASC | window: RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW | mem-estimate=1.00MB mem-reservation=1.00MB spill-buffer=512.00KB | tuple-ids=9,6 row-size=50B cardinality=600121 | 07:MERGING-EXCHANGE [UNPARTITIONED] | order by: l_orderkey ASC | mem-estimate=0B mem-reservation=0B | tuple-ids=9 row-size=42B cardinality=600121 | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=6.00MB mem-reservation=6.00MB 01:SORT | order by: l_orderkey ASC | mem-estimate=6.00MB mem-reservation=6.00MB spill-buffer=512.00KB | tuple-ids=9 row-size=42B cardinality=600121 | 00:SCAN KUDU [tpch_kudu.lineitem] kudu predicates: l_shipdate < '1992-05-09' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=42B cardinality=600121 ---------------- Estimated Per-Host Mem: 16777216 Per Host Min Reservation: gaborkaszabdesktop:22000(16.00 MB) gaborkaszabdesktop:22001(6.00 MB) gaborkaszabdesktop:22002(6.00 MB) Request Pool: default-pool Admission result: Admitted immediately ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail --------------------------------------------------------------------------------------------------------------------- 06:SORT 1 184.487us 184.487us 9 60.01K 5.01 MB 3.00 MB 05:SELECT 1 420.797us 420.797us 9 60.01K 2.02 MB 0 04:ANALYTIC 1 33.329ms 33.329ms 169.36K 600.12K 3.03 MB 1.00 MB 03:SORT 1 49.463ms 49.463ms 169.36K 600.12K 10.51 MB 6.00 MB 02:ANALYTIC 1 20.806ms 20.806ms 169.36K 600.12K 2.03 MB 1.00 MB 07:MERGING-EXCHANGE 1 5.038ms 5.038ms 169.36K 600.12K 9.53 MB 0 UNPARTITIONED 01:SORT 3 17.888ms 28.318ms 169.36K 600.12K 6.10 MB 6.00 MB 00:SCAN KUDU 3 56.290ms 71.180ms 169.36K 600.12K 3.67 MB 0 tpch_kudu.lineitem Errors: Query Compilation: 4.397ms - Metadata of all 1 tables cached: 328.392us (328.392us) - Analysis finished: 979.672us (651.280us) - Value transfer graph computed: 1.042ms (62.377us) - Single node plan created: 3.381ms (2.339ms) - Runtime filters computed: 3.451ms (70.262us) - Distributed plan created: 3.475ms (23.405us) - Planning finished: 4.397ms (922.540us) Query Timeline: 241.340ms - Query submitted: 28.043us (28.043us) - Planning finished: 5.340ms (5.312ms) - Submit for admission: 5.493ms (153.302us) - Completed admission: 5.522ms (28.611us) - Ready to start on 3 backends: 5.608ms (86.282us) - All 3 execution backends (4 fragment instances) started: 6.396ms (787.332us) - Rows available: 223.738ms (217.341ms) - First row fetched: 236.819ms (13.081ms) - Last row fetched: 236.940ms (120.936us) - Released admission control resources: 237.357ms (417.453us) - Unregister query: 240.146ms (2.788ms) - ComputeScanRangeAssignmentTimer: 21.532us ImpalaServer: - ClientFetchWaitTimer: 15.522ms - RowMaterializationTimer: 880.889us Execution Profile 704edd1edd4e5463:b6c7786e00000000:(Total: 211.910ms, non-child: 0.000ns, % non-child: 0.00%) Number of filters: 0 Filter routing table: ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled ------------------------------------------------------------------------------------------------------------------- Backend startup latencies: Count: 3, min / max: 0 / 1ms, 25th %-ile: 0, 50th %-ile: 0, 75th %-ile: 0, 90th %-ile: 1ms, 95th %-ile: 1ms, 99.9th %-ile: 1ms Per Node Peak Memory Usage: gaborkaszabdesktop:22000(25.52 MB) gaborkaszabdesktop:22001(8.00 MB) gaborkaszabdesktop:22002(9.78 MB) - FiltersReceived: 0 (0) - FinalizationTimer: 0.000ns - NumBackends: 3 (3) - NumFragmentInstances: 4 (4) - NumFragments: 2 (2) Averaged Fragment F01:(Total: 230.624ms, non-child: 23.190ms, % non-child: 10.06%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:231.110ms max:231.110ms mean: 231.110ms 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 - BloomFilterBytes: 0 - PeakMemoryUsage: 21.09 MB (22115467) - PeakReservation: 13.50 MB (14155776) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 25.52 MB (26764402) - RowsProduced: 9 (9) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 15 (15) - TotalThreadsTotalWallClockTime: 220.522ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 164.000ms - TotalThreadsVoluntaryContextSwitches: 2 (2) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 13.151ms - ExecTreeExecTime: 5.795us - OpenTime: 207.376ms - ExecTreeOpenTime: 112.965ms - PrepareTime: 10.067ms - ExecTreePrepareTime: 108.301us PLAN_ROOT_SINK: - PeakMemoryUsage: 0 SORT_NODE (id=6):(Total: 113.074ms, non-child: 184.487us, % non-child: 0.16%) - InMemorySortTime: 1.427us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 5.01 MB (5255168) - RowsReturned: 9 (9) - RowsReturnedRate: 79.00 /sec - SortDataSize: 153.00 B (153) - SpilledRuns: 0 (0) - TotalMergesPerformed: 0 (0) Buffer pool: - AllocTime: 1.193us - CumulativeAllocationBytes: 512.00 KB (524288) - CumulativeAllocations: 1 (1) - PeakReservation: 3.00 MB (3145728) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 512.00 KB (524288) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns SELECT_NODE (id=5):(Total: 112.890ms, non-child: 420.797us, % non-child: 0.37%) - PeakMemoryUsage: 2.02 MB (2113536) - RowsReturned: 9 (9) - RowsReturnedRate: 79.00 /sec ANALYTIC_EVAL_NODE (id=4):(Total: 112.469ms, non-child: 33.329ms, % non-child: 29.63%) - EvaluationTime: 33.185ms - PeakMemoryUsage: 3.03 MB (3174400) - RowsReturned: 169.36K (169357) - RowsReturnedRate: 1.51 M/sec Buffer pool: - AllocTime: 9.561us - CumulativeAllocationBytes: 8.50 MB (8912896) - CumulativeAllocations: 17 (17) - PeakReservation: 1.00 MB (1048576) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 1.00 MB (1048576) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns SORT_NODE (id=3):(Total: 79.140ms, non-child: 49.463ms, % non-child: 62.50%) - InMemorySortTime: 40.079ms - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 10.51 MB (11022336) - RowsReturned: 169.36K (169357) - RowsReturnedRate: 2.14 M/sec - SortDataSize: 8.24 MB (8637207) - SpilledRuns: 0 (0) - TotalMergesPerformed: 0 (0) Buffer pool: - AllocTime: 5.813us - CumulativeAllocationBytes: 9.50 MB (9961472) - CumulativeAllocations: 19 (19) - PeakReservation: 9.50 MB (9961472) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 9.50 MB (9961472) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns ANALYTIC_EVAL_NODE (id=2):(Total: 29.676ms, non-child: 20.806ms, % non-child: 70.11%) - EvaluationTime: 20.585ms - PeakMemoryUsage: 2.03 MB (2125824) - RowsReturned: 169.36K (169357) - RowsReturnedRate: 5.71 M/sec Buffer pool: - AllocTime: 5.855us - CumulativeAllocationBytes: 7.00 MB (7340032) - CumulativeAllocations: 14 (14) - PeakReservation: 1.00 MB (1048576) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 1.00 MB (1048576) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns EXCHANGE_NODE (id=7):(Total: 8.870ms, non-child: 8.870ms, % non-child: 100.00%) - ConvertRowBatchTime: 0.000ns - MergeGetNext: 4.998ms - MergeGetNextBatch: 124.919us - PeakMemoryUsage: 9.53 MB (9994240) - RowsReturned: 169.36K (169357) - RowsReturnedRate: 19.09 M/sec Buffer pool: - AllocTime: 137.558us - CumulativeAllocationBytes: 11.66 MB (12230656) - CumulativeAllocations: 342 (342) - PeakReservation: 9.53 MB (9994240) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 9.53 MB (9994240) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: - FirstBatchWaitTime: 3.830ms - TotalBytesDequeued: 8.24 MB (8637207) - TotalGetBatchTime: 3.940ms - DataWaitTime: 3.831ms Enqueue: - DeserializeRowBatchTime: 4.425ms - TotalBatchesEnqueued: 171 (171) - TotalBatchesReceived: 171 (171) - TotalBytesReceived: 3.51 MB (3684473) - TotalEarlySenders: 0 (0) - TotalEosReceived: 3 (3) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) CodeGen:(Total: 94.359ms, non-child: 94.359ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 12 (12) - CodegenTotalWallClockTime: 94.351ms - CodegenSysTime: 0.000ns - CodegenUserTime: 52.000ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 12.112ms - IrGenerationTime: 2.045ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.26 MB (2373896) - NumFunctions: 51 (51) - NumInstructions: 1.28K (1284) - OptimizationTime: 51.669ms - PeakMemoryUsage: 642.00 KB (657408) - PrepareTime: 10.572ms Coordinator Fragment F01: Instance 704edd1edd4e5463:b6c7786e00000000 (host=gaborkaszabdesktop:22000):(Total: 230.624ms, non-child: 23.190ms, % non-child: 10.06%) Fragment Instance Lifecycle Event Timeline: 230.687ms - Prepare Finished: 10.151ms (10.151ms) - Open Finished: 217.537ms (207.386ms) - First Batch Produced: 217.539ms (2.503us) - First Batch Sent: 230.677ms (13.137ms) - ExecInternal Finished: 230.687ms (9.630us) - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 21.09 MB (22115467) - PeakReservation: 13.50 MB (14155776) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 25.52 MB (26764402) - RowsProduced: 9 (9) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 15 (15) - TotalThreadsTotalWallClockTime: 220.522ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 164.000ms - TotalThreadsVoluntaryContextSwitches: 2 (2) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 13.151ms - ExecTreeExecTime: 5.795us - OpenTime: 207.376ms - ExecTreeOpenTime: 112.965ms - PrepareTime: 10.067ms - ExecTreePrepareTime: 108.301us PLAN_ROOT_SINK: - PeakMemoryUsage: 0 SORT_NODE (id=6):(Total: 113.074ms, non-child: 184.487us, % non-child: 0.16%) SortType: Total ExecOption: Codegen Enabled - NumRowsPerRun: (Avg: 9 (9) ; Min: 9 (9) ; Max: 9 (9) ; Number of samples: 1) - InMemorySortTime: 1.427us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 5.01 MB (5255168) - RowsReturned: 9 (9) - RowsReturnedRate: 79.00 /sec - SortDataSize: 153.00 B (153) - SpilledRuns: 0 (0) - TotalMergesPerformed: 0 (0) Buffer pool: - AllocTime: 1.193us - CumulativeAllocationBytes: 512.00 KB (524288) - CumulativeAllocations: 1 (1) - PeakReservation: 3.00 MB (3145728) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 512.00 KB (524288) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns SELECT_NODE (id=5):(Total: 112.890ms, non-child: 420.797us, % non-child: 0.37%) ExecOption: Codegen Enabled - PeakMemoryUsage: 2.02 MB (2113536) - RowsReturned: 9 (9) - RowsReturnedRate: 79.00 /sec ANALYTIC_EVAL_NODE (id=4):(Total: 112.469ms, non-child: 33.329ms, % non-child: 29.63%) - EvaluationTime: 33.185ms - PeakMemoryUsage: 3.03 MB (3174400) - RowsReturned: 169.36K (169357) - RowsReturnedRate: 1.51 M/sec Buffer pool: - AllocTime: 9.561us - CumulativeAllocationBytes: 8.50 MB (8912896) - CumulativeAllocations: 17 (17) - PeakReservation: 1.00 MB (1048576) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 1.00 MB (1048576) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns SORT_NODE (id=3):(Total: 79.140ms, non-child: 49.463ms, % non-child: 62.50%) SortType: Total ExecOption: Codegen Enabled - NumRowsPerRun: (Avg: 169.36K (169357) ; Min: 169.36K (169357) ; Max: 169.36K (169357) ; Number of samples: 1) - InMemorySortTime: 40.079ms - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 10.51 MB (11022336) - RowsReturned: 169.36K (169357) - RowsReturnedRate: 2.14 M/sec - SortDataSize: 8.24 MB (8637207) - SpilledRuns: 0 (0) - TotalMergesPerformed: 0 (0) Buffer pool: - AllocTime: 5.813us - CumulativeAllocationBytes: 9.50 MB (9961472) - CumulativeAllocations: 19 (19) - PeakReservation: 9.50 MB (9961472) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 9.50 MB (9961472) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns ANALYTIC_EVAL_NODE (id=2):(Total: 29.676ms, non-child: 20.806ms, % non-child: 70.11%) - EvaluationTime: 20.585ms - PeakMemoryUsage: 2.03 MB (2125824) - RowsReturned: 169.36K (169357) - RowsReturnedRate: 5.71 M/sec Buffer pool: - AllocTime: 5.855us - CumulativeAllocationBytes: 7.00 MB (7340032) - CumulativeAllocations: 14 (14) - PeakReservation: 1.00 MB (1048576) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 1.00 MB (1048576) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns EXCHANGE_NODE (id=7):(Total: 8.870ms, non-child: 5.038ms, % non-child: 56.81%) ExecOption: Codegen Enabled - ConvertRowBatchTime: 0.000ns - MergeGetNext: 4.998ms - MergeGetNextBatch: 124.919us - PeakMemoryUsage: 9.53 MB (9994240) - RowsReturned: 169.36K (169357) - RowsReturnedRate: 19.09 M/sec Buffer pool: - AllocTime: 137.558us - CumulativeAllocationBytes: 11.66 MB (12230656) - CumulativeAllocations: 342 (342) - PeakReservation: 9.53 MB (9994240) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 9.53 MB (9994240) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: - FirstBatchWaitTime: 3.830ms - TotalBytesDequeued: 8.24 MB (8637207) - TotalGetBatchTime: 3.940ms - DataWaitTime: 3.831ms Enqueue: - DispatchTime: (Avg: 13.337us ; Min: 3.777us ; Max: 125.217us ; Number of samples: 171) - DeserializeRowBatchTime: 4.425ms - TotalBatchesEnqueued: 171 (171) - TotalBatchesReceived: 171 (171) - TotalBytesReceived: 3.51 MB (3684473) - TotalEarlySenders: 0 (0) - TotalEosReceived: 3 (3) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) CodeGen:(Total: 94.359ms, non-child: 94.359ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 12 (12) - CodegenTotalWallClockTime: 94.351ms - CodegenSysTime: 0.000ns - CodegenUserTime: 52.000ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 12.112ms - IrGenerationTime: 2.045ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.26 MB (2373896) - NumFunctions: 51 (51) - NumInstructions: 1.28K (1284) - OptimizationTime: 51.669ms - PeakMemoryUsage: 642.00 KB (657408) - PrepareTime: 10.572ms Averaged Fragment F00:(Total: 114.263ms, non-child: 366.924us, % non-child: 0.32%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:114.061ms max:115.563ms mean: 114.703ms stddev:632.235us execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 3 - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 8.60 MB (9014588) - PeakReservation: 6.00 MB (6291456) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 14.42 MB (15116309) - RowsProduced: 56.45K (56452) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 1.683ms - TotalStorageWaitTime: 122.149ms - TotalThreadsInvoluntaryContextSwitches: 107 (107) - TotalThreadsTotalWallClockTime: 250.031ms - TotalThreadsSysTime: 1.333ms - TotalThreadsUserTime: 36.000ms - TotalThreadsVoluntaryContextSwitches: 23 (23) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 10.825ms - ExecTreeExecTime: 200.152us - OpenTime: 103.110ms - ExecTreeOpenTime: 73.982ms - PrepareTime: 306.020us - ExecTreePrepareTime: 27.109us KrpcDataStreamSender (dst_id=7):(Total: 10.632ms, non-child: 10.632ms, % non-child: 100.00%) - EosSent: 1 (1) - NetworkThroughput: 376.13 MB/sec - PeakMemoryUsage: 3.88 KB (3968) - RowsSent: 56.45K (56452) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 7.351ms - TotalBytesSent: 1.17 MB (1228157) - UncompressedRowBatchSize: 2.75 MB (2879069) SORT_NODE (id=1):(Total: 74.178ms, non-child: 17.888ms, % non-child: 24.12%) - InMemorySortTime: 15.060ms - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 6.10 MB (6401024) - RowsReturned: 56.45K (56452) - RowsReturnedRate: 774.81 K/sec - SortDataSize: 2.31 MB (2427450) - SpilledRuns: 0 (0) - TotalMergesPerformed: 0 (0) Buffer pool: - AllocTime: 17.106us - CumulativeAllocationBytes: 3.50 MB (3670016) - CumulativeAllocations: 7 (7) - PeakReservation: 6.00 MB (6291456) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 3.50 MB (3670016) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns KUDU_SCAN_NODE (id=0):(Total: 56.290ms, non-child: 56.290ms, % non-child: 100.00%) - BytesRead: 0 - CollectionItemsRead: 0 (0) - KuduRemoteScanTokens: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 2.55 MB (2668885) - RowsRead: 56.45K (56452) - RowsReturned: 56.45K (56452) - RowsReturnedRate: 1.13 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 4 (4) - ScannerThreadsTotalWallClockTime: 136.117ms - MaterializeTupleTime(*): 53.888ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 6 (6) - TotalKuduScanRoundTrips: 3 (3) - TotalReadThroughput: 0.00 /sec CodeGen:(Total: 29.085ms, non-child: 29.085ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 22 (22) - CodegenTotalWallClockTime: 29.079ms - CodegenSysTime: 1.333ms - CodegenUserTime: 14.666ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 2.102ms - IrGenerationTime: 567.964us - LoadTime: 0.000ns - ModuleBitcodeSize: 2.26 MB (2373896) - NumFunctions: 18 (18) - NumInstructions: 664 (664) - OptimizationTime: 10.602ms - PeakMemoryUsage: 332.00 KB (339968) - PrepareTime: 15.163ms Fragment F00: Instance 704edd1edd4e5463:b6c7786e00000001 (host=gaborkaszabdesktop:22002):(Total: 115.210ms, non-child: 196.310us, % non-child: 0.17%) Hdfs split stats (:<# splits>/): Fragment Instance Lifecycle Event Timeline: 115.317ms - Prepare Finished: 283.162us (283.162us) - Open Finished: 107.944ms (107.661ms) - First Batch Produced: 107.948ms (3.890us) - First Batch Sent: 108.084ms (135.531us) - ExecInternal Finished: 115.317ms (7.233ms) - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 9.78 MB (10256359) - PeakReservation: 6.00 MB (6291456) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 9.78 MB (10256359) - RowsProduced: 56.83K (56830) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 627.800us - TotalStorageWaitTime: 94.047ms - TotalThreadsInvoluntaryContextSwitches: 82 (82) - TotalThreadsTotalWallClockTime: 212.342ms - TotalThreadsSysTime: 4.000ms - TotalThreadsUserTime: 32.000ms - TotalThreadsVoluntaryContextSwitches: 24 (24) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 7.373ms - ExecTreeExecTime: 158.733us - OpenTime: 107.656ms - ExecTreeOpenTime: 61.247ms - PrepareTime: 160.330us - ExecTreePrepareTime: 24.272us KrpcDataStreamSender (dst_id=7):(Total: 7.227ms, non-child: 6.592ms, % non-child: 91.22%) - EosSent: 1 (1) - NetworkThroughput: 395.46 MB/sec - PeakMemoryUsage: 3.88 KB (3968) - RowsSent: 56.83K (56830) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 5.956ms - TotalBytesSent: 1.08 MB (1134506) - UncompressedRowBatchSize: 2.76 MB (2898330) SORT_NODE (id=1):(Total: 61.415ms, non-child: 28.318ms, % non-child: 46.11%) SortType: Total ExecOption: Codegen Enabled - NumRowsPerRun: (Avg: 56.83K (56830) ; Min: 56.83K (56830) ; Max: 56.83K (56830) ; Number of samples: 1) - InMemorySortTime: 24.863ms - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 6.10 MB (6401024) - RowsReturned: 56.83K (56830) - RowsReturnedRate: 925.34 K/sec - SortDataSize: 2.33 MB (2443690) - SpilledRuns: 0 (0) - TotalMergesPerformed: 0 (0) Buffer pool: - AllocTime: 7.932us - CumulativeAllocationBytes: 3.50 MB (3670016) - CumulativeAllocations: 7 (7) - PeakReservation: 6.00 MB (6291456) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 3.50 MB (3670016) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns KUDU_SCAN_NODE (id=0):(Total: 33.096ms, non-child: 33.096ms, % non-child: 100.00%) - BytesRead: 0 - CollectionItemsRead: 0 (0) - KuduRemoteScanTokens: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 3.67 MB (3843072) - RowsRead: 56.83K (56830) - RowsReturned: 56.83K (56830) - RowsReturnedRate: 1.72 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 3 (3) - ScannerThreadsTotalWallClockTime: 97.336ms - MaterializeTupleTime(*): 31.440ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 6 (6) - TotalKuduScanRoundTrips: 3 (3) - TotalReadThroughput: 0.00 /sec CodeGen:(Total: 46.371ms, non-child: 46.371ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 5 (5) - CodegenTotalWallClockTime: 46.363ms - CodegenSysTime: 4.000ms - CodegenUserTime: 12.000ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 1.842ms - IrGenerationTime: 670.992us - LoadTime: 0.000ns - ModuleBitcodeSize: 2.26 MB (2373896) - NumFunctions: 18 (18) - NumInstructions: 664 (664) - OptimizationTime: 19.920ms - PeakMemoryUsage: 332.00 KB (339968) - PrepareTime: 23.292ms Instance 704edd1edd4e5463:b6c7786e00000003 (host=gaborkaszabdesktop:22000):(Total: 114.098ms, non-child: 466.445us, % non-child: 0.41%) Hdfs split stats (:<# splits>/): Fragment Instance Lifecycle Event Timeline: 114.209ms - Prepare Finished: 513.236us (513.236us) - Open Finished: 99.650ms (99.137ms) - First Batch Produced: 99.656ms (5.632us) - First Batch Sent: 99.829ms (173.597us) - ExecInternal Finished: 114.209ms (14.379ms) - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 8.00 MB (8393703) - PeakReservation: 6.00 MB (6291456) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 25.46 MB (26698866) - RowsProduced: 56.35K (56354) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 3.107ms - TotalStorageWaitTime: 117.819ms - TotalThreadsInvoluntaryContextSwitches: 113 (113) - TotalThreadsTotalWallClockTime: 250.103ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 40.000ms - TotalThreadsVoluntaryContextSwitches: 24 (24) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 14.560ms - ExecTreeExecTime: 272.848us - OpenTime: 99.130ms - ExecTreeOpenTime: 77.125ms - PrepareTime: 385.922us - ExecTreePrepareTime: 29.834us KrpcDataStreamSender (dst_id=7):(Total: 14.301ms, non-child: 11.188ms, % non-child: 78.23%) - EosSent: 1 (1) - NetworkThroughput: 323.38 MB/sec - PeakMemoryUsage: 3.88 KB (3968) - RowsSent: 56.35K (56354) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 8.246ms - TotalBytesSent: 1.27 MB (1331129) - UncompressedRowBatchSize: 2.74 MB (2874054) SORT_NODE (id=1):(Total: 77.370ms, non-child: 12.776ms, % non-child: 16.51%) SortType: Total ExecOption: Codegen Enabled - NumRowsPerRun: (Avg: 56.35K (56354) ; Min: 56.35K (56354) ; Max: 56.35K (56354) ; Number of samples: 1) - InMemorySortTime: 10.318ms - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 6.10 MB (6401024) - RowsReturned: 56.35K (56354) - RowsReturnedRate: 728.37 K/sec - SortDataSize: 2.31 MB (2423222) - SpilledRuns: 0 (0) - TotalMergesPerformed: 0 (0) Buffer pool: - AllocTime: 8.678us - CumulativeAllocationBytes: 3.50 MB (3670016) - CumulativeAllocations: 7 (7) - PeakReservation: 6.00 MB (6291456) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 3.50 MB (3670016) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns KUDU_SCAN_NODE (id=0):(Total: 64.593ms, non-child: 64.593ms, % non-child: 100.00%) - BytesRead: 0 - CollectionItemsRead: 0 (0) - KuduRemoteScanTokens: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 1.99 MB (2081792) - RowsRead: 56.35K (56354) - RowsReturned: 56.35K (56354) - RowsReturnedRate: 872.44 K/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 7 (7) - ScannerThreadsTotalWallClockTime: 136.425ms - MaterializeTupleTime(*): 63.364ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 6 (6) - TotalKuduScanRoundTrips: 3 (3) - TotalReadThroughput: 0.00 /sec CodeGen:(Total: 21.960ms, non-child: 21.960ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 33 (33) - CodegenTotalWallClockTime: 21.954ms - CodegenSysTime: 0.000ns - CodegenUserTime: 16.000ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 2.264ms - IrGenerationTime: 565.417us - LoadTime: 0.000ns - ModuleBitcodeSize: 2.26 MB (2373896) - NumFunctions: 18 (18) - NumInstructions: 664 (664) - OptimizationTime: 6.293ms - PeakMemoryUsage: 332.00 KB (339968) - PrepareTime: 12.043ms Instance 704edd1edd4e5463:b6c7786e00000002 (host=gaborkaszabdesktop:22001):(Total: 113.480ms, non-child: 438.012us, % non-child: 0.39%) Hdfs split stats (:<# splits>/): Fragment Instance Lifecycle Event Timeline: 113.555ms - Prepare Finished: 464.999us (464.999us) - Open Finished: 103.031ms (102.566ms) - First Batch Produced: 103.035ms (4.147us) - First Batch Sent: 103.209ms (174.586us) - ExecInternal Finished: 113.555ms (10.345ms) - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 8.00 MB (8393703) - PeakReservation: 6.00 MB (6291456) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 8.00 MB (8393703) - RowsProduced: 56.17K (56173) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 1.316ms - TotalStorageWaitTime: 154.582ms - TotalThreadsInvoluntaryContextSwitches: 127 (127) - TotalThreadsTotalWallClockTime: 287.647ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 36.000ms - TotalThreadsVoluntaryContextSwitches: 23 (23) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 10.541ms - ExecTreeExecTime: 168.875us - OpenTime: 102.544ms - ExecTreeOpenTime: 83.573ms - PrepareTime: 371.808us - ExecTreePrepareTime: 27.223us KrpcDataStreamSender (dst_id=7):(Total: 10.367ms, non-child: 9.045ms, % non-child: 87.25%) - EosSent: 1 (1) - NetworkThroughput: 409.54 MB/sec - PeakMemoryUsage: 3.88 KB (3968) - RowsSent: 56.17K (56173) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 7.851ms - TotalBytesSent: 1.16 MB (1218838) - UncompressedRowBatchSize: 2.73 MB (2864823) SORT_NODE (id=1):(Total: 83.750ms, non-child: 12.569ms, % non-child: 15.01%) SortType: Total ExecOption: Codegen Enabled - NumRowsPerRun: (Avg: 56.17K (56173) ; Min: 56.17K (56173) ; Max: 56.17K (56173) ; Number of samples: 1) - InMemorySortTime: 9.998ms - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 6.10 MB (6401024) - RowsReturned: 56.17K (56173) - RowsReturnedRate: 670.72 K/sec - SortDataSize: 2.30 MB (2415439) - SpilledRuns: 0 (0) - TotalMergesPerformed: 0 (0) Buffer pool: - AllocTime: 34.710us - CumulativeAllocationBytes: 3.50 MB (3670016) - CumulativeAllocations: 7 (7) - PeakReservation: 6.00 MB (6291456) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 3.50 MB (3670016) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns KUDU_SCAN_NODE (id=0):(Total: 71.180ms, non-child: 71.180ms, % non-child: 100.00%) - BytesRead: 0 - CollectionItemsRead: 0 (0) - KuduRemoteScanTokens: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 1.99 MB (2081792) - RowsRead: 56.17K (56173) - RowsReturned: 56.17K (56173) - RowsReturnedRate: 789.16 K/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 4 (4) - ScannerThreadsTotalWallClockTime: 174.590ms - MaterializeTupleTime(*): 66.860ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 6 (6) - TotalKuduScanRoundTrips: 3 (3) - TotalReadThroughput: 0.00 /sec CodeGen:(Total: 18.925ms, non-child: 18.925ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 28 (28) - CodegenTotalWallClockTime: 18.920ms - CodegenSysTime: 0.000ns - CodegenUserTime: 16.000ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 2.200ms - IrGenerationTime: 467.483us - LoadTime: 0.000ns - ModuleBitcodeSize: 2.26 MB (2373896) - NumFunctions: 18 (18) - NumInstructions: 664 (664) - OptimizationTime: 5.595ms - PeakMemoryUsage: 332.00 KB (339968) - PrepareTime: 10.155ms