Skip to content

Instantly share code, notes, and snippets.

/gist:1a5faa3a10d4495f7b8abc3c964457db Secret

Created April 21, 2017 04:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/1a5faa3a10d4495f7b8abc3c964457db to your computer and use it in GitHub Desktop.
Save anonymous/1a5faa3a10d4495f7b8abc3c964457db to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Query (id=bb4740d9a995d36b:1dd5f72500000000):
Summary:
Session ID: e74d0555e888e600:19042b2d3c235894
Session Type: BEESWAX
Start Time: 2017-04-20 19:59:34.032899000
End Time: 2017-04-20 19:59:55.667280000
Query Type: QUERY
Query State: FINISHED
Query Status: OK
Impala Version: impalad version 2.7.0-cdh5.10.1 RELEASE (build 876895d2a90346e69f2aea02d5528c2125ae7a32)
User: maurin
Connected User: maurin
Delegated User:
Network Address: ::ffff:172.16.0.154:52628
Default Db: knowlarity_v2_prod
Sql Statement: select distinct(cuberon_event_date) from knowlarity_v2_streaming
Coordinator: cdh1.net.cuberonlabs.com:22000
Query Options (non default):
Plan:
----------------
Estimated Per-Host Requirements: Memory=52.00MB VCores=2
PLAN-ROOT SINK
|
04:EXCHANGE [UNPARTITIONED]
| hosts=15 per-host-mem=unavailable
| tuple-ids=1 row-size=15B cardinality=1
|
03:AGGREGATE [FINALIZE]
| group by: (cuberon_event_date)
| hosts=15 per-host-mem=10.00MB
| tuple-ids=1 row-size=15B cardinality=1
|
02:EXCHANGE [HASH((cuberon_event_date))]
| hosts=15 per-host-mem=0B
| tuple-ids=1 row-size=15B cardinality=1
|
01:AGGREGATE [STREAMING]
| group by: (cuberon_event_date)
| hosts=15 per-host-mem=10.00MB
| tuple-ids=1 row-size=15B cardinality=1
|
00:SCAN HDFS [knowlarity_v2_prod.knowlarity_v2_streaming, RANDOM]
partitions=1/1 files=15 size=44.21MB
table stats: 16904 rows total
column stats: all
hosts=15 per-host-mem=32.00MB
tuple-ids=0 row-size=15B cardinality=16904
----------------
Estimated Per-Host Mem: 54525952
Estimated Per-Host VCores: 2
Request Pool: root.maurin
Admission result: Admitted immediately
ExecSummary:
Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail
------------------------------------------------------------------------------------------------------------------------
04:EXCHANGE 1 22.252us 22.252us 1 1 0 -1.00 B UNPARTITIONED
03:AGGREGATE 14 1.285ms 1.440ms 1 1 2.33 MB 10.00 MB FINALIZE
02:EXCHANGE 14 15.517us 142.770us 14 1 0 0 HASH((cuberon_event_date))
01:AGGREGATE 14 0.000ns 0.000ns 14 1 9.55 MB 10.00 MB STREAMING
00:SCAN HDFS 14 47.277ms 59.579ms 30.90K 16.90K 16.11 MB 32.00 MB knowlarity_v2_prod.knowlari...
Planner Timeline: 3.412ms
- Analysis finished: 817.899us (817.899us)
- Equivalence classes computed: 929.469us (111.570us)
- Single node plan created: 1.393ms (464.493us)
- Runtime filters computed: 1.459ms (65.774us)
- Distributed plan created: 1.773ms (313.469us)
- Lineage info computed: 1.832ms (59.604us)
- Planning finished: 3.412ms (1.580ms)
Query Timeline: 21s650ms
- Query submitted: 97.160us (97.160us)
- Planning finished: 9.280ms (9.183ms)
- Submit for admission: 10.606ms (1.326ms)
- Completed admission: 10.813ms (206.904us)
- Ready to start 29 fragment instances: 11.598ms (784.584us)
- All 29 fragment instances started: 26.694ms (15.096ms)
- Rows available: 21s140ms (21s114ms)
- First row fetched: 21s625ms (484.464ms)
- Unregister query: 21s634ms (9.175ms)
- ComputeScanRangeAssignmentTimer: 193.960us
ImpalaServer:
- ClientFetchWaitTimer: 489.127ms
- RowMaterializationTimer: 4.491ms
Execution Profile bb4740d9a995d36b:1dd5f72500000000:(Total: 21s133ms, non-child: 0.000ns, % non-child: 0.00%)
Number of filters: 0
Filter routing table:
ID Src. Node Tgt. Node(s) Targets Target type Partition filter Pending (Expected) First arrived Completed Enabled
----------------------------------------------------------------------------------------------------------------------------
Fragment instance start latencies: Count: 29, 25th %-ile: 1ms, 50th %-ile: 2ms, 75th %-ile: 5ms, 90th %-ile: 6ms, 95th %-ile: 6ms, 99.9th %-ile: 7ms
Per Node Peak Memory Usage: cdh16.net.cuberonlabs.com:22000(20.06 MB) cdh13.net.cuberonlabs.com:22000(12.06 MB) cdh11.net.cuberonlabs.com:22000(12.06 MB) cdh3.net.cuberonlabs.com:22000(12.10 MB) cdh10.net.cuberonlabs.com:22000(12.06 MB) cdh17.net.cuberonlabs.com:22000(12.06 MB) cdh9.net.cuberonlabs.com:22000(12.06 MB) cdh14.net.cuberonlabs.com:22000(12.06 MB) cdh12.net.cuberonlabs.com:22000(12.06 MB) cdh5.net.cuberonlabs.com:22000(12.06 MB) cdh15.net.cuberonlabs.com:22000(12.06 MB) cdh7.net.cuberonlabs.com:22000(12.06 MB) cdh8.net.cuberonlabs.com:22000(12.06 MB) cdh2.net.cuberonlabs.com:22000(12.06 MB) cdh1.net.cuberonlabs.com:22000(12.01 KB)
- FiltersReceived: 0 (0)
- FinalizationTimer: 0.000ns
Coordinator Fragment F02:
Instance bb4740d9a995d36b:1dd5f72500000000 (host=cdh1.net.cuberonlabs.com:22000):(Total: 21s612ms, non-child: 484.154ms, % non-child: 2.24%)
MemoryUsage(500.000ms): 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 12.00 KB
- AverageThreadTokens: 0.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 12.01 KB (12296)
- PerHostPeakMemUsage: 12.01 KB (12296)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 21s092ms
- TotalNetworkSendTime: 0.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s575ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 0.000ns
- TotalThreadsVoluntaryContextSwitches: 5 (5)
Fragment Instance Lifecycle Timings:
- ExecTime: 484.594ms
- ExecTreeExecTime: 1.117ms
- OpenTime: 21s091ms
- ExecTreeOpenTime: 21s090ms
- PrepareTime: 36.676ms
- ExecTreePrepareTime: 34.392us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 0 (0)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 0
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
PLAN_ROOT_SINK:
- PeakMemoryUsage: 0
CodeGen:(Total: 36.317ms, non-child: 36.317ms, % non-child: 100.00%)
- CodegenTime: 0.000ns
- CompileTime: 0.000ns
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 0 (0)
- NumInstructions: 0 (0)
- OptimizationTime: 0.000ns
- PeakMemoryUsage: 0
- PrepareTime: 35.551ms
EXCHANGE_NODE (id=4):(Total: 21s092ms, non-child: 22.252us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30.00 B
- BytesReceived: 30.00 B (30)
- ConvertRowBatchTime: 1.632us
- DeserializeRowBatchTimer: 9.512us
- FirstBatchArrivalWaitTime: 21s090ms
- PeakMemoryUsage: 0
- RowsReturned: 1 (1)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Averaged Fragment F01:(Total: 21s126ms, non-child: 4.433ms, % non-child: 0.02%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:21s125ms max:21s129ms mean: 21s127ms stddev:1.072ms
execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
num instances: 14
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.63 MB (13245373)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s987ms
- TotalNetworkSendTime: 23.118us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s086ms
- TotalThreadsSysTime: 857.142us
- TotalThreadsUserTime: 98.571ms
- TotalThreadsVoluntaryContextSwitches: 9 (9)
Fragment Instance Lifecycle Timings:
- ExecTime: 306.437us
- ExecTreeExecTime: 6.020us
- OpenTime: 21s086ms
- ExecTreeOpenTime: 20s988ms
- PrepareTime: 39.807ms
- ExecTreePrepareTime: 547.565us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 26.062us, non-child: 26.062us, % non-child: 100.00%)
- BytesSent: 2.00 B (2)
- NetworkThroughput(*): 53.38 KB/sec
- OverallThroughput: 24.09 KB/sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 1.628us
- TransmitDataRPCTime: 2.800us
- UncompressedRowBatchSize: 2.00 B (2)
CodeGen:(Total: 133.249ms, non-child: 133.249ms, % non-child: 100.00%)
- CodegenTime: 5.054ms
- CompileTime: 24.544ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 71.006ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 36.515ms
AGGREGATION_NODE (id=3):(Total: 20s988ms, non-child: 1.285ms, % non-child: 0.01%)
- BuildTime: 9.132us
- GetNewBlockTime: 192.048us
- GetResultsTime: 163.000ns
- HTResizeTime: 4.062us
- HashBuckets: 73 (73)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2393216)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.118us
EXCHANGE_NODE (id=2):(Total: 20s987ms, non-child: 20s987ms, % non-child: 100.00%)
- BytesReceived: 30.00 B (30)
- ConvertRowBatchTime: 1.940us
- DeserializeRowBatchTimer: 9.838us
- FirstBatchArrivalWaitTime: 20s825ms
- PeakMemoryUsage: 0
- RowsReturned: 1 (1)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Fragment F01:
Instance bb4740d9a995d36b:19 (host=cdh11.net.cuberonlabs.com:22000):(Total: 21s128ms, non-child: 3.056ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.28 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s990ms
- TotalNetworkSendTime: 276.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s090ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 104.000ms
- TotalThreadsVoluntaryContextSwitches: 4 (4)
Fragment Instance Lifecycle Timings:
- ExecTime: 275.923us
- ExecTreeExecTime: 3.133us
- OpenTime: 21s090ms
- ExecTreeOpenTime: 20s991ms
- PrepareTime: 37.201ms
- ExecTreePrepareTime: 570.246us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 23.724us, non-child: 23.724us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 132.842ms, non-child: 132.842ms, % non-child: 100.00%)
- CodegenTime: 3.196ms
- CompileTime: 24.384ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 72.935ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 34.714ms
AGGREGATION_NODE (id=3):(Total: 20s992ms, non-child: 1.301ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 7.927us
- GetNewBlockTime: 208.004us
- GetResultsTime: 0.000ns
- HTResizeTime: 5.024us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.166us
EXCHANGE_NODE (id=2):(Total: 20s990ms, non-child: 5.659us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 290.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s990ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:1a (host=cdh10.net.cuberonlabs.com:22000):(Total: 21s127ms, non-child: 3.012ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s990ms
- TotalNetworkSendTime: 330.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s089ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 104.000ms
- TotalThreadsVoluntaryContextSwitches: 6 (6)
Fragment Instance Lifecycle Timings:
- ExecTime: 305.052us
- ExecTreeExecTime: 3.610us
- OpenTime: 21s089ms
- ExecTreeOpenTime: 20s991ms
- PrepareTime: 37.946ms
- ExecTreePrepareTime: 573.311us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 24.087us, non-child: 24.087us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 133.195ms, non-child: 133.195ms, % non-child: 100.00%)
- CodegenTime: 3.298ms
- CompileTime: 24.252ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 72.770ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 35.374ms
AGGREGATION_NODE (id=3):(Total: 20s991ms, non-child: 1.404ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 7.567us
- GetNewBlockTime: 213.814us
- GetResultsTime: 0.000ns
- HTResizeTime: 4.220us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.095us
EXCHANGE_NODE (id=2):(Total: 20s990ms, non-child: 6.669us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 530.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s990ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:1b (host=cdh13.net.cuberonlabs.com:22000):(Total: 21s127ms, non-child: 2.951ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s990ms
- TotalNetworkSendTime: 314.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s089ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 96.000ms
- TotalThreadsVoluntaryContextSwitches: 5 (5)
Fragment Instance Lifecycle Timings:
- ExecTime: 307.193us
- ExecTreeExecTime: 4.230us
- OpenTime: 21s089ms
- ExecTreeOpenTime: 20s991ms
- PrepareTime: 37.823ms
- ExecTreePrepareTime: 551.441us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 20.870us, non-child: 20.870us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 132.958ms, non-child: 132.958ms, % non-child: 100.00%)
- CodegenTime: 3.243ms
- CompileTime: 23.902ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 72.952ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 35.303ms
AGGREGATION_NODE (id=3):(Total: 20s991ms, non-child: 1.159ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 7.097us
- GetNewBlockTime: 194.002us
- GetResultsTime: 0.000ns
- HTResizeTime: 4.234us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.097us
EXCHANGE_NODE (id=2):(Total: 20s990ms, non-child: 5.629us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 440.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s990ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:1c (host=cdh16.net.cuberonlabs.com:22000):(Total: 21s127ms, non-child: 3.095ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.64 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 20.06 MB (21031284)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s983ms
- TotalNetworkSendTime: 293.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s088ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 108.000ms
- TotalThreadsVoluntaryContextSwitches: 5 (5)
Fragment Instance Lifecycle Timings:
- ExecTime: 305.951us
- ExecTreeExecTime: 3.234us
- OpenTime: 21s088ms
- ExecTreeOpenTime: 20s984ms
- PrepareTime: 39.216ms
- ExecTreePrepareTime: 539.898us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 22.077us, non-child: 22.077us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 139.406ms, non-child: 139.406ms, % non-child: 100.00%)
- CodegenTime: 3.367ms
- CompileTime: 24.940ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 76.997ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 36.603ms
AGGREGATION_NODE (id=3):(Total: 20s985ms, non-child: 1.363ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 7.747us
- GetNewBlockTime: 191.078us
- GetResultsTime: 0.000ns
- HTResizeTime: 4.465us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.100us
EXCHANGE_NODE (id=2):(Total: 20s983ms, non-child: 6.312us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 293.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s983ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:17 (host=cdh3.net.cuberonlabs.com:22000):(Total: 21s127ms, non-child: 2.976ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.33 MB, 2.34 MB, 2.34 MB, 2.35 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.10 MB (12683644)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 20s996ms
- TotalNetworkSendTime: 320.204us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s092ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 100.000ms
- TotalThreadsVoluntaryContextSwitches: 20 (20)
Fragment Instance Lifecycle Timings:
- ExecTime: 578.840us
- ExecTreeExecTime: 39.974us
- OpenTime: 21s091ms
- ExecTreeOpenTime: 20s997ms
- PrepareTime: 35.155ms
- ExecTreePrepareTime: 582.390us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 86.868us, non-child: 86.868us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 747.25 KB/sec
- OverallThroughput: 337.26 KB/sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 1 (1)
- SerializeBatchTime: 22.800us
- TransmitDataRPCTime: 39.206us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 126.605ms, non-child: 126.605ms, % non-child: 100.00%)
- CodegenTime: 2.730ms
- CompileTime: 23.547ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 69.527ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 32.779ms
AGGREGATION_NODE (id=3):(Total: 20s997ms, non-child: 1.346ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 30.792us
- GetNewBlockTime: 190.624us
- GetResultsTime: 2.294us
- HTResizeTime: 4.580us
- HashBuckets: 1.02K (1024)
- LargestPartitionPercent: 7 (7)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.33 MB (2446464)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.206us
EXCHANGE_NODE (id=2):(Total: 20s996ms, non-child: 142.770us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 240.00 B, 330.00 B, 360.00 B, 390.00 B
- BytesReceived: 420.00 B (420)
- ConvertRowBatchTime: 21.948us
- DeserializeRowBatchTimer: 137.744us
- FirstBatchArrivalWaitTime: 18s729ms
- PeakMemoryUsage: 0
- RowsReturned: 14 (14)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:18 (host=cdh9.net.cuberonlabs.com:22000):(Total: 21s127ms, non-child: 10.406ms, % non-child: 0.05%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s970ms
- TotalNetworkSendTime: 221.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 2 (2)
- TotalThreadsTotalWallClockTime: 21s078ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 96.000ms
- TotalThreadsVoluntaryContextSwitches: 15 (15)
Fragment Instance Lifecycle Timings:
- ExecTime: 331.871us
- ExecTreeExecTime: 2.323us
- OpenTime: 21s078ms
- ExecTreeOpenTime: 20s971ms
- PrepareTime: 48.463ms
- ExecTreePrepareTime: 448.851us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 17.345us, non-child: 17.345us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 144.875ms, non-child: 144.875ms, % non-child: 100.00%)
- CodegenTime: 14.100ms
- CompileTime: 29.595ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 71.429ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 42.371ms
AGGREGATION_NODE (id=3):(Total: 20s972ms, non-child: 1.084ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 12.676us
- GetNewBlockTime: 161.453us
- GetResultsTime: 0.000ns
- HTResizeTime: 3.287us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 982.000ns
EXCHANGE_NODE (id=2):(Total: 20s970ms, non-child: 4.279us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 311.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s970ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:15 (host=cdh14.net.cuberonlabs.com:22000):(Total: 21s126ms, non-child: 4.911ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s976ms
- TotalNetworkSendTime: 277.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 21s079ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 100.000ms
- TotalThreadsVoluntaryContextSwitches: 11 (11)
Fragment Instance Lifecycle Timings:
- ExecTime: 256.822us
- ExecTreeExecTime: 3.620us
- OpenTime: 21s078ms
- ExecTreeOpenTime: 20s976ms
- PrepareTime: 47.367ms
- ExecTreePrepareTime: 538.693us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 17.024us, non-child: 17.024us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 144.279ms, non-child: 144.279ms, % non-child: 100.00%)
- CodegenTime: 7.062ms
- CompileTime: 25.809ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 73.756ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 40.500ms
AGGREGATION_NODE (id=3):(Total: 20s977ms, non-child: 1.250ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 6.654us
- GetNewBlockTime: 190.045us
- GetResultsTime: 0.000ns
- HTResizeTime: 3.742us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.131us
EXCHANGE_NODE (id=2):(Total: 20s976ms, non-child: 6.280us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 627.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s976ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:16 (host=cdh17.net.cuberonlabs.com:22000):(Total: 21s126ms, non-child: 2.882ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12650868)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s988ms
- TotalNetworkSendTime: 263.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s089ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 104.000ms
- TotalThreadsVoluntaryContextSwitches: 5 (5)
Fragment Instance Lifecycle Timings:
- ExecTime: 206.188us
- ExecTreeExecTime: 4.230us
- OpenTime: 21s089ms
- ExecTreeOpenTime: 20s989ms
- PrepareTime: 37.110ms
- ExecTreePrepareTime: 504.313us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 21.800us, non-child: 21.800us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 133.767ms, non-child: 133.767ms, % non-child: 100.00%)
- CodegenTime: 3.259ms
- CompileTime: 24.364ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 74.070ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 34.500ms
AGGREGATION_NODE (id=3):(Total: 20s989ms, non-child: 1.240ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 6.543us
- GetNewBlockTime: 177.169us
- GetResultsTime: 0.000ns
- HTResizeTime: 3.432us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 899.000ns
EXCHANGE_NODE (id=2):(Total: 20s988ms, non-child: 6.241us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 320.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s988ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:14 (host=cdh12.net.cuberonlabs.com:22000):(Total: 21s126ms, non-child: 3.032ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s990ms
- TotalNetworkSendTime: 287.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 21s089ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 100.000ms
- TotalThreadsVoluntaryContextSwitches: 4 (4)
Fragment Instance Lifecycle Timings:
- ExecTime: 283.078us
- ExecTreeExecTime: 4.059us
- OpenTime: 21s088ms
- ExecTreeOpenTime: 20s991ms
- PrepareTime: 37.081ms
- ExecTreePrepareTime: 572.889us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 22.369us, non-child: 22.369us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 131.320ms, non-child: 131.320ms, % non-child: 100.00%)
- CodegenTime: 3.181ms
- CompileTime: 24.178ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 71.810ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 34.551ms
AGGREGATION_NODE (id=3):(Total: 20s992ms, non-child: 1.297ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 7.504us
- GetNewBlockTime: 206.489us
- GetResultsTime: 0.000ns
- HTResizeTime: 4.777us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.360us
EXCHANGE_NODE (id=2):(Total: 20s990ms, non-child: 6.235us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 600.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s990ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:12 (host=cdh15.net.cuberonlabs.com:22000):(Total: 21s126ms, non-child: 3.124ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s984ms
- TotalNetworkSendTime: 257.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 21s087ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 104.000ms
- TotalThreadsVoluntaryContextSwitches: 7 (7)
Fragment Instance Lifecycle Timings:
- ExecTime: 301.242us
- ExecTreeExecTime: 4.377us
- OpenTime: 21s087ms
- ExecTreeOpenTime: 20s985ms
- PrepareTime: 38.495ms
- ExecTreePrepareTime: 558.910us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 21.768us, non-child: 21.768us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 137.118ms, non-child: 137.118ms, % non-child: 100.00%)
- CodegenTime: 3.332ms
- CompileTime: 25.072ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 75.147ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 36.050ms
AGGREGATION_NODE (id=3):(Total: 20s985ms, non-child: 1.440ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 7.607us
- GetNewBlockTime: 193.320us
- GetResultsTime: 0.000ns
- HTResizeTime: 4.128us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.103us
EXCHANGE_NODE (id=2):(Total: 20s984ms, non-child: 5.656us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 356.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s984ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:13 (host=cdh5.net.cuberonlabs.com:22000):(Total: 21s125ms, non-child: 3.016ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s989ms
- TotalNetworkSendTime: 264.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s089ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 100.000ms
- TotalThreadsVoluntaryContextSwitches: 9 (9)
Fragment Instance Lifecycle Timings:
- ExecTime: 303.068us
- ExecTreeExecTime: 3.680us
- OpenTime: 21s088ms
- ExecTreeOpenTime: 20s990ms
- PrepareTime: 36.671ms
- ExecTreePrepareTime: 585.716us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 20.316us, non-child: 20.316us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 131.823ms, non-child: 131.823ms, % non-child: 100.00%)
- CodegenTime: 3.236ms
- CompileTime: 24.570ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 72.416ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 34.040ms
AGGREGATION_NODE (id=3):(Total: 20s991ms, non-child: 1.339ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 9.028us
- GetNewBlockTime: 211.720us
- GetResultsTime: 0.000ns
- HTResizeTime: 5.520us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.260us
EXCHANGE_NODE (id=2):(Total: 20s989ms, non-child: 6.256us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 424.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s989ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:11 (host=cdh7.net.cuberonlabs.com:22000):(Total: 21s125ms, non-child: 3.358ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s987ms
- TotalNetworkSendTime: 280.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s087ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 104.000ms
- TotalThreadsVoluntaryContextSwitches: 5 (5)
Fragment Instance Lifecycle Timings:
- ExecTime: 308.511us
- ExecTreeExecTime: 3.424us
- OpenTime: 21s086ms
- ExecTreeOpenTime: 20s988ms
- PrepareTime: 38.211ms
- ExecTreePrepareTime: 582.975us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 24.097us, non-child: 24.097us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 132.721ms, non-child: 132.721ms, % non-child: 100.00%)
- CodegenTime: 3.022ms
- CompileTime: 24.200ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 72.085ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 35.566ms
AGGREGATION_NODE (id=3):(Total: 20s989ms, non-child: 1.402ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 7.783us
- GetNewBlockTime: 194.540us
- GetResultsTime: 0.000ns
- HTResizeTime: 4.671us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.096us
EXCHANGE_NODE (id=2):(Total: 20s987ms, non-child: 6.232us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 323.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s987ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:10 (host=cdh8.net.cuberonlabs.com:22000):(Total: 21s124ms, non-child: 11.988ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s999ms
- TotalNetworkSendTime: 240.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 21s076ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 60.000ms
- TotalThreadsVoluntaryContextSwitches: 23 (23)
Fragment Instance Lifecycle Timings:
- ExecTime: 277.084us
- ExecTreeExecTime: 2.966us
- OpenTime: 21s076ms
- ExecTreeOpenTime: 21s000ms
- PrepareTime: 47.947ms
- ExecTreePrepareTime: 453.423us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 17.983us, non-child: 17.983us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 111.756ms, non-child: 111.756ms, % non-child: 100.00%)
- CodegenTime: 14.492ms
- CompileTime: 20.664ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 45.727ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 43.453ms
AGGREGATION_NODE (id=3):(Total: 21s001ms, non-child: 1.229ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 5.824us
- GetNewBlockTime: 151.125us
- GetResultsTime: 0.000ns
- HTResizeTime: 2.924us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 969.000ns
EXCHANGE_NODE (id=2):(Total: 20s999ms, non-child: 5.476us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 507.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s999ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance bb4740d9a995d36b:f (host=cdh2.net.cuberonlabs.com:22000):(Total: 21s124ms, non-child: 4.259ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 2.64 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 2.64 MB (2773144)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 20s986ms
- TotalNetworkSendTime: 152.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 21s086ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 100.000ms
- TotalThreadsVoluntaryContextSwitches: 7 (7)
Fragment Instance Lifecycle Timings:
- ExecTime: 249.300us
- ExecTreeExecTime: 1.432us
- OpenTime: 21s085ms
- ExecTreeOpenTime: 20s987ms
- PrepareTime: 38.612ms
- ExecTreePrepareTime: 602.860us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 48 (48)
- BlocksRecycled: 0 (0)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 784.00 KB (802816)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=4):(Total: 24.552us, non-child: 24.552us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 7.52 KB (7704)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 132.822ms, non-child: 132.822ms, % non-child: 100.00%)
- CodegenTime: 3.233ms
- CompileTime: 24.138ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 41 (41)
- NumInstructions: 735 (735)
- OptimizationTime: 72.468ms
- PeakMemoryUsage: 367.50 KB (376320)
- PrepareTime: 35.403ms
AGGREGATION_NODE (id=3):(Total: 20s987ms, non-child: 1.133ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 3.104us
- GetNewBlockTime: 205.300us
- GetResultsTime: 0.000ns
- HTResizeTime: 1.876us
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.28 MB (2389120)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.196us
EXCHANGE_NODE (id=2):(Total: 20s986ms, non-child: 3.548us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 192.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 20s986ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Averaged Fragment F00:(Total: 19s534ms, non-child: 31.180ms, % non-child: 0.16%)
split sizes: min: 2.62 MB, max: 6.83 MB, avg: 3.16 MB, stddev: 1.02 MB
completion times: min:18s848ms max:21s121ms mean: 19s536ms stddev:655.722ms
execution rates: min:136.18 KB/sec max:370.83 KB/sec mean:166.27 KB/sec stddev:57.45 KB/sec
num instances: 14
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 10.34 MB (10843721)
- PerHostPeakMemUsage: 12.63 MB (13245373)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 400.728us
- TotalStorageWaitTime: 11.038ms
- TotalThreadsInvoluntaryContextSwitches: 23 (23)
- TotalThreadsTotalWallClockTime: 19s486ms
- TotalThreadsSysTime: 370.000ms
- TotalThreadsUserTime: 19s083ms
- TotalThreadsVoluntaryContextSwitches: 36 (36)
Fragment Instance Lifecycle Timings:
- ExecTime: 26.826ms
- ExecTreeExecTime: 22.743ms
- OpenTime: 19s437ms
- ExecTreeOpenTime: 37.534us
- PrepareTime: 70.529ms
- ExecTreePrepareTime: 12.902ms
DataStreamSender (dst_id=2):(Total: 185.490us, non-child: 185.490us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 742.83 KB/sec
- OverallThroughput: 213.24 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 55.190us
- TransmitDataRPCTime: 93.044us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s467ms, non-child: 19s467ms, % non-child: 100.00%)
- CodegenTime: 2.827ms
- CompileTime: 3s820ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s615ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 31.180ms
AGGREGATION_NODE (id=1):(Total: 35.678ms, non-child: 0.000ns, % non-child: 0.00%)
- GetNewBlockTime: 94.186us
- GetResultsTime: 971.000ns
- HTResizeTime: 196.824us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.83 MB (6113993)
- PinTime: 0.000ns
- ReductionFactorEstimate: 1165.07
- ReductionFactorThresholdToExpand: 0.08
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 27.00 /sec
- StreamingTime: 390.172us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 47.277ms, non-child: 47.277ms, % non-child: 100.00%)
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.37 MB (3534004)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.37 MB (3534004)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.37 MB (3534004)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.63 MB (9053696)
- PerReadThreadRawHdfsThroughput: 2.49 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 21.426ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.21K (2207)
- RowsReturned: 2.21K (2207)
- RowsReturnedRate: 46.64 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 22.940ms
- MaterializeTupleTime(*): 19.918us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 9.428ms
- ScannerThreadsVoluntaryContextSwitches: 8 (8)
- TotalRawHdfsReadTime(*): 1.360ms
- TotalReadThroughput: 0.00 /sec
Fragment F00:
Instance bb4740d9a995d36b:1 (host=cdh2.net.cuberonlabs.com:22000):(Total: 21s119ms, non-child: 26.980ms, % non-child: 0.13%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.89 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 285.848us
- TotalStorageWaitTime: 9.557ms
- TotalThreadsInvoluntaryContextSwitches: 24 (24)
- TotalThreadsTotalWallClockTime: 21s073ms
- TotalThreadsSysTime: 520.000ms
- TotalThreadsUserTime: 20s492ms
- TotalThreadsVoluntaryContextSwitches: 57 (57)
Fragment Instance Lifecycle Timings:
- ExecTime: 26.559ms
- ExecTreeExecTime: 22.772ms
- OpenTime: 21s025ms
- ExecTreeOpenTime: 31.884us
- PrepareTime: 67.341ms
- ExecTreePrepareTime: 13.461ms
DataStreamSender (dst_id=2):(Total: 153.976us, non-child: 153.976us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 939.36 KB/sec
- OverallThroughput: 190.27 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 80.764us
- TransmitDataRPCTime: 31.188us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 21s056ms, non-child: 21s056ms, % non-child: 100.00%)
- CodegenTime: 2.907ms
- CompileTime: 4s173ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 16s850ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 31.064ms
AGGREGATION_NODE (id=1):(Total: 36.261ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 101.136us
- GetResultsTime: 824.000ns
- HTResizeTime: 158.928us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 27.00 /sec
- StreamingTime: 306.880us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 48.437ms, non-child: 48.437ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.89 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.09 MB (3242208)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.09 MB (3242208)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.09 MB (3242208)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.32 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 21.059ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 41.29 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 1 (1)
- ScannerThreadsTotalWallClockTime: 21.186ms
- MaterializeTupleTime(*): 21.580us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 12.000ms
- ScannerThreadsVoluntaryContextSwitches: 7 (7)
- TotalRawHdfsReadTime(*): 1.303ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:2 (host=cdh8.net.cuberonlabs.com:22000):(Total: 20s531ms, non-child: 69.243ms, % non-child: 0.34%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.92 MB
MemoryUsage(500.000ms): 1.27 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 346.529us
- TotalStorageWaitTime: 26.572ms
- TotalThreadsInvoluntaryContextSwitches: 21 (21)
- TotalThreadsTotalWallClockTime: 20s465ms
- TotalThreadsSysTime: 384.000ms
- TotalThreadsUserTime: 20s012ms
- TotalThreadsVoluntaryContextSwitches: 47 (47)
Fragment Instance Lifecycle Timings:
- ExecTime: 42.878ms
- ExecTreeExecTime: 39.518ms
- OpenTime: 20s384ms
- ExecTreeOpenTime: 64.069us
- PrepareTime: 104.237ms
- ExecTreePrepareTime: 10.585ms
DataStreamSender (dst_id=2):(Total: 131.525us, non-child: 131.525us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 813.85 KB/sec
- OverallThroughput: 222.75 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 61.052us
- TransmitDataRPCTime: 35.998us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 20s412ms, non-child: 20s412ms, % non-child: 100.00%)
- CodegenTime: 2.761ms
- CompileTime: 4s063ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 16s317ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 30.377ms
AGGREGATION_NODE (id=1):(Total: 50.163ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 84.596us
- GetResultsTime: 827.000ns
- HTResizeTime: 170.513us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 19.00 /sec
- StreamingTime: 295.936us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 59.579ms, non-child: 59.579ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.92 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.12 MB (3273468)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.12 MB (3273468)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.12 MB (3273468)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.31 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 37.631ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 33.57 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 37.750ms
- MaterializeTupleTime(*): 16.838us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 12.000ms
- ScannerThreadsVoluntaryContextSwitches: 7 (7)
- TotalRawHdfsReadTime(*): 1.318ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:7 (host=cdh14.net.cuberonlabs.com:22000):(Total: 20s274ms, non-child: 48.970ms, % non-child: 0.24%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.70 MB
MemoryUsage(500.000ms): 1.37 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 335.425us
- TotalStorageWaitTime: 7.548ms
- TotalThreadsInvoluntaryContextSwitches: 21 (21)
- TotalThreadsTotalWallClockTime: 20s208ms
- TotalThreadsSysTime: 348.000ms
- TotalThreadsUserTime: 19s836ms
- TotalThreadsVoluntaryContextSwitches: 28 (28)
Fragment Instance Lifecycle Timings:
- ExecTime: 24.728ms
- ExecTreeExecTime: 20.242ms
- OpenTime: 20s164ms
- ExecTreeOpenTime: 30.917us
- PrepareTime: 85.078ms
- ExecTreePrepareTime: 12.427ms
DataStreamSender (dst_id=2):(Total: 128.905us, non-child: 128.905us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 751.90 KB/sec
- OverallThroughput: 227.27 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 53.640us
- TransmitDataRPCTime: 38.964us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 20s192ms, non-child: 20s192ms, % non-child: 100.00%)
- CodegenTime: 2.835ms
- CompileTime: 3s766ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 16s395ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 29.753ms
AGGREGATION_NODE (id=1):(Total: 32.696ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 81.068us
- GetResultsTime: 1.662us
- HTResizeTime: 194.645us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 30.00 /sec
- StreamingTime: 504.633us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 43.622ms, non-child: 43.622ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.70 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 2.90 MB (3035664)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 2.90 MB (3035664)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 2.90 MB (3035664)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 4.06 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 18.719ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 1.86K (1858)
- RowsReturned: 1.86K (1858)
- RowsReturnedRate: 42.59 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 18.948ms
- MaterializeTupleTime(*): 17.352us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 5 (5)
- TotalRawHdfsReadTime(*): 696.649us
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:a (host=cdh9.net.cuberonlabs.com:22000):(Total: 19s792ms, non-child: 61.795ms, % non-child: 0.31%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.78 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 340.755us
- TotalStorageWaitTime: 8.970ms
- TotalThreadsInvoluntaryContextSwitches: 29 (29)
- TotalThreadsTotalWallClockTime: 19s722ms
- TotalThreadsSysTime: 384.000ms
- TotalThreadsUserTime: 19s308ms
- TotalThreadsVoluntaryContextSwitches: 40 (40)
Fragment Instance Lifecycle Timings:
- ExecTime: 29.013ms
- ExecTreeExecTime: 22.099ms
- OpenTime: 19s673ms
- ExecTreeOpenTime: 37.220us
- PrepareTime: 90.230ms
- ExecTreePrepareTime: 11.108ms
DataStreamSender (dst_id=2):(Total: 121.674us, non-child: 121.674us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 777.91 KB/sec
- OverallThroughput: 240.78 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 54.438us
- TransmitDataRPCTime: 37.661us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s697ms, non-child: 19s697ms, % non-child: 100.00%)
- CodegenTime: 2.521ms
- CompileTime: 3s875ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s793ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 27.051ms
AGGREGATION_NODE (id=1):(Total: 33.240ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 71.726us
- GetResultsTime: 753.000ns
- HTResizeTime: 107.969us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 30.00 /sec
- StreamingTime: 231.103us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 43.322ms, non-child: 43.322ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.78 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 2.98 MB (3125043)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 2.98 MB (3125043)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 2.98 MB (3125043)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.35 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 20.464ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 46.16 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 20.562ms
- MaterializeTupleTime(*): 15.725us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 12.000ms
- ScannerThreadsVoluntaryContextSwitches: 10 (10)
- TotalRawHdfsReadTime(*): 1.236ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:3 (host=cdh7.net.cuberonlabs.com:22000):(Total: 19s678ms, non-child: 23.901ms, % non-child: 0.12%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.90 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 490.472us
- TotalStorageWaitTime: 9.737ms
- TotalThreadsInvoluntaryContextSwitches: 21 (21)
- TotalThreadsTotalWallClockTime: 19s636ms
- TotalThreadsSysTime: 408.000ms
- TotalThreadsUserTime: 19s200ms
- TotalThreadsVoluntaryContextSwitches: 29 (29)
Fragment Instance Lifecycle Timings:
- ExecTime: 25.755ms
- ExecTreeExecTime: 21.506ms
- OpenTime: 19s589ms
- ExecTreeOpenTime: 36.688us
- PrepareTime: 62.985ms
- ExecTreePrepareTime: 13.495ms
DataStreamSender (dst_id=2):(Total: 120.246us, non-child: 120.246us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 598.14 KB/sec
- OverallThroughput: 243.64 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 33.423us
- TransmitDataRPCTime: 48.980us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s619ms, non-child: 19s619ms, % non-child: 100.00%)
- CodegenTime: 2.772ms
- CompileTime: 3s908ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s679ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 30.146ms
AGGREGATION_NODE (id=1):(Total: 35.033ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 106.506us
- GetResultsTime: 1.064us
- HTResizeTime: 182.283us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 28.00 /sec
- StreamingTime: 453.842us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 47.112ms, non-child: 47.112ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.90 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.10 MB (3252926)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.10 MB (3252926)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.10 MB (3252926)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.32 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 20.273ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 42.45 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 1 (1)
- ScannerThreadsTotalWallClockTime: 20.499ms
- MaterializeTupleTime(*): 19.234us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 6 (6)
- TotalRawHdfsReadTime(*): 1.308ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:9 (host=cdh3.net.cuberonlabs.com:22000):(Total: 19s548ms, non-child: 23.145ms, % non-child: 0.12%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.62 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.10 MB (12683644)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 290.994us
- TotalStorageWaitTime: 8.633ms
- TotalThreadsInvoluntaryContextSwitches: 20 (20)
- TotalThreadsTotalWallClockTime: 19s505ms
- TotalThreadsSysTime: 392.000ms
- TotalThreadsUserTime: 19s088ms
- TotalThreadsVoluntaryContextSwitches: 31 (31)
Fragment Instance Lifecycle Timings:
- ExecTime: 24.588ms
- ExecTreeExecTime: 20.457ms
- OpenTime: 19s461ms
- ExecTreeOpenTime: 40.280us
- PrepareTime: 62.178ms
- ExecTreePrepareTime: 13.002ms
DataStreamSender (dst_id=2):(Total: 110.460us, non-child: 110.460us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 664.03 KB/sec
- OverallThroughput: 265.23 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 31.172us
- TransmitDataRPCTime: 44.120us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s491ms, non-child: 19s491ms, % non-child: 100.00%)
- CodegenTime: 2.955ms
- CompileTime: 3s741ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s718ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 30.572ms
AGGREGATION_NODE (id=1):(Total: 33.495ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 95.750us
- GetResultsTime: 900.000ns
- HTResizeTime: 213.574us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 29.00 /sec
- StreamingTime: 353.000us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 45.273ms, non-child: 45.273ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.62 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 2.81 MB (2951398)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 2.81 MB (2951398)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 2.81 MB (2951398)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.50 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 19.369ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 1.90K (1904)
- RowsReturned: 1.90K (1904)
- RowsReturnedRate: 42.05 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 1 (1)
- ScannerThreadsTotalWallClockTime: 19.560ms
- MaterializeTupleTime(*): 19.022us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 5 (5)
- TotalRawHdfsReadTime(*): 1.099ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:b (host=cdh11.net.cuberonlabs.com:22000):(Total: 19s228ms, non-child: 22.185ms, % non-child: 0.12%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.89 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 342.158us
- TotalStorageWaitTime: 9.065ms
- TotalThreadsInvoluntaryContextSwitches: 22 (22)
- TotalThreadsTotalWallClockTime: 19s185ms
- TotalThreadsSysTime: 384.000ms
- TotalThreadsUserTime: 18s776ms
- TotalThreadsVoluntaryContextSwitches: 31 (31)
Fragment Instance Lifecycle Timings:
- ExecTime: 24.349ms
- ExecTreeExecTime: 20.485ms
- OpenTime: 19s141ms
- ExecTreeOpenTime: 36.301us
- PrepareTime: 63.001ms
- ExecTreePrepareTime: 13.223ms
DataStreamSender (dst_id=2):(Total: 153.796us, non-child: 153.796us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 790.65 KB/sec
- OverallThroughput: 190.49 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 79.314us
- TransmitDataRPCTime: 37.054us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s172ms, non-child: 19s172ms, % non-child: 100.00%)
- CodegenTime: 2.892ms
- CompileTime: 3s746ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s393ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 31.574ms
AGGREGATION_NODE (id=1):(Total: 33.741ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 88.154us
- GetResultsTime: 883.000ns
- HTResizeTime: 208.512us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 29.00 /sec
- StreamingTime: 354.913us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 45.810ms, non-child: 45.810ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.89 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 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%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.08 MB (3234436)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.08 MB (3234436)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.08 MB (3234436)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.31 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 19.519ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 43.66 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 19.689ms
- MaterializeTupleTime(*): 19.618us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 8 (8)
- TotalRawHdfsReadTime(*): 1.304ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:6 (host=cdh12.net.cuberonlabs.com:22000):(Total: 19s221ms, non-child: 23.028ms, % non-child: 0.12%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.90 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 1.167ms
- TotalStorageWaitTime: 8.710ms
- TotalThreadsInvoluntaryContextSwitches: 21 (21)
- TotalThreadsTotalWallClockTime: 19s176ms
- TotalThreadsSysTime: 308.000ms
- TotalThreadsUserTime: 18s844ms
- TotalThreadsVoluntaryContextSwitches: 30 (30)
Fragment Instance Lifecycle Timings:
- ExecTime: 25.122ms
- ExecTreeExecTime: 20.716ms
- OpenTime: 19s131ms
- ExecTreeOpenTime: 33.379us
- PrepareTime: 64.623ms
- ExecTreePrepareTime: 13.531ms
DataStreamSender (dst_id=2):(Total: 888.385us, non-child: 888.385us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 35.82 KB/sec
- OverallThroughput: 32.98 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 33.515us
- TransmitDataRPCTime: 817.817us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s163ms, non-child: 19s163ms, % non-child: 100.00%)
- CodegenTime: 2.876ms
- CompileTime: 3s726ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s404ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 31.936ms
AGGREGATION_NODE (id=1):(Total: 34.276ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 99.123us
- GetResultsTime: 855.000ns
- HTResizeTime: 200.657us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 29.00 /sec
- StreamingTime: 387.863us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 46.494ms, non-child: 46.494ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.90 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 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%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.10 MB (3247345)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.10 MB (3247345)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.10 MB (3247345)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.48 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 19.553ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 43.02 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 19.721ms
- MaterializeTupleTime(*): 19.760us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 6 (6)
- TotalRawHdfsReadTime(*): 1.220ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:4 (host=cdh15.net.cuberonlabs.com:22000):(Total: 19s158ms, non-child: 22.368ms, % non-child: 0.12%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.91 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 348.559us
- TotalStorageWaitTime: 9.375ms
- TotalThreadsInvoluntaryContextSwitches: 26 (26)
- TotalThreadsTotalWallClockTime: 19s115ms
- TotalThreadsSysTime: 332.000ms
- TotalThreadsUserTime: 18s756ms
- TotalThreadsVoluntaryContextSwitches: 31 (31)
Fragment Instance Lifecycle Timings:
- ExecTime: 24.905ms
- ExecTreeExecTime: 21.538ms
- OpenTime: 19s070ms
- ExecTreeOpenTime: 36.743us
- PrepareTime: 63.497ms
- ExecTreePrepareTime: 13.082ms
DataStreamSender (dst_id=2):(Total: 117.487us, non-child: 117.487us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 921.72 KB/sec
- OverallThroughput: 249.36 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 48.213us
- TransmitDataRPCTime: 31.785us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s101ms, non-child: 19s101ms, % non-child: 100.00%)
- CodegenTime: 2.849ms
- CompileTime: 3s775ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s293ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 31.659ms
AGGREGATION_NODE (id=1):(Total: 34.651ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 101.642us
- GetResultsTime: 1.700us
- HTResizeTime: 210.670us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 28.00 /sec
- StreamingTime: 459.836us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 46.167ms, non-child: 46.167ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.91 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.11 MB (3259525)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.11 MB (3259525)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.11 MB (3259525)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.04 MB (8426496)
- PerReadThreadRawHdfsThroughput: 2.32 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 20.124ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 43.32 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 20.289ms
- MaterializeTupleTime(*): 11.538us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 8 (8)
- TotalRawHdfsReadTime(*): 1.306ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:5 (host=cdh5.net.cuberonlabs.com:22000):(Total: 19s099ms, non-child: 21.912ms, % non-child: 0.11%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.89 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 366.356us
- TotalStorageWaitTime: 9.158ms
- TotalThreadsInvoluntaryContextSwitches: 23 (23)
- TotalThreadsTotalWallClockTime: 19s053ms
- TotalThreadsSysTime: 336.000ms
- TotalThreadsUserTime: 18s688ms
- TotalThreadsVoluntaryContextSwitches: 34 (34)
Fragment Instance Lifecycle Timings:
- ExecTime: 24.782ms
- ExecTreeExecTime: 20.977ms
- OpenTime: 19s008ms
- ExecTreeOpenTime: 34.864us
- PrepareTime: 66.169ms
- ExecTreePrepareTime: 12.837ms
DataStreamSender (dst_id=2):(Total: 107.588us, non-child: 107.588us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 837.92 KB/sec
- OverallThroughput: 272.31 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 31.756us
- TransmitDataRPCTime: 34.964us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s043ms, non-child: 19s043ms, % non-child: 100.00%)
- CodegenTime: 2.690ms
- CompileTime: 3s722ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s284ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 35.359ms
AGGREGATION_NODE (id=1):(Total: 33.846ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 91.368us
- GetResultsTime: 768.000ns
- HTResizeTime: 125.548us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 29.00 /sec
- StreamingTime: 359.772us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 45.496ms, non-child: 45.496ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.89 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.09 MB (3243116)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.09 MB (3243116)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.09 MB (3243116)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.30 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 20.051ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 43.96 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 1 (1)
- ScannerThreadsTotalWallClockTime: 20.263ms
- MaterializeTupleTime(*): 19.868us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 7 (7)
- TotalRawHdfsReadTime(*): 1.314ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:d (host=cdh13.net.cuberonlabs.com:22000):(Total: 19s069ms, non-child: 21.739ms, % non-child: 0.11%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.89 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 321.610us
- TotalStorageWaitTime: 9.444ms
- TotalThreadsInvoluntaryContextSwitches: 25 (25)
- TotalThreadsTotalWallClockTime: 19s027ms
- TotalThreadsSysTime: 300.000ms
- TotalThreadsUserTime: 18s700ms
- TotalThreadsVoluntaryContextSwitches: 30 (30)
Fragment Instance Lifecycle Timings:
- ExecTime: 24.844ms
- ExecTreeExecTime: 21.217ms
- OpenTime: 18s982ms
- ExecTreeOpenTime: 36.289us
- PrepareTime: 62.805ms
- ExecTreePrepareTime: 13.295ms
DataStreamSender (dst_id=2):(Total: 129.881us, non-child: 129.881us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 786.05 KB/sec
- OverallThroughput: 225.57 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 55.259us
- TransmitDataRPCTime: 37.271us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 19s013ms, non-child: 19s013ms, % non-child: 100.00%)
- CodegenTime: 2.778ms
- CompileTime: 3s752ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s228ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 31.595ms
AGGREGATION_NODE (id=1):(Total: 34.544ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 96.934us
- GetResultsTime: 854.000ns
- HTResizeTime: 205.213us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 28.00 /sec
- StreamingTime: 388.396us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 46.506ms, non-child: 46.506ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.89 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.09 MB (3243063)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.09 MB (3243063)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.09 MB (3243063)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.30 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 20.096ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 43.00 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 20.248ms
- MaterializeTupleTime(*): 18.891us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 6 (6)
- TotalRawHdfsReadTime(*): 1.312ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:8 (host=cdh17.net.cuberonlabs.com:22000):(Total: 18s961ms, non-child: 22.401ms, % non-child: 0.12%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/3.18 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.78 MB (10252142)
- PerHostPeakMemUsage: 12.06 MB (12650868)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 275.073us
- TotalStorageWaitTime: 16.832ms
- TotalThreadsInvoluntaryContextSwitches: 22 (22)
- TotalThreadsTotalWallClockTime: 18s937ms
- TotalThreadsSysTime: 376.000ms
- TotalThreadsUserTime: 18s524ms
- TotalThreadsVoluntaryContextSwitches: 50 (50)
Fragment Instance Lifecycle Timings:
- ExecTime: 25.641ms
- ExecTreeExecTime: 22.325ms
- OpenTime: 18s871ms
- ExecTreeOpenTime: 36.177us
- PrepareTime: 64.282ms
- ExecTreePrepareTime: 13.715ms
DataStreamSender (dst_id=2):(Total: 114.803us, non-child: 114.803us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 743.52 KB/sec
- OverallThroughput: 255.19 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 39.583us
- TransmitDataRPCTime: 39.403us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 18s903ms, non-child: 18s903ms, % non-child: 100.00%)
- CodegenTime: 2.809ms
- CompileTime: 3s747ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s123ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 31.770ms
AGGREGATION_NODE (id=1):(Total: 36.072ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 93.520us
- GetResultsTime: 788.000ns
- HTResizeTime: 313.799us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 16311.00
- ReductionFactorThresholdToExpand: 1.10
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 27.00 /sec
- StreamingTime: 507.374us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 48.354ms, non-child: 48.354ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/3.18 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 2
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:2
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.58 MB (3749147)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.58 MB (3749147)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.58 MB (3749147)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 2 (2)
- PeakMemoryUsage: 8.07 MB (8460288)
- PerReadThreadRawHdfsThroughput: 2.43 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 21.005ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.14K (2142)
- RowsReturned: 2.14K (2142)
- RowsReturnedRate: 44.30 K/sec
- ScanRangesComplete: 2 (2)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 39.986ms
- MaterializeTupleTime(*): 14.951us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 16.000ms
- ScannerThreadsVoluntaryContextSwitches: 23 (23)
- TotalRawHdfsReadTime(*): 1.438ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:c (host=cdh10.net.cuberonlabs.com:22000):(Total: 18s952ms, non-child: 24.318ms, % non-child: 0.13%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.90 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 9.77 MB (10243950)
- PerHostPeakMemUsage: 12.06 MB (12642676)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 384.216us
- TotalStorageWaitTime: 9.121ms
- TotalThreadsInvoluntaryContextSwitches: 32 (32)
- TotalThreadsTotalWallClockTime: 18s907ms
- TotalThreadsSysTime: 364.000ms
- TotalThreadsUserTime: 18s520ms
- TotalThreadsVoluntaryContextSwitches: 32 (32)
Fragment Instance Lifecycle Timings:
- ExecTime: 24.002ms
- ExecTreeExecTime: 20.355ms
- OpenTime: 18s864ms
- ExecTreeOpenTime: 35.169us
- PrepareTime: 64.290ms
- ExecTreePrepareTime: 13.234ms
DataStreamSender (dst_id=2):(Total: 149.988us, non-child: 149.988us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 882.78 KB/sec
- OverallThroughput: 195.33 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 74.987us
- TransmitDataRPCTime: 33.187us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 18s894ms, non-child: 18s894ms, % non-child: 100.00%)
- CodegenTime: 2.842ms
- CompileTime: 3s735ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s127ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 30.595ms
AGGREGATION_NODE (id=1):(Total: 33.621ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 105.805us
- GetResultsTime: 782.000ns
- HTResizeTime: 216.951us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 5.55 MB (5814400)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 29.00 /sec
- StreamingTime: 400.246us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 45.619ms, non-child: 45.619ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/2.90 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 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%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 3.10 MB (3253248)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 3.10 MB (3253248)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 3.10 MB (3253248)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 8.06 MB (8452096)
- PerReadThreadRawHdfsThroughput: 2.56 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 19.231ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 2.00K (2000)
- RowsReturned: 2.00K (2000)
- RowsReturnedRate: 43.84 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 1 (1)
- ScannerThreadsTotalWallClockTime: 19.362ms
- MaterializeTupleTime(*): 19.412us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 8 (8)
- TotalRawHdfsReadTime(*): 1.185ms
- TotalReadThroughput: 0.00 /sec
Instance bb4740d9a995d36b:e (host=cdh16.net.cuberonlabs.com:22000):(Total: 18s846ms, non-child: 24.530ms, % non-child: 0.13%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/6.83 MB
MemoryUsage(500.000ms): 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 5.62 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB, 1.38 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 17.77 MB (18632558)
- PerHostPeakMemUsage: 20.06 MB (21031284)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 314.759us
- TotalStorageWaitTime: 11.804ms
- TotalThreadsInvoluntaryContextSwitches: 22 (22)
- TotalThreadsTotalWallClockTime: 18s803ms
- TotalThreadsSysTime: 344.000ms
- TotalThreadsUserTime: 18s424ms
- TotalThreadsVoluntaryContextSwitches: 40 (40)
Fragment Instance Lifecycle Timings:
- ExecTime: 28.390ms
- ExecTreeExecTime: 24.195ms
- OpenTime: 18s751ms
- ExecTreeOpenTime: 35.508us
- PrepareTime: 66.690ms
- ExecTreePrepareTime: 13.628ms
DataStreamSender (dst_id=2):(Total: 168.147us, non-child: 168.147us, % non-child: 100.00%)
- BytesSent: 30.00 B (30)
- NetworkThroughput(*): 855.93 KB/sec
- OverallThroughput: 174.23 KB/sec
- PeakMemoryUsage: 109.33 KB (111952)
- RowsReturned: 1 (1)
- SerializeBatchTime: 95.555us
- TransmitDataRPCTime: 34.228us
- UncompressedRowBatchSize: 35.00 B (35)
CodeGen:(Total: 18s784ms, non-child: 18s784ms, % non-child: 100.00%)
- CodegenTime: 3.092ms
- CompileTime: 3s748ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 63 (63)
- NumInstructions: 8.68K (8681)
- OptimizationTime: 15s001ms
- PeakMemoryUsage: 4.24 MB (4444672)
- PrepareTime: 33.071ms
AGGREGATION_NODE (id=1):(Total: 37.853ms, non-child: 0.000ns, % non-child: 0.00%)
ExecOption: Streaming Preaggregation, Codegen Enabled
- GetNewBlockTime: 101.278us
- GetResultsTime: 934.000ns
- HTResizeTime: 246.276us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 9.55 MB (10008704)
- PinTime: 0.000ns
- ReductionFactorEstimate: 0.00
- ReductionFactorThresholdToExpand: 0.00
- RowsPassedThrough: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 26.00 /sec
- StreamingTime: 458.617us
- UnpinTime: 0.000ns
HDFS_SCAN_NODE (id=0):(Total: 50.092ms, non-child: 50.092ms, % non-child: 100.00%)
Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/6.83 MB
ExecOption: AVRO Codegen Enabled, Codegen enabled: 1 out of 1
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0%
File Formats: AVRO/NONE:1
BytesRead(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 7.02 MB (7365469)
- BytesReadDataNodeCache: 0
- BytesReadLocal: 7.02 MB (7365469)
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 7.02 MB (7365469)
- BytesSkipped: 0
- DecompressionTime: 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 2 (2)
- NumScannerThreadsStarted: 1 (1)
- PeakMemoryUsage: 16.11 MB (16891904)
- PerReadThreadRawHdfsThroughput: 2.29 GB/sec
- RemoteScanRanges: 0 (0)
- RowBatchQueueGetWaitTime: 22.874ms
- RowBatchQueuePutWaitTime: 0.000ns
- RowsRead: 5.00K (5000)
- RowsReturned: 5.00K (5000)
- RowsReturnedRate: 99.81 K/sec
- ScanRangesComplete: 1 (1)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 23.097ms
- MaterializeTupleTime(*): 45.075us
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 8.000ms
- ScannerThreadsVoluntaryContextSwitches: 6 (6)
- TotalRawHdfsReadTime(*): 3.001ms
- TotalReadThroughput: 0.00 /sec
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment