Query Details select a.asset_class_d_key, count(1) from edwpoc.asset_class_dim a inner join edwpoc.ts_gs_rtd_view_fact_stage t on a.asset_class_d_key = t.asset_class_d_key group by a.asset_class_d_key Query Plan ---------------- Estimated Per-Host Requirements: Memory=1.67GB VCores=2 F04:PLAN FRAGMENT [PARTITION=UNPARTITIONED] 08:EXCHANGE [PARTITION=UNPARTITIONED] hosts=15 per-host-mem=unavailable tuple-ids=2 row-size=16B cardinality=92910016 F03:PLAN FRAGMENT [PARTITION=HASH(a.asset_class_d_key)] DATASTREAM SINK [FRAGMENT=F04, EXCHANGE=08, PARTITION=UNPARTITIONED] 07:AGGREGATE [MERGE FINALIZE] | output: sum(count(1)) | group by: a.asset_class_d_key | hosts=15 per-host-mem=103.96MB | tuple-ids=2 row-size=16B cardinality=92910016 | 06:EXCHANGE [PARTITION=HASH(a.asset_class_d_key)] hosts=15 per-host-mem=0B tuple-ids=2 row-size=16B cardinality=92910016 F02:PLAN FRAGMENT [PARTITION=HASH(t.asset_class_d_key)] DATASTREAM SINK [FRAGMENT=F03, EXCHANGE=06, PARTITION=HASH(a.asset_class_d_key)] 03:AGGREGATE | output: count(1) | group by: a.asset_class_d_key | hosts=15 per-host-mem=1.52GB | tuple-ids=2 row-size=16B cardinality=92910016 | 02:HASH JOIN [INNER JOIN, PARTITIONED] | hash predicates: t.asset_class_d_key = a.asset_class_d_key | hosts=15 per-host-mem=63.96MB | tuple-ids=1,0 row-size=16B cardinality=219326259 | |--05:EXCHANGE [PARTITION=HASH(a.asset_class_d_key)] | hosts=15 per-host-mem=0B | tuple-ids=0 row-size=8B cardinality=114316426 | 04:EXCHANGE [PARTITION=HASH(t.asset_class_d_key)] hosts=15 per-host-mem=0B tuple-ids=1 row-size=8B cardinality=178256152 F01:PLAN FRAGMENT [PARTITION=RANDOM] DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=05, PARTITION=HASH(a.asset_class_d_key)] 00:SCAN HDFS [edwpoc.asset_class_dim a, PARTITION=RANDOM] partitions=1/1 size=1.69GB table stats: 114316426 rows total column stats: all hosts=15 per-host-mem=88.00MB tuple-ids=0 row-size=8B cardinality=114316426 F00:PLAN FRAGMENT [PARTITION=RANDOM] DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=04, PARTITION=HASH(t.asset_class_d_key)] 01:SCAN HDFS [edwpoc.ts_gs_rtd_view_fact_stage t, PARTITION=RANDOM] partitions=1/1 size=5.96GB table stats: 178256152 rows total column stats: all hosts=15 per-host-mem=88.00MB tuple-ids=1 row-size=8B cardinality=178256152 ---------------- Query Info Query ID: 164289919d267302:7a6ada21faebeeb3 User: steveo Database: default Coordinator: lab1ai-18.int.abc.com Query Type: QUERY Query State: FINISHED Start Time: Sep 25, 2014 9:00:12 AM End Time: Sep 25, 2014 9:01:05 AM Duration: 53.1s Rows Produced: 1,921,292 Aggregate Peak Memory Usage: 401.9 MiB Bytes Streamed: 2.6 GiB Client Fetch Wait Time: 40.63s Client Fetch Wait Time Percentage: 76 Estimated per Node Peak Memory: 1.7 GiB The planning process's estimate of per-node peak memory usage for the query. Called "estimated_per_node_peak_memory" in searches. File Formats: PARQUET/SNAPPY An alphabetically sorted list of all the file formats used in the query. Called "file_formats" in searches. HDFS Average Scan Range: 18.6 MiB HDFS Bytes Read: 1.2 GiB HDFS Bytes Read From Cache: 1.2 GiB HDFS Bytes Read From Cache Percentage: 100 HDFS Local Bytes Read: 1.2 GiB HDFS Local Bytes Read Percentage: 100 HDFS Read Throughput: 1.3 GiB/s HDFS Remote Bytes Read: 0 B HDFS Remote Bytes Read Percentage: 0 HDFS Short Circuit Bytes Read: 1.2 GiB HDFS Short Circuit Bytes Read Percentage: 100 Memory Accrual: 3,498,894,066 byte seconds Network Address: 10.209.46.15:49894 Node with Peak Memory Usage: lab1ai-06.int.abc.com:22000 Per Node Peak Memory Usage: 401.9 MiB Planning Wait Time: 14ms Planning Wait Time Percentage: 0 Pool: root.steveo Query Status: OK Session ID: c2462320619e02d1:5020a206b1de4cbb Session Type: BEESWAX Stats Missing: false Threads: CPU Time: 11.9m Threads: CPU Time Percentage: 51 Threads: Network Receive Wait Time: 4.3m Threads: Network Receive Wait Time Percentage: 18 Threads: Network Send Wait Time: 7.3m Threads: Network Send Wait Time Percentage: 31 Threads: Storage Wait Time: 1.10s Threads: Storage Wait Time Percentage: 0 Threads: Total Time: 23.5m Download Profile... Download Text Profile... Download Thrift Encoded Profile... Query Timeline Start execution: 3ms (3ms) Planning finished: 17ms (14ms) Submit for admission: 22ms (4ms) Completed admission: 22ms (55.64us) Rows available: 10.77s (10.75s) First row fetched: 11.12s (348ms) Unregister query: 53.13s (42.01s) Query Fragments Coordinator Fragment Fragment 1 (34.59s) Fragment 2 (10.42s) Fragment 3 (3.40s) Fragment 4 (10.11s) AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 24.8 MiB PrepareTime: 26.80us RowsProduced: 1,921,292 TotalCpuTime: 42.82s TotalNetworkReceiveTime: 10.27s TotalNetworkSendTime: 0ns TotalStorageWaitTime: 0ns TotalTime: 10.34s CodeGen (71ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 64ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 71ms EXCHANGE_NODE (id=8) (10.33s) AsyncTotalTime: 0ns BytesReceived: 23.7 MiB ConvertRowBatchTime: 50ms DataArrivalWaitTime: 10.26s DeserializeRowBatchTimer: 163ms FirstBatchArrivalWaitTime: 10.26s PeakMemoryUsage: 24.8 MiB RowsReturned: 1,921,292 RowsReturnedRate: 185969 per second SendersBlockedTimer: 23.91s SendersBlockedTotalTimer(*): 5.2m TotalTime: 10.33s Averaged Fragment 1 split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:27s942ms max:34s603ms mean: 31s573ms stddev:1s550ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 15 AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,086 TotalCpuTime: 142ms TotalNetworkReceiveTime: 10.56s TotalNetworkSendTime: 20.97s TotalStorageWaitTime: 0ns TotalTime: 31.54s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (20.95s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 77.5 KiB/s OverallThroughput: 77.6 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 20.98s TotalTime: 20.95s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 20ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,086 RowsReturnedRate: 12096 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 7ms FirstBatchArrivalWaitTime: 10.44s PeakMemoryUsage: 234.4 KiB RowsReturned: 128,086 RowsReturnedRate: 12131 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-14.int.abc.com (34.59s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 127,926 TotalCpuTime: 142ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 24.00s TotalStorageWaitTime: 0ns TotalTime: 34.59s CodeGen (90ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 90ms DataStreamSender (dst_id=8) (24.01s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 67.2 KiB/s OverallThroughput: 67.2 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 24.01s TotalTime: 24.01s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.58s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 19ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,926 RowsReturnedRate: 12084 per second TotalTime: 10.58s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 9ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 191.8 KiB RowsReturned: 127,926 RowsReturnedRate: 12118 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-06.int.abc.com (33.52s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.4 MiB PrepareTime: 1ms RowsProduced: 127,719 TotalCpuTime: 141ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 22.95s TotalStorageWaitTime: 0ns TotalTime: 33.52s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (22.94s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 70.2 KiB/s OverallThroughput: 70.3 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 15ms ThriftTransmitTime(*): 22.96s TotalTime: 22.94s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 20ms GetResultsTime: 7ms LoadFactor: 0.62 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,719 RowsReturnedRate: 12063 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 6ms FirstBatchArrivalWaitTime: 10.53s PeakMemoryUsage: 277.1 KiB RowsReturned: 127,719 RowsReturnedRate: 12098 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-08.int.abc.com (32.82s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,190 TotalCpuTime: 145ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 22.22s TotalStorageWaitTime: 0ns TotalTime: 32.82s CodeGen (90ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 90ms DataStreamSender (dst_id=8) (22.23s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 72.8 KiB/s OverallThroughput: 72.7 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 22.23s TotalTime: 22.23s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.58s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 22ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,190 RowsReturnedRate: 12110 per second TotalTime: 10.58s EXCHANGE_NODE (id=6) (10.55s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 6ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 213.1 KiB RowsReturned: 128,190 RowsReturnedRate: 12147 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.55s lab1ai-13.int.abc.com (32.72s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 127,996 TotalCpuTime: 143ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 22.16s TotalStorageWaitTime: 0ns TotalTime: 32.72s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (22.14s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 72.9 KiB/s OverallThroughput: 73.0 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 22.17s TotalTime: 22.14s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 21ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,996 RowsReturnedRate: 12089 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 5ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 255.8 KiB RowsReturned: 127,996 RowsReturnedRate: 12125 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-05.int.abc.com (32.60s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 127,588 TotalCpuTime: 143ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 22.04s TotalStorageWaitTime: 0ns TotalTime: 32.60s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (22.02s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 73.0 KiB/s OverallThroughput: 73.1 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 22.05s TotalTime: 22.02s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 21ms GetResultsTime: 7ms LoadFactor: 0.62 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,588 RowsReturnedRate: 12050 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 8ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 234.4 KiB RowsReturned: 127,588 RowsReturnedRate: 12086 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-10.int.abc.com (32.54s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,551 TotalCpuTime: 143ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 21.94s TotalStorageWaitTime: 0ns TotalTime: 32.54s CodeGen (90ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 90ms DataStreamSender (dst_id=8) (21.95s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 73.9 KiB/s OverallThroughput: 73.9 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 21.95s TotalTime: 21.95s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 21ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,551 RowsReturnedRate: 12142 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 7ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 234.4 KiB RowsReturned: 128,551 RowsReturnedRate: 12177 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-04.int.abc.com (31.06s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,048 TotalCpuTime: 141ms TotalNetworkReceiveTime: 10.56s TotalNetworkSendTime: 20.45s TotalStorageWaitTime: 0ns TotalTime: 31.06s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 82ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (20.47s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 79.0 KiB/s OverallThroughput: 79.0 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 20.46s TotalTime: 20.47s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 20ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,048 RowsReturnedRate: 12086 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.56s DeserializeRowBatchTimer: 8ms FirstBatchArrivalWaitTime: 10.44s PeakMemoryUsage: 213.1 KiB RowsReturned: 128,048 RowsReturnedRate: 12120 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-17.int.abc.com (30.96s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,766 TotalCpuTime: 138ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 20.46s TotalStorageWaitTime: 0ns TotalTime: 30.96s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (20.38s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 79.4 KiB/s OverallThroughput: 79.8 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 20.47s TotalTime: 20.38s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.58s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 17ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,766 RowsReturnedRate: 12166 per second TotalTime: 10.58s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 5ms FirstBatchArrivalWaitTime: 10.42s PeakMemoryUsage: 255.8 KiB RowsReturned: 128,766 RowsReturnedRate: 12197 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-16.int.abc.com (30.94s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 127,883 TotalCpuTime: 143ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 20.43s TotalStorageWaitTime: 0ns TotalTime: 30.94s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (20.35s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 79.0 KiB/s OverallThroughput: 79.3 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 20.44s TotalTime: 20.35s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 21ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,883 RowsReturnedRate: 12077 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 8ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 255.8 KiB RowsReturned: 127,883 RowsReturnedRate: 12113 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-07.int.abc.com (30.93s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.4 MiB PrepareTime: 1ms RowsProduced: 128,488 TotalCpuTime: 146ms TotalNetworkReceiveTime: 10.56s TotalNetworkSendTime: 20.42s TotalStorageWaitTime: 0ns TotalTime: 30.93s CodeGen (90ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 90ms DataStreamSender (dst_id=8) (20.34s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 79.4 KiB/s OverallThroughput: 79.7 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 20.43s TotalTime: 20.34s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 23ms GetResultsTime: 8ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,488 RowsReturnedRate: 12127 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.56s DeserializeRowBatchTimer: 5ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 298.4 KiB RowsReturned: 128,488 RowsReturnedRate: 12167 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-18.int.abc.com (30.87s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 127,262 TotalCpuTime: 136ms TotalNetworkReceiveTime: 10.56s TotalNetworkSendTime: 20.27s TotalStorageWaitTime: 0ns TotalTime: 30.87s CodeGen (90ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 90ms DataStreamSender (dst_id=8) (20.28s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 79.2 KiB/s OverallThroughput: 79.2 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 15ms ThriftTransmitTime(*): 20.28s TotalTime: 20.28s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 17ms GetResultsTime: 6ms LoadFactor: 0.62 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,262 RowsReturnedRate: 12013 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.57s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 1ms DataArrivalWaitTime: 10.56s DeserializeRowBatchTimer: 6ms FirstBatchArrivalWaitTime: 10.44s PeakMemoryUsage: 191.8 KiB RowsReturned: 127,262 RowsReturnedRate: 12043 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.57s lab1ai-15.int.abc.com (30.58s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,116 TotalCpuTime: 141ms TotalNetworkReceiveTime: 10.56s TotalNetworkSendTime: 19.97s TotalStorageWaitTime: 0ns TotalTime: 30.58s CodeGen (90ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 90ms DataStreamSender (dst_id=8) (19.99s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 81.0 KiB/s OverallThroughput: 81.0 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 19.98s TotalTime: 19.99s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 18ms GetResultsTime: 8ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,116 RowsReturnedRate: 12100 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 1ms DataArrivalWaitTime: 10.56s DeserializeRowBatchTimer: 6ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 191.8 KiB RowsReturned: 128,116 RowsReturnedRate: 12133 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-12.int.abc.com (30.51s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,644 TotalCpuTime: 139ms TotalNetworkReceiveTime: 10.56s TotalNetworkSendTime: 20.04s TotalStorageWaitTime: 0ns TotalTime: 30.51s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 82ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (19.92s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 81.0 KiB/s OverallThroughput: 81.5 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 20.05s TotalTime: 19.92s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 18ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,644 RowsReturnedRate: 12151 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 1ms DataArrivalWaitTime: 10.56s DeserializeRowBatchTimer: 6ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 255.8 KiB RowsReturned: 128,644 RowsReturnedRate: 12183 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-09.int.abc.com (30.45s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,016 TotalCpuTime: 143ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 19.84s TotalStorageWaitTime: 0ns TotalTime: 30.45s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 82ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=8) (19.86s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 81.4 KiB/s OverallThroughput: 81.4 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 19.86s TotalTime: 19.86s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.59s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 21ms GetResultsTime: 7ms LoadFactor: 0.62 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,016 RowsReturnedRate: 12090 per second TotalTime: 10.59s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 3ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 8ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 255.8 KiB RowsReturned: 128,016 RowsReturnedRate: 12126 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s lab1ai-11.int.abc.com (27.94s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.00 PeakMemoryUsage: 8.3 MiB PrepareTime: 1ms RowsProduced: 128,099 TotalCpuTime: 139ms TotalNetworkReceiveTime: 10.55s TotalNetworkSendTime: 17.34s TotalStorageWaitTime: 0ns TotalTime: 27.94s CodeGen (90ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 83ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 90ms DataStreamSender (dst_id=8) (17.36s) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 93.2 KiB/s OverallThroughput: 93.2 KiB/s PeakMemoryUsage: 5.3 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 17.35s TotalTime: 17.36s UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=7) (10.58s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 18ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,099 RowsReturnedRate: 12101 per second TotalTime: 10.58s EXCHANGE_NODE (id=6) (10.56s) AsyncTotalTime: 0ns BytesReceived: 1.6 MiB ConvertRowBatchTime: 2ms DataArrivalWaitTime: 10.55s DeserializeRowBatchTimer: 8ms FirstBatchArrivalWaitTime: 10.43s PeakMemoryUsage: 191.8 KiB RowsReturned: 128,099 RowsReturnedRate: 12133 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 10.56s Collapse All Averaged Fragment 1 lab1ai-14.int.abc.com lab1ai-06.int.abc.com lab1ai-08.int.abc.com lab1ai-13.int.abc.com lab1ai-05.int.abc.com lab1ai-10.int.abc.com lab1ai-04.int.abc.com lab1ai-17.int.abc.com lab1ai-16.int.abc.com lab1ai-07.int.abc.com lab1ai-18.int.abc.com lab1ai-15.int.abc.com lab1ai-12.int.abc.com lab1ai-09.int.abc.com lab1ai-11.int.abc.com Averaged Fragment 2 split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:10s329ms max:10s429ms mean: 10s387ms stddev:18.583ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 15 AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 366.5 MiB PrepareTime: 4ms RowsProduced: 128,086 TotalCpuTime: 7.98s TotalNetworkReceiveTime: 6.02s TotalNetworkSendTime: 14ms TotalStorageWaitTime: 0ns TotalTime: 10.34s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 132ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (48ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 49.9 MiB/s OverallThroughput: 33.5 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 32ms TotalTime: 48ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 982ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,086 RowsReturnedRate: 12442 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.28s) AsyncTotalTime: 0ns BuildBuckets: 8,388,608 BuildRows: 7,621,094 BuildTime: 1.71s LeftChildRows: 11,883,743 LeftChildTime: 1.36s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 11,883,743 RowsReturnedRate: 1308755 per second TotalTime: 9.28s EXCHANGE_NODE (id=5) (1.76s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 111ms DataArrivalWaitTime: 1.52s DeserializeRowBatchTimer: 404ms FirstBatchArrivalWaitTime: 91ms PeakMemoryUsage: 22.9 MiB RowsReturned: 7,621,095 RowsReturnedRate: 4391792 per second SendersBlockedTimer: 225ms SendersBlockedTotalTimer(*): 1.46s TotalTime: 1.76s EXCHANGE_NODE (id=4) (4.59s) AsyncTotalTime: 0ns BytesReceived: 98.2 MiB ConvertRowBatchTime: 191ms DataArrivalWaitTime: 4.25s DeserializeRowBatchTimer: 518ms FirstBatchArrivalWaitTime: 165ms PeakMemoryUsage: 8.1 MiB RowsReturned: 11,883,743 RowsReturnedRate: 3339841 per second SendersBlockedTimer: 598ms SendersBlockedTotalTimer(*): 7.28s TotalTime: 4.59s lab1ai-06.int.abc.com (10.42s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 401.9 MiB PrepareTime: 4ms RowsProduced: 127,719 TotalCpuTime: 11.09s TotalNetworkReceiveTime: 2.96s TotalNetworkSendTime: 11ms TotalStorageWaitTime: 0ns TotalTime: 10.42s CodeGen (138ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 132ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 138ms DataStreamSender (dst_id=6) (41ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 52.6 MiB/s OverallThroughput: 38.3 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 13ms ThriftTransmitTime(*): 30ms TotalTime: 41ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.38s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 1.72s GetResultsTime: 7ms LoadFactor: 0.62 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,719 RowsReturnedRate: 12298 per second TotalTime: 10.38s HASH_JOIN_NODE (id=2) (8.61s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,614,125 BuildTime: 1.78s LeftChildRows: 59,197,302 LeftChildTime: 2.85s LoadFactor: 0.61 PeakMemoryUsage: 355.6 MiB RowsReturned: 59,197,302 RowsReturnedRate: 6874405 per second TotalTime: 8.61s EXCHANGE_NODE (id=5) (1.70s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 105ms DataArrivalWaitTime: 1.48s DeserializeRowBatchTimer: 384ms FirstBatchArrivalWaitTime: 92ms PeakMemoryUsage: 22.8 MiB RowsReturned: 7,614,127 RowsReturnedRate: 4472566 per second SendersBlockedTimer: 11ms SendersBlockedTotalTimer(*): 96ms TotalTime: 1.70s EXCHANGE_NODE (id=4) (2.37s) AsyncTotalTime: 0ns BytesReceived: 354.9 MiB ConvertRowBatchTime: 912ms DataArrivalWaitTime: 161ms DeserializeRowBatchTimer: 2.54s FirstBatchArrivalWaitTime: 161ms PeakMemoryUsage: 40.6 MiB RowsReturned: 59,197,302 RowsReturnedRate: 24988946 per second SendersBlockedTimer: 8.98s SendersBlockedTotalTimer(*): 1.8m TotalTime: 2.37s lab1ai-14.int.abc.com (10.34s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.4 MiB PrepareTime: 4ms RowsProduced: 127,926 TotalCpuTime: 8.18s TotalNetworkReceiveTime: 5.82s TotalNetworkSendTime: 23ms TotalStorageWaitTime: 0ns TotalTime: 10.34s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 133ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (59ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 42.3 MiB/s OverallThroughput: 26.7 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 19ms ThriftTransmitTime(*): 37ms TotalTime: 59ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 957ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,926 RowsReturnedRate: 12434 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.31s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,620,457 BuildTime: 2.04s LeftChildRows: 8,673,012 LeftChildTime: 1.31s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 8,673,012 RowsReturnedRate: 931921 per second TotalTime: 9.31s EXCHANGE_NODE (id=5) (1.44s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 113ms DataArrivalWaitTime: 1.19s DeserializeRowBatchTimer: 407ms FirstBatchArrivalWaitTime: 90ms PeakMemoryUsage: 23.0 MiB RowsReturned: 7,620,457 RowsReturnedRate: 5304682 per second SendersBlockedTimer: 615ms SendersBlockedTotalTimer(*): 3.69s TotalTime: 1.44s EXCHANGE_NODE (id=4) (4.66s) AsyncTotalTime: 0ns BytesReceived: 81.4 MiB ConvertRowBatchTime: 138ms DataArrivalWaitTime: 4.46s DeserializeRowBatchTimer: 383ms FirstBatchArrivalWaitTime: 164ms PeakMemoryUsage: 5.9 MiB RowsReturned: 8,673,012 RowsReturnedRate: 1861375 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.66s lab1ai-15.int.abc.com (10.34s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 363.9 MiB PrepareTime: 4ms RowsProduced: 128,116 TotalCpuTime: 7.53s TotalNetworkReceiveTime: 6.47s TotalNetworkSendTime: 20ms TotalStorageWaitTime: 0ns TotalTime: 10.34s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 133ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (57ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 45.1 MiB/s OverallThroughput: 27.7 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 20ms ThriftTransmitTime(*): 35ms TotalTime: 57ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 951ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,116 RowsReturnedRate: 12453 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.31s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,616,077 BuildTime: 1.49s LeftChildRows: 7,827,173 LeftChildTime: 1.24s LoadFactor: 0.61 PeakMemoryUsage: 355.6 MiB RowsReturned: 7,827,173 RowsReturnedRate: 840447 per second TotalTime: 9.31s EXCHANGE_NODE (id=5) (1.99s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 108ms DataArrivalWaitTime: 1.73s DeserializeRowBatchTimer: 431ms FirstBatchArrivalWaitTime: 91ms PeakMemoryUsage: 22.8 MiB RowsReturned: 7,616,077 RowsReturnedRate: 3829888 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 1.99s EXCHANGE_NODE (id=4) (4.74s) AsyncTotalTime: 0ns BytesReceived: 74.2 MiB ConvertRowBatchTime: 124ms DataArrivalWaitTime: 4.56s DeserializeRowBatchTimer: 356ms FirstBatchArrivalWaitTime: 166ms PeakMemoryUsage: 5.3 MiB RowsReturned: 7,827,173 RowsReturnedRate: 1652289 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.74s lab1ai-09.int.abc.com (10.34s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.32 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 128,016 TotalCpuTime: 7.60s TotalNetworkReceiveTime: 6.40s TotalNetworkSendTime: 20ms TotalStorageWaitTime: 0ns TotalTime: 10.34s CodeGen (137ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 131ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 137ms DataStreamSender (dst_id=6) (54ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 45.1 MiB/s OverallThroughput: 29.4 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 17ms ThriftTransmitTime(*): 35ms TotalTime: 54ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 924ms GetResultsTime: 6ms LoadFactor: 0.62 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,016 RowsReturnedRate: 12441 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.34s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,624,720 BuildTime: 1.56s LeftChildRows: 8,205,162 LeftChildTime: 1.24s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 8,205,162 RowsReturnedRate: 878220 per second TotalTime: 9.34s EXCHANGE_NODE (id=5) (1.92s) AsyncTotalTime: 0ns BytesReceived: 78.3 MiB ConvertRowBatchTime: 112ms DataArrivalWaitTime: 1.68s DeserializeRowBatchTimer: 386ms FirstBatchArrivalWaitTime: 92ms PeakMemoryUsage: 22.9 MiB RowsReturned: 7,624,720 RowsReturnedRate: 3979572 per second SendersBlockedTimer: 156ms SendersBlockedTotalTimer(*): 772ms TotalTime: 1.92s EXCHANGE_NODE (id=4) (4.76s) AsyncTotalTime: 0ns BytesReceived: 78.3 MiB ConvertRowBatchTime: 139ms DataArrivalWaitTime: 4.56s DeserializeRowBatchTimer: 340ms FirstBatchArrivalWaitTime: 167ms PeakMemoryUsage: 5.6 MiB RowsReturned: 8,205,162 RowsReturnedRate: 1722615 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.76s lab1ai-05.int.abc.com (10.34s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 127,588 TotalCpuTime: 7.59s TotalNetworkReceiveTime: 6.41s TotalNetworkSendTime: 19ms TotalStorageWaitTime: 0ns TotalTime: 10.34s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 133ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (55ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 45.2 MiB/s OverallThroughput: 28.7 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 18ms ThriftTransmitTime(*): 35ms TotalTime: 55ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 947ms GetResultsTime: 6ms LoadFactor: 0.62 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,588 RowsReturnedRate: 12403 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.32s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,621,391 BuildTime: 1.51s LeftChildRows: 9,293,828 LeftChildTime: 1.26s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 9,293,828 RowsReturnedRate: 997646 per second TotalTime: 9.32s EXCHANGE_NODE (id=5) (1.97s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 105ms DataArrivalWaitTime: 1.77s DeserializeRowBatchTimer: 369ms FirstBatchArrivalWaitTime: 90ms PeakMemoryUsage: 22.9 MiB RowsReturned: 7,621,391 RowsReturnedRate: 3864795 per second SendersBlockedTimer: 93ms SendersBlockedTotalTimer(*): 466ms TotalTime: 1.97s EXCHANGE_NODE (id=4) (4.71s) AsyncTotalTime: 0ns BytesReceived: 85.8 MiB ConvertRowBatchTime: 144ms DataArrivalWaitTime: 4.51s DeserializeRowBatchTimer: 382ms FirstBatchArrivalWaitTime: 163ms PeakMemoryUsage: 6.3 MiB RowsReturned: 9,293,828 RowsReturnedRate: 1971552 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.71s lab1ai-16.int.abc.com (10.33s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 127,883 TotalCpuTime: 7.68s TotalNetworkReceiveTime: 6.32s TotalNetworkSendTime: 22ms TotalStorageWaitTime: 0ns TotalTime: 10.33s CodeGen (138ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 132ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 138ms DataStreamSender (dst_id=6) (54ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 43.1 MiB/s OverallThroughput: 29.1 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 36ms TotalTime: 54ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.28s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 939ms GetResultsTime: 6ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,883 RowsReturnedRate: 12435 per second TotalTime: 10.28s HASH_JOIN_NODE (id=2) (9.32s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.48s BuildBuckets: 8,388,608 BuildRows: 7,619,317 BuildTime: 1.58s LeftChildRows: 8,727,478 LeftChildTime: 1.29s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 8,727,478 RowsReturnedRate: 936257 per second TotalTime: 9.32s EXCHANGE_NODE (id=5) (1.90s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 119ms DataArrivalWaitTime: 1.66s DeserializeRowBatchTimer: 386ms FirstBatchArrivalWaitTime: 91ms PeakMemoryUsage: 22.7 MiB RowsReturned: 7,619,317 RowsReturnedRate: 4012485 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 1.90s EXCHANGE_NODE (id=4) (4.70s) AsyncTotalTime: 0ns BytesReceived: 81.4 MiB ConvertRowBatchTime: 136ms DataArrivalWaitTime: 4.51s DeserializeRowBatchTimer: 356ms FirstBatchArrivalWaitTime: 166ms PeakMemoryUsage: 5.8 MiB RowsReturned: 8,727,478 RowsReturnedRate: 1856985 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.70s lab1ai-11.int.abc.com (10.33s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 128,099 TotalCpuTime: 7.54s TotalNetworkReceiveTime: 6.46s TotalNetworkSendTime: 18ms TotalStorageWaitTime: 0ns TotalTime: 10.33s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 133ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (51ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 45.2 MiB/s OverallThroughput: 31.2 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 15ms ThriftTransmitTime(*): 35ms TotalTime: 51ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.28s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 922ms GetResultsTime: 8ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,099 RowsReturnedRate: 12454 per second TotalTime: 10.28s HASH_JOIN_NODE (id=2) (9.34s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.48s BuildBuckets: 8,388,608 BuildRows: 7,624,026 BuildTime: 1.50s LeftChildRows: 8,408,499 LeftChildTime: 1.23s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 8,408,499 RowsReturnedRate: 900394 per second TotalTime: 9.34s EXCHANGE_NODE (id=5) (1.98s) AsyncTotalTime: 0ns BytesReceived: 78.3 MiB ConvertRowBatchTime: 106ms DataArrivalWaitTime: 1.71s DeserializeRowBatchTimer: 459ms FirstBatchArrivalWaitTime: 93ms PeakMemoryUsage: 22.9 MiB RowsReturned: 7,624,026 RowsReturnedRate: 3854795 per second SendersBlockedTimer: 114ms SendersBlockedTotalTimer(*): 454ms TotalTime: 1.98s EXCHANGE_NODE (id=4) (4.78s) AsyncTotalTime: 0ns BytesReceived: 79.1 MiB ConvertRowBatchTime: 159ms DataArrivalWaitTime: 4.55s DeserializeRowBatchTimer: 384ms FirstBatchArrivalWaitTime: 165ms PeakMemoryUsage: 5.7 MiB RowsReturned: 8,408,499 RowsReturnedRate: 1760591 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.78s lab1ai-10.int.abc.com (10.33s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 128,551 TotalCpuTime: 7.38s TotalNetworkReceiveTime: 6.62s TotalNetworkSendTime: 15ms TotalStorageWaitTime: 0ns TotalTime: 10.33s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 132ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (49ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 44.4 MiB/s OverallThroughput: 32.3 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 16ms ThriftTransmitTime(*): 35ms TotalTime: 49ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 885ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,551 RowsReturnedRate: 12496 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.38s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,624,865 BuildTime: 1.46s LeftChildRows: 7,899,266 LeftChildTime: 1.18s LoadFactor: 0.61 PeakMemoryUsage: 355.8 MiB RowsReturned: 7,899,266 RowsReturnedRate: 842213 per second TotalTime: 9.38s EXCHANGE_NODE (id=5) (2.02s) AsyncTotalTime: 0ns BytesReceived: 78.3 MiB ConvertRowBatchTime: 111ms DataArrivalWaitTime: 1.77s DeserializeRowBatchTimer: 404ms FirstBatchArrivalWaitTime: 91ms PeakMemoryUsage: 22.9 MiB RowsReturned: 7,624,865 RowsReturnedRate: 3778066 per second SendersBlockedTimer: 94ms SendersBlockedTotalTimer(*): 375ms TotalTime: 2.02s EXCHANGE_NODE (id=4) (4.87s) AsyncTotalTime: 0ns BytesReceived: 75.0 MiB ConvertRowBatchTime: 124ms DataArrivalWaitTime: 4.69s DeserializeRowBatchTimer: 351ms FirstBatchArrivalWaitTime: 166ms PeakMemoryUsage: 5.2 MiB RowsReturned: 7,899,266 RowsReturnedRate: 1623197 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.87s lab1ai-18.int.abc.com (10.33s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 127,262 TotalCpuTime: 8.10s TotalNetworkReceiveTime: 5.92s TotalNetworkSendTime: 5ms TotalStorageWaitTime: 0ns TotalTime: 10.33s CodeGen (140ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 133ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 140ms DataStreamSender (dst_id=6) (46ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 50.6 MiB/s OverallThroughput: 33.7 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 19ms ThriftTransmitTime(*): 31ms TotalTime: 46ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 904ms GetResultsTime: 10ms LoadFactor: 0.62 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,262 RowsReturnedRate: 12369 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.36s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.48s BuildBuckets: 8,388,608 BuildRows: 7,622,148 BuildTime: 2.06s LeftChildRows: 8,588,559 LeftChildTime: 1.25s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 8,588,559 RowsReturnedRate: 917842 per second TotalTime: 9.36s EXCHANGE_NODE (id=5) (1.42s) AsyncTotalTime: 0ns BytesReceived: 78.3 MiB ConvertRowBatchTime: 115ms DataArrivalWaitTime: 1.16s DeserializeRowBatchTimer: 399ms FirstBatchArrivalWaitTime: 87ms PeakMemoryUsage: 23.0 MiB RowsReturned: 7,622,148 RowsReturnedRate: 5371847 per second SendersBlockedTimer: 703ms SendersBlockedTotalTimer(*): 5.98s TotalTime: 1.42s EXCHANGE_NODE (id=4) (4.78s) AsyncTotalTime: 0ns BytesReceived: 79.8 MiB ConvertRowBatchTime: 138ms DataArrivalWaitTime: 4.58s DeserializeRowBatchTimer: 391ms FirstBatchArrivalWaitTime: 164ms PeakMemoryUsage: 5.7 MiB RowsReturned: 8,588,559 RowsReturnedRate: 1797263 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.78s lab1ai-08.int.abc.com (10.33s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 128,190 TotalCpuTime: 7.55s TotalNetworkReceiveTime: 6.46s TotalNetworkSendTime: 14ms TotalStorageWaitTime: 0ns TotalTime: 10.33s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 133ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (46ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 47.9 MiB/s OverallThroughput: 34.3 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 15ms ThriftTransmitTime(*): 33ms TotalTime: 46ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 948ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,190 RowsReturnedRate: 12461 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.32s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,623,456 BuildTime: 1.47s LeftChildRows: 8,328,200 LeftChildTime: 1.26s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 8,328,200 RowsReturnedRate: 893991 per second TotalTime: 9.32s EXCHANGE_NODE (id=5) (2.00s) AsyncTotalTime: 0ns BytesReceived: 78.3 MiB ConvertRowBatchTime: 104ms DataArrivalWaitTime: 1.77s DeserializeRowBatchTimer: 401ms FirstBatchArrivalWaitTime: 91ms PeakMemoryUsage: 22.9 MiB RowsReturned: 7,623,456 RowsReturnedRate: 3802929 per second SendersBlockedTimer: 102ms SendersBlockedTotalTimer(*): 102ms TotalTime: 2.00s EXCHANGE_NODE (id=4) (4.72s) AsyncTotalTime: 0ns BytesReceived: 78.8 MiB ConvertRowBatchTime: 141ms DataArrivalWaitTime: 4.52s DeserializeRowBatchTimer: 350ms FirstBatchArrivalWaitTime: 164ms PeakMemoryUsage: 5.6 MiB RowsReturned: 8,328,200 RowsReturnedRate: 1762893 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.72s lab1ai-17.int.abc.com (10.33s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 128,766 TotalCpuTime: 8.04s TotalNetworkReceiveTime: 5.97s TotalNetworkSendTime: 11ms TotalStorageWaitTime: 0ns TotalTime: 10.33s CodeGen (138ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 132ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 138ms DataStreamSender (dst_id=6) (45ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 55.7 MiB/s OverallThroughput: 34.9 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 17ms ThriftTransmitTime(*): 28ms TotalTime: 45ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 966ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,766 RowsReturnedRate: 12517 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.30s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,620,670 BuildTime: 1.87s LeftChildRows: 9,002,679 LeftChildTime: 1.31s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 9,002,679 RowsReturnedRate: 968332 per second TotalTime: 9.30s EXCHANGE_NODE (id=5) (1.61s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 123ms DataArrivalWaitTime: 1.33s DeserializeRowBatchTimer: 409ms FirstBatchArrivalWaitTime: 89ms PeakMemoryUsage: 23.0 MiB RowsReturned: 7,620,670 RowsReturnedRate: 4730747 per second SendersBlockedTimer: 648ms SendersBlockedTotalTimer(*): 5.56s TotalTime: 1.61s EXCHANGE_NODE (id=4) (4.65s) AsyncTotalTime: 0ns BytesReceived: 83.4 MiB ConvertRowBatchTime: 139ms DataArrivalWaitTime: 4.45s DeserializeRowBatchTimer: 397ms FirstBatchArrivalWaitTime: 164ms PeakMemoryUsage: 6.1 MiB RowsReturned: 9,002,679 RowsReturnedRate: 1936145 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.65s lab1ai-04.int.abc.com (10.32s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.35 PeakMemoryUsage: 364.1 MiB PrepareTime: 4ms RowsProduced: 128,048 TotalCpuTime: 7.78s TotalNetworkReceiveTime: 6.17s TotalNetworkSendTime: 12ms TotalStorageWaitTime: 0ns TotalTime: 10.32s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 132ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (43ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 50.8 MiB/s OverallThroughput: 36.7 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 13ms ThriftTransmitTime(*): 31ms TotalTime: 43ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 971ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,048 RowsReturnedRate: 12447 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.29s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.48s BuildBuckets: 8,388,608 BuildRows: 7,625,832 BuildTime: 1.69s LeftChildRows: 8,326,007 LeftChildTime: 1.30s LoadFactor: 0.61 PeakMemoryUsage: 355.8 MiB RowsReturned: 8,326,007 RowsReturnedRate: 896058 per second TotalTime: 9.29s EXCHANGE_NODE (id=5) (1.79s) AsyncTotalTime: 0ns BytesReceived: 78.3 MiB ConvertRowBatchTime: 110ms DataArrivalWaitTime: 1.53s DeserializeRowBatchTimer: 431ms FirstBatchArrivalWaitTime: 88ms PeakMemoryUsage: 22.9 MiB RowsReturned: 7,625,832 RowsReturnedRate: 4268237 per second SendersBlockedTimer: 272ms SendersBlockedTotalTimer(*): 272ms TotalTime: 1.79s EXCHANGE_NODE (id=4) (4.65s) AsyncTotalTime: 0ns BytesReceived: 78.7 MiB ConvertRowBatchTime: 133ms DataArrivalWaitTime: 4.46s DeserializeRowBatchTimer: 377ms FirstBatchArrivalWaitTime: 166ms PeakMemoryUsage: 5.6 MiB RowsReturned: 8,326,007 RowsReturnedRate: 1788740 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.65s lab1ai-12.int.abc.com (10.32s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 363.9 MiB PrepareTime: 4ms RowsProduced: 128,644 TotalCpuTime: 7.67s TotalNetworkReceiveTime: 6.29s TotalNetworkSendTime: 6ms TotalStorageWaitTime: 0ns TotalTime: 10.32s CodeGen (138ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 131ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 138ms DataStreamSender (dst_id=6) (38ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 63.0 MiB/s OverallThroughput: 42.0 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 13ms ThriftTransmitTime(*): 25ms TotalTime: 38ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 896ms GetResultsTime: 8ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,644 RowsReturnedRate: 12500 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.37s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.49s BuildBuckets: 8,388,608 BuildRows: 7,615,776 BuildTime: 1.78s LeftChildRows: 7,873,851 LeftChildTime: 1.19s LoadFactor: 0.61 PeakMemoryUsage: 355.6 MiB RowsReturned: 7,873,851 RowsReturnedRate: 840206 per second TotalTime: 9.37s EXCHANGE_NODE (id=5) (1.70s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 110ms DataArrivalWaitTime: 1.47s DeserializeRowBatchTimer: 416ms FirstBatchArrivalWaitTime: 91ms PeakMemoryUsage: 22.7 MiB RowsReturned: 7,615,776 RowsReturnedRate: 4466395 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 1.70s EXCHANGE_NODE (id=4) (4.85s) AsyncTotalTime: 0ns BytesReceived: 75.1 MiB ConvertRowBatchTime: 130ms DataArrivalWaitTime: 4.66s DeserializeRowBatchTimer: 362ms FirstBatchArrivalWaitTime: 167ms PeakMemoryUsage: 5.3 MiB RowsReturned: 7,873,851 RowsReturnedRate: 1623265 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.85s lab1ai-07.int.abc.com (10.32s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.1 MiB PrepareTime: 4ms RowsProduced: 128,488 TotalCpuTime: 7.96s TotalNetworkReceiveTime: 5.99s TotalNetworkSendTime: 4ms TotalStorageWaitTime: 0ns TotalTime: 10.32s CodeGen (138ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 132ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 138ms DataStreamSender (dst_id=6) (39ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 56.8 MiB/s OverallThroughput: 40.4 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 13ms ThriftTransmitTime(*): 28ms TotalTime: 39ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 907ms GetResultsTime: 10ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 128,488 RowsReturnedRate: 12487 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.36s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.48s BuildBuckets: 8,388,608 BuildRows: 7,624,046 BuildTime: 2.02s LeftChildRows: 8,242,290 LeftChildTime: 1.22s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 8,242,290 RowsReturnedRate: 880977 per second TotalTime: 9.36s EXCHANGE_NODE (id=5) (1.45s) AsyncTotalTime: 0ns BytesReceived: 78.3 MiB ConvertRowBatchTime: 111ms DataArrivalWaitTime: 1.22s DeserializeRowBatchTimer: 406ms FirstBatchArrivalWaitTime: 93ms PeakMemoryUsage: 23.0 MiB RowsReturned: 7,624,046 RowsReturnedRate: 5252994 per second SendersBlockedTimer: 484ms SendersBlockedTotalTimer(*): 3.26s TotalTime: 1.45s EXCHANGE_NODE (id=4) (4.81s) AsyncTotalTime: 0ns BytesReceived: 78.1 MiB ConvertRowBatchTime: 133ms DataArrivalWaitTime: 4.62s DeserializeRowBatchTimer: 364ms FirstBatchArrivalWaitTime: 165ms PeakMemoryUsage: 5.6 MiB RowsReturned: 8,242,290 RowsReturnedRate: 1714444 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.81s lab1ai-13.int.abc.com (10.32s) Go To Host AsyncTotalTime: 0ns AverageThreadTokens: 1.33 PeakMemoryUsage: 364.0 MiB PrepareTime: 4ms RowsProduced: 127,996 TotalCpuTime: 7.96s TotalNetworkReceiveTime: 5.99s TotalNetworkSendTime: 6ms TotalStorageWaitTime: 0ns TotalTime: 10.32s CodeGen (139ms) AsyncTotalTime: 0ns CodegenTime: 1ms CompileTime: 132ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 139ms DataStreamSender (dst_id=6) (42ms) AsyncTotalTime: 0ns BytesSent: 1.6 MiB NetworkThroughput(*): 60.5 MiB/s OverallThroughput: 37.7 MiB/s PeakMemoryUsage: 107.9 KiB SerializeBatchTime: 17ms ThriftTransmitTime(*): 26ms TotalTime: 42ms UncompressedRowBatchSize: 3.4 MiB AGGREGATION_NODE (id=3) (10.29s) ExecOption: Codegen Enabled AsyncTotalTime: 0ns BuildBuckets: 131,072 BuildTime: 902ms GetResultsTime: 7ms LoadFactor: 0.63 PeakMemoryUsage: 8.1 MiB RowsReturned: 127,996 RowsReturnedRate: 12443 per second TotalTime: 10.29s HASH_JOIN_NODE (id=2) (9.36s) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously AsyncTotalTime: 3.48s BuildBuckets: 8,388,608 BuildRows: 7,619,518 BuildTime: 1.92s LeftChildRows: 9,662,846 LeftChildTime: 1.28s LoadFactor: 0.61 PeakMemoryUsage: 355.7 MiB RowsReturned: 9,662,846 RowsReturnedRate: 1032420 per second TotalTime: 9.36s EXCHANGE_NODE (id=5) (1.56s) AsyncTotalTime: 0ns BytesReceived: 78.2 MiB ConvertRowBatchTime: 106ms DataArrivalWaitTime: 1.35s DeserializeRowBatchTimer: 368ms FirstBatchArrivalWaitTime: 94ms PeakMemoryUsage: 22.8 MiB RowsReturned: 7,619,518 RowsReturnedRate: 4886888 per second SendersBlockedTimer: 84ms SendersBlockedTotalTimer(*): 829ms TotalTime: 1.56s EXCHANGE_NODE (id=4) (4.74s) AsyncTotalTime: 0ns BytesReceived: 88.7 MiB ConvertRowBatchTime: 180ms DataArrivalWaitTime: 4.48s DeserializeRowBatchTimer: 434ms FirstBatchArrivalWaitTime: 164ms PeakMemoryUsage: 6.5 MiB RowsReturned: 9,662,846 RowsReturnedRate: 2037320 per second SendersBlockedTimer: 0ns SendersBlockedTotalTimer(*): 0ns TotalTime: 4.74s Collapse All Averaged Fragment 2 lab1ai-06.int.abc.com lab1ai-14.int.abc.com lab1ai-15.int.abc.com lab1ai-09.int.abc.com lab1ai-05.int.abc.com lab1ai-16.int.abc.com lab1ai-11.int.abc.com lab1ai-10.int.abc.com lab1ai-18.int.abc.com lab1ai-08.int.abc.com lab1ai-17.int.abc.com lab1ai-04.int.abc.com lab1ai-12.int.abc.com lab1ai-07.int.abc.com lab1ai-13.int.abc.com Averaged Fragment 3 split sizes: min: 53.25 MB, max: 218.76 MB, avg: 123.67 MB, stddev: 41.25 MB completion times: min:575.809ms max:3s422ms mean: 1s968ms stddev:692.970ms execution rates: min:47.35 MB/sec max:92.48 MB/sec mean:64.32 MB/sec stddev:9.83 MB/sec num instances: 14 AsyncTotalTime: 0ns AverageThreadTokens: 2.01 PeakMemoryUsage: 42.8 MiB PrepareTime: 59.10us RowsProduced: 8,165,459 TotalCpuTime: 3.53s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 642ms TotalStorageWaitTime: 20ms TotalTime: 1.94s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (1.86s) AsyncTotalTime: 0ns BytesSent: 83.8 MiB NetworkThroughput(*): 15.9 MiB/s OverallThroughput: 46.1 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 611ms ThriftTransmitTime(*): 5.36s TotalTime: 1.86s UncompressedRowBatchSize: 155.8 MiB HDFS_SCAN_NODE (id=0) (62ms) AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.02 AverageScannerThreadConcurrency: 1.07 BytesRead: 38.5 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 38.5 MiB BytesReadShortCircuit: 38.5 MiB DecompressionTime: 131ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 42.3 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 8,165,459 RowsReturned: 8,165,459 RowsReturnedRate: 127956006 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 29 ScannerThreadsTotalWallClockTime: 2.16s MaterializeTupleTime(*): 2.00s ScannerThreadsSysTime: 46ms ScannerThreadsUserTime: 442ms ScannerThreadsVoluntaryContextSwitches: 6,576 TotalRawHdfsReadTime(*): 27ms TotalReadThroughput: 18.6 MiB/s TotalTime: 62ms lab1ai-07.int.abc.com (3.40s) Go To Host Hdfs split stats (:<# splits>/): 11:1/106.23 MB 1:1/112.52 MB AsyncTotalTime: 0ns AverageThreadTokens: 3.00 PeakMemoryUsage: 80.2 MiB PrepareTime: 66.28us RowsProduced: 14,725,734 TotalCpuTime: 9.16s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 969ms TotalStorageWaitTime: 36ms TotalTime: 3.40s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (3.29s) AsyncTotalTime: 0ns BytesSent: 159.1 MiB NetworkThroughput(*): 19.8 MiB/s OverallThroughput: 48.3 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 1.21s ThriftTransmitTime(*): 8.03s TotalTime: 3.29s UncompressedRowBatchSize: 280.9 MiB HDFS_SCAN_NODE (id=0) (88ms) Hdfs split stats (:<# splits>/): 11:1/106.23 MB 1:1/112.52 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:2 ExecOption: Codegen enabled: 0 out of 2 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 2.00 BytesRead: 69.6 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 69.6 MiB BytesReadShortCircuit: 69.6 MiB DecompressionTime: 210ms NumColumns: 0 NumDisksAccessed: 2 NumScannerThreadsStarted: 2 PeakMemoryUsage: 79.6 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 14,725,734 RowsReturned: 14,725,734 RowsReturnedRate: 166585763 per second ScanRangesComplete: 2 ScannerThreadsInvoluntaryContextSwitches: 37 ScannerThreadsTotalWallClockTime: 6.68s MaterializeTupleTime(*): 6.41s ScannerThreadsSysTime: 85ms ScannerThreadsUserTime: 782ms ScannerThreadsVoluntaryContextSwitches: 14,351 TotalRawHdfsReadTime(*): 48ms TotalReadThroughput: 19.9 MiB/s TotalTime: 88ms lab1ai-09.int.abc.com (2.72s) Go To Host Hdfs split stats (:<# splits>/): 8:1/168.39 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 45.5 MiB PrepareTime: 63.42us RowsProduced: 10,792,149 TotalCpuTime: 4.53s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 961ms TotalStorageWaitTime: 19ms TotalTime: 2.72s CodeGen (61ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 61ms DataStreamSender (dst_id=5) (2.63s) AsyncTotalTime: 0ns BytesSent: 114.2 MiB NetworkThroughput(*): 16.3 MiB/s OverallThroughput: 43.4 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 854ms ThriftTransmitTime(*): 7.01s TotalTime: 2.63s UncompressedRowBatchSize: 205.9 MiB HDFS_SCAN_NODE (id=0) (74ms) Hdfs split stats (:<# splits>/): 8:1/168.39 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 50.9 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 50.9 MiB BytesReadShortCircuit: 50.9 MiB DecompressionTime: 157ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 45.1 MiB PerReadThreadRawHdfsThroughput: 1.2 GiB/s RowsRead: 10,792,149 RowsReturned: 10,792,149 RowsReturnedRate: 144297857 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 5 ScannerThreadsTotalWallClockTime: 2.71s MaterializeTupleTime(*): 2.52s ScannerThreadsSysTime: 53ms ScannerThreadsUserTime: 553ms ScannerThreadsVoluntaryContextSwitches: 8,777 TotalRawHdfsReadTime(*): 41ms TotalReadThroughput: 20.4 MiB/s TotalTime: 74ms lab1ai-08.int.abc.com (2.70s) Go To Host Hdfs split stats (:<# splits>/): 3:1/158.23 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 45.5 MiB PrepareTime: 55.34us RowsProduced: 10,746,509 TotalCpuTime: 4.48s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 966ms TotalStorageWaitTime: 18ms TotalTime: 2.70s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (2.61s) AsyncTotalTime: 0ns BytesSent: 110.1 MiB NetworkThroughput(*): 14.3 MiB/s OverallThroughput: 42.2 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 817ms ThriftTransmitTime(*): 7.72s TotalTime: 2.61s UncompressedRowBatchSize: 205.0 MiB HDFS_SCAN_NODE (id=0) (74ms) Hdfs split stats (:<# splits>/): 3:1/158.23 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 49.3 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 49.3 MiB BytesReadShortCircuit: 49.3 MiB DecompressionTime: 162ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 45.1 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 10,746,509 RowsReturned: 10,746,509 RowsReturnedRate: 143972655 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 58 ScannerThreadsTotalWallClockTime: 2.68s MaterializeTupleTime(*): 2.49s ScannerThreadsSysTime: 51ms ScannerThreadsUserTime: 575ms ScannerThreadsVoluntaryContextSwitches: 8,405 TotalRawHdfsReadTime(*): 34ms TotalReadThroughput: 16.4 MiB/s TotalTime: 74ms lab1ai-11.int.abc.com (2.46s) Go To Host Hdfs split stats (:<# splits>/): 0:1/145.55 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 45.5 MiB PrepareTime: 58.85us RowsProduced: 9,630,302 TotalCpuTime: 4.00s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 963ms TotalStorageWaitTime: 18ms TotalTime: 2.46s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (2.37s) AsyncTotalTime: 0ns BytesSent: 98.4 MiB NetworkThroughput(*): 12.5 MiB/s OverallThroughput: 41.5 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 692ms ThriftTransmitTime(*): 7.86s TotalTime: 2.37s UncompressedRowBatchSize: 183.7 MiB HDFS_SCAN_NODE (id=0) (72ms) Hdfs split stats (:<# splits>/): 0:1/145.55 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 45.3 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 45.3 MiB BytesReadShortCircuit: 45.3 MiB DecompressionTime: 140ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 45.0 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 9,630,302 RowsReturned: 9,630,302 RowsReturnedRate: 132373234 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 28 ScannerThreadsTotalWallClockTime: 2.44s MaterializeTupleTime(*): 2.27s ScannerThreadsSysTime: 49ms ScannerThreadsUserTime: 454ms ScannerThreadsVoluntaryContextSwitches: 7,852 TotalRawHdfsReadTime(*): 31ms TotalReadThroughput: 18.1 MiB/s TotalTime: 72ms lab1ai-04.int.abc.com (2.35s) Go To Host Hdfs split stats (:<# splits>/): 9:1/144.91 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 45.5 MiB PrepareTime: 52.83us RowsProduced: 9,843,842 TotalCpuTime: 4.01s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 746ms TotalStorageWaitTime: 16ms TotalTime: 2.35s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (2.26s) AsyncTotalTime: 0ns BytesSent: 100.7 MiB NetworkThroughput(*): 15.2 MiB/s OverallThroughput: 44.5 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 755ms ThriftTransmitTime(*): 6.60s TotalTime: 2.26s UncompressedRowBatchSize: 187.8 MiB HDFS_SCAN_NODE (id=0) (75ms) Hdfs split stats (:<# splits>/): 9:1/144.91 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 46.2 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 46.2 MiB BytesReadShortCircuit: 46.2 MiB DecompressionTime: 155ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 45.1 MiB PerReadThreadRawHdfsThroughput: 1.7 GiB/s RowsRead: 9,843,842 RowsReturned: 9,843,842 RowsReturnedRate: 130865021 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 14 ScannerThreadsTotalWallClockTime: 2.34s MaterializeTupleTime(*): 2.16s ScannerThreadsSysTime: 48ms ScannerThreadsUserTime: 541ms ScannerThreadsVoluntaryContextSwitches: 7,731 TotalRawHdfsReadTime(*): 27ms TotalReadThroughput: 18.5 MiB/s TotalTime: 75ms lab1ai-12.int.abc.com (1.81s) Go To Host Hdfs split stats (:<# splits>/): 6:1/119.21 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 41.5 MiB PrepareTime: 54.72us RowsProduced: 7,594,835 TotalCpuTime: 3.09s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 574ms TotalStorageWaitTime: 17ms TotalTime: 1.81s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (1.74s) AsyncTotalTime: 0ns BytesSent: 76.8 MiB NetworkThroughput(*): 14.9 MiB/s OverallThroughput: 44.2 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 568ms ThriftTransmitTime(*): 5.17s TotalTime: 1.74s UncompressedRowBatchSize: 144.9 MiB HDFS_SCAN_NODE (id=0) (60ms) Hdfs split stats (:<# splits>/): 6:1/119.21 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 36.0 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 36.0 MiB BytesReadShortCircuit: 36.0 MiB DecompressionTime: 148ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 41.0 MiB PerReadThreadRawHdfsThroughput: 1.5 GiB/s RowsRead: 7,594,835 RowsReturned: 7,594,835 RowsReturnedRate: 126066534 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 8 ScannerThreadsTotalWallClockTime: 1.79s MaterializeTupleTime(*): 1.62s ScannerThreadsSysTime: 61ms ScannerThreadsUserTime: 476ms ScannerThreadsVoluntaryContextSwitches: 5,518 TotalRawHdfsReadTime(*): 22ms TotalReadThroughput: 18.0 MiB/s TotalTime: 60ms lab1ai-14.int.abc.com (1.77s) Go To Host Hdfs split stats (:<# splits>/): 3:1/119.68 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 45.5 MiB PrepareTime: 56.40us RowsProduced: 7,695,841 TotalCpuTime: 3.02s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 577ms TotalStorageWaitTime: 17ms TotalTime: 1.77s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (1.70s) AsyncTotalTime: 0ns BytesSent: 77.5 MiB NetworkThroughput(*): 15.1 MiB/s OverallThroughput: 45.6 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 540ms ThriftTransmitTime(*): 5.14s TotalTime: 1.70s UncompressedRowBatchSize: 146.8 MiB HDFS_SCAN_NODE (id=0) (61ms) Hdfs split stats (:<# splits>/): 3:1/119.68 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 36.6 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 36.6 MiB BytesReadShortCircuit: 36.6 MiB DecompressionTime: 161ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 45.0 MiB PerReadThreadRawHdfsThroughput: 1.3 GiB/s RowsRead: 7,695,841 RowsReturned: 7,695,841 RowsReturnedRate: 124544342 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 30 ScannerThreadsTotalWallClockTime: 1.76s MaterializeTupleTime(*): 1.57s ScannerThreadsSysTime: 59ms ScannerThreadsUserTime: 465ms ScannerThreadsVoluntaryContextSwitches: 5,593 TotalRawHdfsReadTime(*): 26ms TotalReadThroughput: 18.3 MiB/s TotalTime: 61ms lab1ai-17.int.abc.com (1.76s) Go To Host Hdfs split stats (:<# splits>/): 5:1/112.02 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 41.5 MiB PrepareTime: 64.20us RowsProduced: 7,268,553 TotalCpuTime: 3.00s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 576ms TotalStorageWaitTime: 14ms TotalTime: 1.76s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (1.70s) AsyncTotalTime: 0ns BytesSent: 73.2 MiB NetworkThroughput(*): 15.7 MiB/s OverallThroughput: 42.9 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 532ms ThriftTransmitTime(*): 4.65s TotalTime: 1.70s UncompressedRowBatchSize: 138.7 MiB HDFS_SCAN_NODE (id=0) (45ms) Hdfs split stats (:<# splits>/): 5:1/112.02 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 34.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 34.7 MiB BytesReadShortCircuit: 34.7 MiB DecompressionTime: 170ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 41.1 MiB PerReadThreadRawHdfsThroughput: 1.7 GiB/s RowsRead: 7,268,553 RowsReturned: 7,268,553 RowsReturnedRate: 158184043 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 24 ScannerThreadsTotalWallClockTime: 1.75s MaterializeTupleTime(*): 1.56s ScannerThreadsSysTime: 37ms ScannerThreadsUserTime: 448ms ScannerThreadsVoluntaryContextSwitches: 5,538 TotalRawHdfsReadTime(*): 19ms TotalReadThroughput: 17.4 MiB/s TotalTime: 45ms lab1ai-06.int.abc.com (1.76s) Go To Host Hdfs split stats (:<# splits>/): 7:1/109.36 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 41.5 MiB PrepareTime: 60.04us RowsProduced: 7,236,761 TotalCpuTime: 2.98s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 578ms TotalStorageWaitTime: 21ms TotalTime: 1.76s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (1.68s) AsyncTotalTime: 0ns BytesSent: 73.6 MiB NetworkThroughput(*): 17.2 MiB/s OverallThroughput: 43.7 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 534ms ThriftTransmitTime(*): 4.28s TotalTime: 1.68s UncompressedRowBatchSize: 138.1 MiB HDFS_SCAN_NODE (id=0) (61ms) Hdfs split stats (:<# splits>/): 7:1/109.36 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 34.2 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 34.2 MiB BytesReadShortCircuit: 34.2 MiB DecompressionTime: 102ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 41.1 MiB PerReadThreadRawHdfsThroughput: 1.1 GiB/s RowsRead: 7,236,761 RowsReturned: 7,236,761 RowsReturnedRate: 118334075 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 9 ScannerThreadsTotalWallClockTime: 1.74s MaterializeTupleTime(*): 1.61s ScannerThreadsSysTime: 38ms ScannerThreadsUserTime: 380ms ScannerThreadsVoluntaryContextSwitches: 5,935 TotalRawHdfsReadTime(*): 30ms TotalReadThroughput: 17.1 MiB/s TotalTime: 61ms lab1ai-15.int.abc.com (1.74s) Go To Host Hdfs split stats (:<# splits>/): 1:1/108.71 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 41.5 MiB PrepareTime: 49.61us RowsProduced: 7,295,611 TotalCpuTime: 2.96s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 578ms TotalStorageWaitTime: 18ms TotalTime: 1.74s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (1.67s) AsyncTotalTime: 0ns BytesSent: 74.5 MiB NetworkThroughput(*): 14.5 MiB/s OverallThroughput: 44.5 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 537ms ThriftTransmitTime(*): 5.13s TotalTime: 1.67s UncompressedRowBatchSize: 139.2 MiB HDFS_SCAN_NODE (id=0) (61ms) Hdfs split stats (:<# splits>/): 1:1/108.71 MB Hdfs Read Thread Concurrency Bucket: 0:75% 1:25% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.25 AverageScannerThreadConcurrency: 1.00 BytesRead: 34.6 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 34.6 MiB BytesReadShortCircuit: 34.6 MiB DecompressionTime: 123ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 41.0 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 7,295,611 RowsReturned: 7,295,611 RowsReturnedRate: 118717191 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 113 ScannerThreadsTotalWallClockTime: 1.73s MaterializeTupleTime(*): 1.58s ScannerThreadsSysTime: 40ms ScannerThreadsUserTime: 418ms ScannerThreadsVoluntaryContextSwitches: 5,421 TotalRawHdfsReadTime(*): 24ms TotalReadThroughput: 17.3 MiB/s TotalTime: 61ms lab1ai-16.int.abc.com (1.63s) Go To Host Hdfs split stats (:<# splits>/): 10:1/101.78 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 38.0 MiB PrepareTime: 52.58us RowsProduced: 6,866,119 TotalCpuTime: 2.74s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 577ms TotalStorageWaitTime: 15ms TotalTime: 1.63s CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (1.57s) AsyncTotalTime: 0ns BytesSent: 70.5 MiB NetworkThroughput(*): 15.6 MiB/s OverallThroughput: 44.8 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 486ms ThriftTransmitTime(*): 4.53s TotalTime: 1.57s UncompressedRowBatchSize: 131.0 MiB HDFS_SCAN_NODE (id=0) (51ms) Hdfs split stats (:<# splits>/): 10:1/101.78 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 32.4 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 32.4 MiB BytesReadShortCircuit: 32.4 MiB DecompressionTime: 95ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 37.6 MiB PerReadThreadRawHdfsThroughput: 1.6 GiB/s RowsRead: 6,866,119 RowsReturned: 6,866,119 RowsReturnedRate: 132405302 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 57 ScannerThreadsTotalWallClockTime: 1.62s MaterializeTupleTime(*): 1.50s ScannerThreadsSysTime: 39ms ScannerThreadsUserTime: 358ms ScannerThreadsVoluntaryContextSwitches: 5,294 TotalRawHdfsReadTime(*): 19ms TotalReadThroughput: 21.6 MiB/s TotalTime: 51ms lab1ai-18.int.abc.com (1.48s) Go To Host Hdfs split stats (:<# splits>/): 0:1/115.22 MB AsyncTotalTime: 0ns AverageThreadTokens: 2.00 PeakMemoryUsage: 41.5 MiB PrepareTime: 63.96us RowsProduced: 7,298,700 TotalCpuTime: 2.63s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 381ms TotalStorageWaitTime: 19ms TotalTime: 1.48s CodeGen (63ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 63ms DataStreamSender (dst_id=5) (1.41s) AsyncTotalTime: 0ns BytesSent: 72.0 MiB NetworkThroughput(*): 16.7 MiB/s OverallThroughput: 50.9 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 497ms ThriftTransmitTime(*): 4.32s TotalTime: 1.41s UncompressedRowBatchSize: 139.2 MiB HDFS_SCAN_NODE (id=0) (57ms) Hdfs split stats (:<# splits>/): 0:1/115.22 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 35.0 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 35.0 MiB BytesReadShortCircuit: 35.0 MiB DecompressionTime: 90ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 41.0 MiB PerReadThreadRawHdfsThroughput: 1.1 GiB/s RowsRead: 7,298,700 RowsReturned: 7,298,700 RowsReturnedRate: 127947441 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 9 ScannerThreadsTotalWallClockTime: 1.47s MaterializeTupleTime(*): 1.35s ScannerThreadsSysTime: 35ms ScannerThreadsUserTime: 325ms ScannerThreadsVoluntaryContextSwitches: 6,087 TotalRawHdfsReadTime(*): 32ms TotalReadThroughput: 23.3 MiB/s TotalTime: 57ms lab1ai-05.int.abc.com (977ms) Go To Host Hdfs split stats (:<# splits>/): 3:1/56.26 MB AsyncTotalTime: 0ns AverageThreadTokens: 1.67 PeakMemoryUsage: 23.5 MiB PrepareTime: 53.40us RowsProduced: 3,847,921 TotalCpuTime: 1.67s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 520ms TotalStorageWaitTime: 20ms TotalTime: 977ms CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (928ms) AsyncTotalTime: 0ns BytesSent: 38.8 MiB NetworkThroughput(*): 12.3 MiB/s OverallThroughput: 41.8 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 292ms ThriftTransmitTime(*): 3.16s TotalTime: 928ms UncompressedRowBatchSize: 73.4 MiB HDFS_SCAN_NODE (id=0) (43ms) Hdfs split stats (:<# splits>/): 3:1/56.26 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 17.9 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 17.9 MiB BytesReadShortCircuit: 17.9 MiB DecompressionTime: 63ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 23.1 MiB PerReadThreadRawHdfsThroughput: 1.8 GiB/s RowsRead: 3,847,921 RowsReturned: 3,847,921 RowsReturnedRate: 88527422 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 24 ScannerThreadsTotalWallClockTime: 959ms MaterializeTupleTime(*): 870ms ScannerThreadsSysTime: 17ms ScannerThreadsUserTime: 237ms ScannerThreadsVoluntaryContextSwitches: 2,889 TotalRawHdfsReadTime(*): 9ms TotalReadThroughput: 17.9 MiB/s TotalTime: 43ms lab1ai-10.int.abc.com (559ms) Go To Host Hdfs split stats (:<# splits>/): 2:1/53.25 MB AsyncTotalTime: 0ns AverageThreadTokens: 1.50 PeakMemoryUsage: 22.0 MiB PrepareTime: 75.83us RowsProduced: 3,473,549 TotalCpuTime: 1.13s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 23ms TotalStorageWaitTime: 24ms TotalTime: 559ms CodeGen (62ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 56ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 62ms DataStreamSender (dst_id=5) (510ms) AsyncTotalTime: 0ns BytesSent: 34.3 MiB NetworkThroughput(*): 23.0 MiB/s OverallThroughput: 67.1 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 235ms ThriftTransmitTime(*): 1.49s TotalTime: 510ms UncompressedRowBatchSize: 66.3 MiB HDFS_SCAN_NODE (id=0) (44ms) Hdfs split stats (:<# splits>/): 2:1/53.25 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 1.00 BytesRead: 16.5 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 16.5 MiB BytesReadShortCircuit: 16.5 MiB DecompressionTime: 52ms NumColumns: 0 NumDisksAccessed: 1 NumScannerThreadsStarted: 1 PeakMemoryUsage: 21.5 MiB PerReadThreadRawHdfsThroughput: 1.0 GiB/s RowsRead: 3,473,549 RowsReturned: 3,473,549 RowsReturnedRate: 78563210 per second ScanRangesComplete: 1 ScannerThreadsInvoluntaryContextSwitches: 2 ScannerThreadsTotalWallClockTime: 541ms MaterializeTupleTime(*): 459ms ScannerThreadsSysTime: 20ms ScannerThreadsUserTime: 163ms ScannerThreadsVoluntaryContextSwitches: 2,682 TotalRawHdfsReadTime(*): 15ms TotalReadThroughput: 16.5 MiB/s TotalTime: 44ms Collapse All Averaged Fragment 3 lab1ai-07.int.abc.com lab1ai-09.int.abc.com lab1ai-08.int.abc.com lab1ai-11.int.abc.com lab1ai-04.int.abc.com lab1ai-12.int.abc.com lab1ai-14.int.abc.com lab1ai-17.int.abc.com lab1ai-06.int.abc.com lab1ai-15.int.abc.com lab1ai-16.int.abc.com lab1ai-18.int.abc.com lab1ai-05.int.abc.com lab1ai-10.int.abc.com Averaged Fragment 4 split sizes: min: 373.34 MB, max: 498.02 MB, avg: 406.75 MB, stddev: 54.97 MB completion times: min:9s252ms max:10s134ms mean: 9s612ms stddev:304.352ms execution rates: min:39.04 MB/sec max:49.57 MB/sec mean:42.19 MB/sec stddev:4.30 MB/sec num instances: 15 AsyncTotalTime: 0ns AverageThreadTokens: 4.19 PeakMemoryUsage: 65.3 MiB PrepareTime: 66.05us RowsProduced: 11,883,743 TotalCpuTime: 33.32s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.53s TotalStorageWaitTime: 54ms TotalTime: 9.59s CodeGen (74ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 68ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 74ms DataStreamSender (dst_id=4) (9.48s) AsyncTotalTime: 0ns BytesSent: 98.2 MiB NetworkThroughput(*): 8.8 MiB/s OverallThroughput: 10.3 MiB/s PeakMemoryUsage: 534.7 KiB SerializeBatchTime: 965ms ThriftTransmitTime(*): 11.15s TotalTime: 9.48s UncompressedRowBatchSize: 226.7 MiB HDFS_SCAN_NODE (id=1) (92ms) AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.23 BytesRead: 43.2 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 43.2 MiB BytesReadShortCircuit: 43.2 MiB DecompressionTime: 148ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 64.8 MiB PerReadThreadRawHdfsThroughput: 1.3 GiB/s RowsRead: 11,883,743 RowsReturned: 11,883,743 RowsReturnedRate: 128603281 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 28 ScannerThreadsTotalWallClockTime: 31.21s MaterializeTupleTime(*): 30.98s ScannerThreadsSysTime: 73ms ScannerThreadsUserTime: 814ms ScannerThreadsVoluntaryContextSwitches: 11,784 TotalRawHdfsReadTime(*): 33ms TotalReadThroughput: 4.4 MiB/s TotalTime: 92ms lab1ai-13.int.abc.com (10.11s) Go To Host Hdfs split stats (:<# splits>/): 11:1/124.51 MB 7:1/124.43 MB 8:1/124.60 MB 9:1/124.45 MB AsyncTotalTime: 0ns AverageThreadTokens: 5.00 PeakMemoryUsage: 78.5 MiB PrepareTime: 69.36us RowsProduced: 14,549,262 TotalCpuTime: 42.73s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.65s TotalStorageWaitTime: 115ms TotalTime: 10.11s CodeGen (66ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 60ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 66ms DataStreamSender (dst_id=4) (9.97s) AsyncTotalTime: 0ns BytesSent: 120.4 MiB NetworkThroughput(*): 10.1 MiB/s OverallThroughput: 12.1 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 1.13s ThriftTransmitTime(*): 11.96s TotalTime: 9.97s UncompressedRowBatchSize: 277.6 MiB HDFS_SCAN_NODE (id=1) (111ms) Hdfs split stats (:<# splits>/): 11:1/124.51 MB 7:1/124.43 MB 8:1/124.60 MB 9:1/124.45 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:4 ExecOption: Codegen enabled: 0 out of 4 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 4.00 BytesRead: 53.0 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 53.0 MiB BytesReadShortCircuit: 53.0 MiB DecompressionTime: 196ms NumColumns: 0 NumDisksAccessed: 4 NumScannerThreadsStarted: 4 PeakMemoryUsage: 78.1 MiB PerReadThreadRawHdfsThroughput: 1.1 GiB/s RowsRead: 14,549,262 RowsReturned: 14,549,262 RowsReturnedRate: 129951550 per second ScanRangesComplete: 4 ScannerThreadsInvoluntaryContextSwitches: 30 ScannerThreadsTotalWallClockTime: 40.30s MaterializeTupleTime(*): 39.95s ScannerThreadsSysTime: 104ms ScannerThreadsUserTime: 1.04s ScannerThreadsVoluntaryContextSwitches: 14,497 TotalRawHdfsReadTime(*): 47ms TotalReadThroughput: 5.0 MiB/s TotalTime: 111ms lab1ai-11.int.abc.com (10.09s) Go To Host Hdfs split stats (:<# splits>/): 1:1/124.41 MB 3:1/124.57 MB 6:1/124.47 MB 8:1/124.39 MB AsyncTotalTime: 0ns AverageThreadTokens: 5.00 PeakMemoryUsage: 78.5 MiB PrepareTime: 53.37us RowsProduced: 14,549,452 TotalCpuTime: 42.74s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.60s TotalStorageWaitTime: 95ms TotalTime: 10.09s CodeGen (82ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 76ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 82ms DataStreamSender (dst_id=4) (9.97s) AsyncTotalTime: 0ns BytesSent: 120.3 MiB NetworkThroughput(*): 10.1 MiB/s OverallThroughput: 12.1 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 1.12s ThriftTransmitTime(*): 11.92s TotalTime: 9.97s UncompressedRowBatchSize: 277.6 MiB HDFS_SCAN_NODE (id=1) (98ms) Hdfs split stats (:<# splits>/): 1:1/124.41 MB 3:1/124.57 MB 6:1/124.47 MB 8:1/124.39 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:4 ExecOption: Codegen enabled: 0 out of 4 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 4.00 BytesRead: 52.9 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 52.9 MiB BytesReadShortCircuit: 52.9 MiB DecompressionTime: 210ms NumColumns: 0 NumDisksAccessed: 4 NumScannerThreadsStarted: 4 PeakMemoryUsage: 78.1 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 14,549,452 RowsReturned: 14,549,452 RowsReturnedRate: 147277350 per second ScanRangesComplete: 4 ScannerThreadsInvoluntaryContextSwitches: 41 ScannerThreadsTotalWallClockTime: 40.23s MaterializeTupleTime(*): 39.89s ScannerThreadsSysTime: 79ms ScannerThreadsUserTime: 1.01s ScannerThreadsVoluntaryContextSwitches: 14,418 TotalRawHdfsReadTime(*): 35ms TotalReadThroughput: 5.0 MiB/s TotalTime: 98ms lab1ai-08.int.abc.com (10.09s) Go To Host Hdfs split stats (:<# splits>/): 0:1/124.54 MB 11:1/124.46 MB 2:1/124.43 MB 7:1/124.60 MB AsyncTotalTime: 0ns AverageThreadTokens: 4.81 PeakMemoryUsage: 78.5 MiB PrepareTime: 58.63us RowsProduced: 14,550,948 TotalCpuTime: 42.74s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.62s TotalStorageWaitTime: 62ms TotalTime: 10.09s CodeGen (69ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 63ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 69ms DataStreamSender (dst_id=4) (9.96s) AsyncTotalTime: 0ns BytesSent: 120.5 MiB NetworkThroughput(*): 10.1 MiB/s OverallThroughput: 12.1 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 1.15s ThriftTransmitTime(*): 11.93s TotalTime: 9.96s UncompressedRowBatchSize: 277.6 MiB HDFS_SCAN_NODE (id=1) (106ms) Hdfs split stats (:<# splits>/): 0:1/124.54 MB 11:1/124.46 MB 2:1/124.43 MB 7:1/124.60 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:4 ExecOption: Codegen enabled: 0 out of 4 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.81 BytesRead: 53.0 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 53.0 MiB BytesReadShortCircuit: 53.0 MiB DecompressionTime: 186ms NumColumns: 0 NumDisksAccessed: 4 NumScannerThreadsStarted: 4 PeakMemoryUsage: 78.1 MiB PerReadThreadRawHdfsThroughput: 1.0 GiB/s RowsRead: 14,550,948 RowsReturned: 14,550,948 RowsReturnedRate: 136505382 per second ScanRangesComplete: 4 ScannerThreadsInvoluntaryContextSwitches: 36 ScannerThreadsTotalWallClockTime: 40.24s MaterializeTupleTime(*): 39.95s ScannerThreadsSysTime: 98ms ScannerThreadsUserTime: 1.05s ScannerThreadsVoluntaryContextSwitches: 14,525 TotalRawHdfsReadTime(*): 51ms TotalReadThroughput: 5.0 MiB/s TotalTime: 106ms lab1ai-06.int.abc.com (10.01s) Go To Host Hdfs split stats (:<# splits>/): 4:1/124.54 MB 5:1/124.34 MB 6:1/124.39 MB 9:1/124.57 MB AsyncTotalTime: 0ns AverageThreadTokens: 4.81 PeakMemoryUsage: 79.5 MiB PrepareTime: 55.95us RowsProduced: 14,544,205 TotalCpuTime: 42.50s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.55s TotalStorageWaitTime: 58ms TotalTime: 10.01s CodeGen (69ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 63ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 69ms DataStreamSender (dst_id=4) (9.88s) AsyncTotalTime: 0ns BytesSent: 120.1 MiB NetworkThroughput(*): 9.9 MiB/s OverallThroughput: 12.2 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 1.13s ThriftTransmitTime(*): 12.09s TotalTime: 9.88s UncompressedRowBatchSize: 277.5 MiB HDFS_SCAN_NODE (id=1) (111ms) Hdfs split stats (:<# splits>/): 4:1/124.54 MB 5:1/124.34 MB 6:1/124.39 MB 9:1/124.57 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:4 ExecOption: Codegen enabled: 0 out of 4 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.81 BytesRead: 52.9 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 52.9 MiB BytesReadShortCircuit: 52.9 MiB DecompressionTime: 178ms NumColumns: 0 NumDisksAccessed: 4 NumScannerThreadsStarted: 4 PeakMemoryUsage: 79.1 MiB PerReadThreadRawHdfsThroughput: 1.1 GiB/s RowsRead: 14,544,205 RowsReturned: 14,544,205 RowsReturnedRate: 130731639 per second ScanRangesComplete: 4 ScannerThreadsInvoluntaryContextSwitches: 28 ScannerThreadsTotalWallClockTime: 40.00s MaterializeTupleTime(*): 39.72s ScannerThreadsSysTime: 83ms ScannerThreadsUserTime: 997ms ScannerThreadsVoluntaryContextSwitches: 14,492 TotalRawHdfsReadTime(*): 46ms TotalReadThroughput: 5.0 MiB/s TotalTime: 111ms lab1ai-14.int.abc.com (9.54s) Go To Host Hdfs split stats (:<# splits>/): 2:1/124.48 MB 5:1/124.43 MB 8:1/124.43 MB AsyncTotalTime: 0ns AverageThreadTokens: 4.00 PeakMemoryUsage: 60.6 MiB PrepareTime: 148.60us RowsProduced: 10,911,465 TotalCpuTime: 30.53s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.61s TotalStorageWaitTime: 42ms TotalTime: 9.54s CodeGen (66ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 60ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 66ms DataStreamSender (dst_id=4) (9.44s) AsyncTotalTime: 0ns BytesSent: 90.0 MiB NetworkThroughput(*): 8.1 MiB/s OverallThroughput: 9.5 MiB/s PeakMemoryUsage: 524.0 KiB SerializeBatchTime: 927ms ThriftTransmitTime(*): 11.17s TotalTime: 9.44s UncompressedRowBatchSize: 208.2 MiB HDFS_SCAN_NODE (id=1) (83ms) Hdfs split stats (:<# splits>/): 2:1/124.48 MB 5:1/124.43 MB 8:1/124.43 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 124ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 60.1 MiB PerReadThreadRawHdfsThroughput: 1.1 GiB/s RowsRead: 10,911,465 RowsReturned: 10,911,465 RowsReturnedRate: 130462278 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 25 ScannerThreadsTotalWallClockTime: 28.56s MaterializeTupleTime(*): 28.36s ScannerThreadsSysTime: 66ms ScannerThreadsUserTime: 719ms ScannerThreadsVoluntaryContextSwitches: 10,761 TotalRawHdfsReadTime(*): 34ms TotalReadThroughput: 3.9 MiB/s TotalTime: 83ms lab1ai-10.int.abc.com (9.49s) Go To Host Hdfs split stats (:<# splits>/): 11:1/124.54 MB 5:1/124.68 MB 7:1/124.76 MB AsyncTotalTime: 0ns AverageThreadTokens: 4.00 PeakMemoryUsage: 60.6 MiB PrepareTime: 70.23us RowsProduced: 10,918,885 TotalCpuTime: 30.25s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.59s TotalStorageWaitTime: 43ms TotalTime: 9.49s CodeGen (65ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 58ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 65ms DataStreamSender (dst_id=4) (9.39s) AsyncTotalTime: 0ns BytesSent: 90.1 MiB NetworkThroughput(*): 8.3 MiB/s OverallThroughput: 9.6 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 923ms ThriftTransmitTime(*): 10.89s TotalTime: 9.39s UncompressedRowBatchSize: 208.3 MiB HDFS_SCAN_NODE (id=1) (91ms) Hdfs split stats (:<# splits>/): 11:1/124.54 MB 5:1/124.68 MB 7:1/124.76 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 142ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 60.1 MiB PerReadThreadRawHdfsThroughput: 1.2 GiB/s RowsRead: 10,918,885 RowsReturned: 10,918,885 RowsReturnedRate: 119029276 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 27 ScannerThreadsTotalWallClockTime: 28.29s MaterializeTupleTime(*): 28.08s ScannerThreadsSysTime: 55ms ScannerThreadsUserTime: 706ms ScannerThreadsVoluntaryContextSwitches: 10,869 TotalRawHdfsReadTime(*): 33ms TotalReadThroughput: 4.2 MiB/s TotalTime: 91ms lab1ai-07.int.abc.com (9.49s) Go To Host Hdfs split stats (:<# splits>/): 5:1/124.39 MB 7:1/124.51 MB 8:1/124.59 MB AsyncTotalTime: 0ns AverageThreadTokens: 3.85 PeakMemoryUsage: 60.6 MiB PrepareTime: 44.66us RowsProduced: 10,916,416 TotalCpuTime: 30.37s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.55s TotalStorageWaitTime: 37ms TotalTime: 9.49s CodeGen (84ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 78ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 84ms DataStreamSender (dst_id=4) (9.39s) AsyncTotalTime: 0ns BytesSent: 90.3 MiB NetworkThroughput(*): 8.3 MiB/s OverallThroughput: 9.6 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 940ms ThriftTransmitTime(*): 10.89s TotalTime: 9.39s UncompressedRowBatchSize: 208.3 MiB HDFS_SCAN_NODE (id=1) (84ms) Hdfs split stats (:<# splits>/): 5:1/124.39 MB 7:1/124.51 MB 8:1/124.59 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 114ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 60.2 MiB PerReadThreadRawHdfsThroughput: 1.5 GiB/s RowsRead: 10,916,416 RowsReturned: 10,916,416 RowsReturnedRate: 129875774 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 21 ScannerThreadsTotalWallClockTime: 28.36s MaterializeTupleTime(*): 28.18s ScannerThreadsSysTime: 57ms ScannerThreadsUserTime: 657ms ScannerThreadsVoluntaryContextSwitches: 10,826 TotalRawHdfsReadTime(*): 26ms TotalReadThroughput: 4.0 MiB/s TotalTime: 84ms lab1ai-12.int.abc.com (9.45s) Go To Host Hdfs split stats (:<# splits>/): 6:1/124.68 MB 7:1/124.64 MB 10:1/124.38 MB AsyncTotalTime: 0ns AverageThreadTokens: 3.70 PeakMemoryUsage: 60.1 MiB PrepareTime: 53.49us RowsProduced: 10,914,173 TotalCpuTime: 29.99s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.56s TotalStorageWaitTime: 80ms TotalTime: 9.45s CodeGen (81ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 75ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 81ms DataStreamSender (dst_id=4) (9.35s) AsyncTotalTime: 0ns BytesSent: 90.1 MiB NetworkThroughput(*): 8.3 MiB/s OverallThroughput: 9.6 MiB/s PeakMemoryUsage: 524.0 KiB SerializeBatchTime: 893ms ThriftTransmitTime(*): 10.88s TotalTime: 9.35s UncompressedRowBatchSize: 208.2 MiB HDFS_SCAN_NODE (id=1) (84ms) Hdfs split stats (:<# splits>/): 6:1/124.68 MB 7:1/124.64 MB 10:1/124.38 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 2.84 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 126ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 59.7 MiB PerReadThreadRawHdfsThroughput: 1.6 GiB/s RowsRead: 10,914,173 RowsReturned: 10,914,173 RowsReturnedRate: 128478502 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 26 ScannerThreadsTotalWallClockTime: 28.08s MaterializeTupleTime(*): 27.84s ScannerThreadsSysTime: 73ms ScannerThreadsUserTime: 711ms ScannerThreadsVoluntaryContextSwitches: 10,789 TotalRawHdfsReadTime(*): 24ms TotalReadThroughput: 4.0 MiB/s TotalTime: 84ms lab1ai-17.int.abc.com (9.44s) Go To Host Hdfs split stats (:<# splits>/): 5:1/124.55 MB 7:1/124.44 MB 9:1/124.40 MB AsyncTotalTime: 0ns AverageThreadTokens: 3.84 PeakMemoryUsage: 60.6 MiB PrepareTime: 78.58us RowsProduced: 10,911,772 TotalCpuTime: 29.80s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.55s TotalStorageWaitTime: 46ms TotalTime: 9.44s CodeGen (76ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 70ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 76ms DataStreamSender (dst_id=4) (9.34s) AsyncTotalTime: 0ns BytesSent: 90.2 MiB NetworkThroughput(*): 8.3 MiB/s OverallThroughput: 9.7 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 890ms ThriftTransmitTime(*): 10.86s TotalTime: 9.34s UncompressedRowBatchSize: 208.2 MiB HDFS_SCAN_NODE (id=1) (86ms) Hdfs split stats (:<# splits>/): 5:1/124.55 MB 7:1/124.44 MB 9:1/124.40 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 130ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 60.1 MiB PerReadThreadRawHdfsThroughput: 1.1 GiB/s RowsRead: 10,911,772 RowsReturned: 10,911,772 RowsReturnedRate: 126749952 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 20 ScannerThreadsTotalWallClockTime: 27.85s MaterializeTupleTime(*): 27.64s ScannerThreadsSysTime: 65ms ScannerThreadsUserTime: 740ms ScannerThreadsVoluntaryContextSwitches: 10,753 TotalRawHdfsReadTime(*): 35ms TotalReadThroughput: 4.1 MiB/s TotalTime: 86ms lab1ai-09.int.abc.com (9.43s) Go To Host Hdfs split stats (:<# splits>/): 4:1/124.56 MB 5:1/124.48 MB 6:1/124.45 MB AsyncTotalTime: 0ns AverageThreadTokens: 3.95 PeakMemoryUsage: 60.6 MiB PrepareTime: 48.73us RowsProduced: 10,912,598 TotalCpuTime: 29.88s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.50s TotalStorageWaitTime: 37ms TotalTime: 9.43s CodeGen (66ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 60ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 66ms DataStreamSender (dst_id=4) (9.33s) AsyncTotalTime: 0ns BytesSent: 90.1 MiB NetworkThroughput(*): 8.3 MiB/s OverallThroughput: 9.7 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 912ms ThriftTransmitTime(*): 10.84s TotalTime: 9.33s UncompressedRowBatchSize: 208.2 MiB HDFS_SCAN_NODE (id=1) (85ms) Hdfs split stats (:<# splits>/): 4:1/124.56 MB 5:1/124.48 MB 6:1/124.45 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 2.95 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 135ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 60.1 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 10,912,598 RowsReturned: 10,912,598 RowsReturnedRate: 128141145 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 31 ScannerThreadsTotalWallClockTime: 27.89s MaterializeTupleTime(*): 27.69s ScannerThreadsSysTime: 59ms ScannerThreadsUserTime: 736ms ScannerThreadsVoluntaryContextSwitches: 10,792 TotalRawHdfsReadTime(*): 26ms TotalReadThroughput: 4.2 MiB/s TotalTime: 85ms lab1ai-16.int.abc.com (9.40s) Go To Host Hdfs split stats (:<# splits>/): 2:1/124.52 MB 3:1/124.60 MB 8:1/124.58 MB AsyncTotalTime: 0ns AverageThreadTokens: 4.00 PeakMemoryUsage: 60.5 MiB PrepareTime: 54.71us RowsProduced: 10,913,030 TotalCpuTime: 29.94s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.49s TotalStorageWaitTime: 42ms TotalTime: 9.40s CodeGen (83ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 77ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 83ms DataStreamSender (dst_id=4) (9.29s) AsyncTotalTime: 0ns BytesSent: 90.1 MiB NetworkThroughput(*): 8.3 MiB/s OverallThroughput: 9.7 MiB/s PeakMemoryUsage: 524.0 KiB SerializeBatchTime: 884ms ThriftTransmitTime(*): 10.80s TotalTime: 9.29s UncompressedRowBatchSize: 208.2 MiB HDFS_SCAN_NODE (id=1) (90ms) Hdfs split stats (:<# splits>/): 2:1/124.52 MB 3:1/124.60 MB 8:1/124.58 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 132ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 60.1 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 10,913,030 RowsReturned: 10,913,030 RowsReturnedRate: 120876784 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 24 ScannerThreadsTotalWallClockTime: 27.97s MaterializeTupleTime(*): 27.76s ScannerThreadsSysTime: 82ms ScannerThreadsUserTime: 811ms ScannerThreadsVoluntaryContextSwitches: 10,905 TotalRawHdfsReadTime(*): 27ms TotalReadThroughput: 4.2 MiB/s TotalTime: 90ms lab1ai-04.int.abc.com (9.39s) Go To Host Hdfs split stats (:<# splits>/): 1:1/124.54 MB 3:1/124.51 MB 5:1/124.53 MB AsyncTotalTime: 0ns AverageThreadTokens: 4.00 PeakMemoryUsage: 60.6 MiB PrepareTime: 47.36us RowsProduced: 10,916,488 TotalCpuTime: 29.73s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.45s TotalStorageWaitTime: 40ms TotalTime: 9.39s CodeGen (89ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 83ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 89ms DataStreamSender (dst_id=4) (9.28s) AsyncTotalTime: 0ns BytesSent: 90.2 MiB NetworkThroughput(*): 8.4 MiB/s OverallThroughput: 9.7 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 922ms ThriftTransmitTime(*): 10.78s TotalTime: 9.28s UncompressedRowBatchSize: 208.3 MiB HDFS_SCAN_NODE (id=1) (88ms) Hdfs split stats (:<# splits>/): 1:1/124.54 MB 3:1/124.51 MB 5:1/124.53 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 135ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 60.1 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 10,916,488 RowsReturned: 10,916,488 RowsReturnedRate: 123206325 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 25 ScannerThreadsTotalWallClockTime: 27.72s MaterializeTupleTime(*): 27.52s ScannerThreadsSysTime: 69ms ScannerThreadsUserTime: 723ms ScannerThreadsVoluntaryContextSwitches: 10,777 TotalRawHdfsReadTime(*): 27ms TotalReadThroughput: 4.1 MiB/s TotalTime: 88ms lab1ai-05.int.abc.com (9.34s) Go To Host Hdfs split stats (:<# splits>/): 11:1/124.62 MB 5:1/124.37 MB 8:1/124.57 MB AsyncTotalTime: 0ns AverageThreadTokens: 4.00 PeakMemoryUsage: 60.6 MiB PrepareTime: 83.05us RowsProduced: 10,912,386 TotalCpuTime: 29.68s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.46s TotalStorageWaitTime: 40ms TotalTime: 9.34s CodeGen (79ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 73ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 79ms DataStreamSender (dst_id=4) (9.24s) AsyncTotalTime: 0ns BytesSent: 90.2 MiB NetworkThroughput(*): 8.3 MiB/s OverallThroughput: 9.8 MiB/s PeakMemoryUsage: 524.0 KiB SerializeBatchTime: 864ms ThriftTransmitTime(*): 10.81s TotalTime: 9.24s UncompressedRowBatchSize: 208.2 MiB HDFS_SCAN_NODE (id=1) (90ms) Hdfs split stats (:<# splits>/): 11:1/124.62 MB 5:1/124.37 MB 8:1/124.57 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 137ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 60.1 MiB PerReadThreadRawHdfsThroughput: 1.3 GiB/s RowsRead: 10,912,386 RowsReturned: 10,912,386 RowsReturnedRate: 120441488 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 27 ScannerThreadsTotalWallClockTime: 27.72s MaterializeTupleTime(*): 27.52s ScannerThreadsSysTime: 75ms ScannerThreadsUserTime: 809ms ScannerThreadsVoluntaryContextSwitches: 10,781 TotalRawHdfsReadTime(*): 28ms TotalReadThroughput: 4.2 MiB/s TotalTime: 90ms lab1ai-15.int.abc.com (9.32s) Go To Host Hdfs split stats (:<# splits>/): 1:1/124.54 MB 3:1/124.44 MB 4:1/124.57 MB AsyncTotalTime: 0ns AverageThreadTokens: 3.84 PeakMemoryUsage: 59.6 MiB PrepareTime: 57.53us RowsProduced: 10,914,971 TotalCpuTime: 29.58s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.42s TotalStorageWaitTime: 39ms TotalTime: 9.32s CodeGen (70ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 64ms LoadTime: 5ms ModuleFileSize: 105.5 KiB TotalTime: 70ms DataStreamSender (dst_id=4) (9.22s) AsyncTotalTime: 0ns BytesSent: 90.0 MiB NetworkThroughput(*): 8.4 MiB/s OverallThroughput: 9.8 MiB/s PeakMemoryUsage: 524.0 KiB SerializeBatchTime: 861ms ThriftTransmitTime(*): 10.77s TotalTime: 9.22s UncompressedRowBatchSize: 208.2 MiB HDFS_SCAN_NODE (id=1) (81ms) Hdfs split stats (:<# splits>/): 1:1/124.54 MB 3:1/124.44 MB 4:1/124.57 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.7 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.7 MiB BytesReadShortCircuit: 39.7 MiB DecompressionTime: 153ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 59.1 MiB PerReadThreadRawHdfsThroughput: 1.2 GiB/s RowsRead: 10,914,971 RowsReturned: 10,914,971 RowsReturnedRate: 134477726 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 47 ScannerThreadsTotalWallClockTime: 27.63s MaterializeTupleTime(*): 27.41s ScannerThreadsSysTime: 65ms ScannerThreadsUserTime: 781ms ScannerThreadsVoluntaryContextSwitches: 10,736 TotalRawHdfsReadTime(*): 31ms TotalReadThroughput: 4.2 MiB/s TotalTime: 81ms lab1ai-18.int.abc.com (9.23s) Go To Host Hdfs split stats (:<# splits>/): 11:1/124.60 MB 1:1/124.56 MB 3:1/124.72 MB AsyncTotalTime: 0ns AverageThreadTokens: 4.00 PeakMemoryUsage: 59.6 MiB PrepareTime: 66.53us RowsProduced: 10,920,101 TotalCpuTime: 29.28s TotalNetworkReceiveTime: 0ns TotalNetworkSendTime: 7.33s TotalStorageWaitTime: 38ms TotalTime: 9.23s CodeGen (66ms) AsyncTotalTime: 0ns CodegenTime: 0ns CompileTime: 59ms LoadTime: 6ms ModuleFileSize: 105.5 KiB TotalTime: 66ms DataStreamSender (dst_id=4) (9.12s) AsyncTotalTime: 0ns BytesSent: 90.1 MiB NetworkThroughput(*): 8.4 MiB/s OverallThroughput: 9.9 MiB/s PeakMemoryUsage: 540.0 KiB SerializeBatchTime: 916ms ThriftTransmitTime(*): 10.68s TotalTime: 9.12s UncompressedRowBatchSize: 208.3 MiB HDFS_SCAN_NODE (id=1) (88ms) Hdfs split stats (:<# splits>/): 11:1/124.60 MB 1:1/124.56 MB 3:1/124.72 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 AsyncTotalTime: 0ns AverageHdfsReadThreadConcurrency: 0.00 AverageScannerThreadConcurrency: 3.00 BytesRead: 39.8 MiB BytesReadDataNodeCache: 0 B BytesReadLocal: 39.8 MiB BytesReadShortCircuit: 39.8 MiB DecompressionTime: 125ms NumColumns: 0 NumDisksAccessed: 3 NumScannerThreadsStarted: 3 PeakMemoryUsage: 59.1 MiB PerReadThreadRawHdfsThroughput: 1.4 GiB/s RowsRead: 10,920,101 RowsReturned: 10,920,101 RowsReturnedRate: 122844051 per second ScanRangesComplete: 3 ScannerThreadsInvoluntaryContextSwitches: 24 ScannerThreadsTotalWallClockTime: 27.33s MaterializeTupleTime(*): 27.14s ScannerThreadsSysTime: 56ms ScannerThreadsUserTime: 717ms ScannerThreadsVoluntaryContextSwitches: 10,844 TotalRawHdfsReadTime(*): 26ms TotalReadThroughput: 4.4 MiB/s TotalTime: 88ms Collapse All Averaged Fragment 4 lab1ai-13.int.abc.com lab1ai-11.int.abc.com lab1ai-08.int.abc.com lab1ai-06.int.abc.com lab1ai-14.int.abc.com lab1ai-10.int.abc.com lab1ai-07.int.abc.com lab1ai-12.int.abc.com lab1ai-17.int.abc.com lab1ai-09.int.abc.com lab1ai-16.int.abc.com lab1ai-04.int.abc.com lab1ai-05.int.abc.com lab1ai-15.int.abc.com lab1ai-18.int.abc.com