Query Details

select a.ric_cd, 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.ric_cd

Query Plan

----------------
Estimated Per-Host Requirements: Memory=3.11GB VCores=2

F04:PLAN FRAGMENT [PARTITION=UNPARTITIONED]
  08:EXCHANGE [PARTITION=UNPARTITIONED]
     hosts=15 per-host-mem=unavailable
     tuple-ids=2 row-size=24B cardinality=115569312

F03:PLAN FRAGMENT [PARTITION=HASH(a.ric_cd)]
  DATASTREAM SINK [FRAGMENT=F04, EXCHANGE=08, PARTITION=UNPARTITIONED]
  07:AGGREGATE [MERGE FINALIZE]
  |  output: sum(count(1))
  |  group by: a.ric_cd
  |  hosts=15 per-host-mem=193.98MB
  |  tuple-ids=2 row-size=24B cardinality=115569312
  |
  06:EXCHANGE [PARTITION=HASH(a.ric_cd)]
     hosts=15 per-host-mem=0B
     tuple-ids=2 row-size=24B cardinality=115569312

F02:PLAN FRAGMENT [PARTITION=HASH(a.asset_class_d_key)]
  DATASTREAM SINK [FRAGMENT=F03, EXCHANGE=06, PARTITION=HASH(a.ric_cd)]
  03:AGGREGATE
  |  output: count(1)
  |  group by: a.ric_cd
  |  hosts=15 per-host-mem=2.84GB
  |  tuple-ids=2 row-size=24B cardinality=115569312
  |
  02:HASH JOIN [INNER JOIN, PARTITIONED]
  |  hash predicates: a.asset_class_d_key = t.asset_class_d_key
  |  hosts=15 per-host-mem=99.73MB
  |  tuple-ids=0,1 row-size=44B cardinality=10365688394
  |
  |--05:EXCHANGE [PARTITION=HASH(t.asset_class_d_key)]
  |     hosts=15 per-host-mem=0B
  |     tuple-ids=1 row-size=8B cardinality=178256152
  |
  04:EXCHANGE [PARTITION=HASH(a.asset_class_d_key)]
     hosts=15 per-host-mem=0B
     tuple-ids=0 row-size=36B cardinality=114316426

F01:PLAN FRAGMENT [PARTITION=RANDOM]
  DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=05, 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

F00:PLAN FRAGMENT [PARTITION=RANDOM]
  DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=04, 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=176.00MB
     tuple-ids=0 row-size=36B cardinality=114316426
----------------

Query Info

    Query ID: d2457d7bdf573988:b971f5b19c6bc689
    User: steveo
    Database: default
    Coordinator: lab1ai-18.int.abc.com
    Query Type: QUERY
    Query State: FINISHED
    Start Time: Sep 24, 2014 9:43:00 AM
    End Time: Sep 24, 2014 9:46:42 AM
    Duration: 3m, 42s
    Rows Produced: 1,921,292
    Aggregate Peak Memory Usage: 2.9 GiB
    The highest amount of memory allocated by this query at a particular time across all nodes. Called "memory_aggregate_peak" in searches.
    Bytes Streamed: 5.3 GiB
    Client Fetch Wait Time: 57.32s
    Client Fetch Wait Time Percentage: 26
    Estimated per Node Peak Memory: 3.1 GiB
    File Formats: PARQUET/SNAPPY
    HDFS Average Scan Range: 37.2 MiB
    HDFS Bytes Read: 2.3 GiB
    HDFS Bytes Read From Cache: 2.3 GiB
    HDFS Bytes Read From Cache Percentage: 100
    HDFS Local Bytes Read: 2.3 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: 2.3 GiB
    HDFS Short Circuit Bytes Read Percentage: 100
    Memory Accrual: 9,681,555,370 byte seconds
    Network Address: 10.209.46.15:48085
    Node with Peak Memory Usage: lab1ai-18.int.abc.com:22000
    Per Node Peak Memory Usage: 2.9 GiB
    Planning Wait Time: 15ms
    Planning Wait Time Percentage: 0
    Pool: root.steveo
    Query Status: OK
    Session ID: f8451f2c5a0d482a:fe2d438cbb70ecbc
    Session Type: BEESWAX
    Stats Missing: false
    Threads: CPU Time: 1.1h
    Threads: CPU Time Percentage: 39
    Threads: Network Receive Wait Time: 59.3m
    Threads: Network Receive Wait Time Percentage: 37
    Threads: Network Send Wait Time: 39.9m
    Threads: Network Send Wait Time Percentage: 25
    Threads: Storage Wait Time: 1.35s
    Threads: Storage Wait Time Percentage: 0
    Threads: Total Time: 2.7h

Download Profile...

    Download Text Profile...
    Download Thrift Encoded Profile...

Query Timeline

    Start execution: 3ms (3ms)
    Planning finished: 18ms (15ms)
    Submit for admission: 23ms (4ms)
    Completed admission: 23ms (55.12us)
    Rows available: 2.7m (2.7m)
    First row fetched: 2.7m (769ms)
    Unregister query: 3.7m (58.18s)

Query Fragments

    Coordinator Fragment
    Fragment 1 (3.5m)
    Fragment 2 (2.7m)
    Fragment 3 (10.98s)
    Fragment 4 (2.6m)

        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 21.4 MiB
        PrepareTime: 27.00us
        RowsProduced: 1,921,292
        TotalCpuTime: 59.47s
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 0ns
        TotalStorageWaitTime: 0ns
        TotalTime: 2.7m
        CodeGen (69ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 63ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 69ms
        EXCHANGE_NODE (id=8) (2.7m)
            AsyncTotalTime: 0ns
            BytesReceived: 43.9 MiB
            ConvertRowBatchTime: 48ms
            DataArrivalWaitTime: 2.7m
            DeserializeRowBatchTimer: 164ms
            FirstBatchArrivalWaitTime: 2.7m
            PeakMemoryUsage: 21.3 MiB
            RowsReturned: 1,921,292
            RowsReturnedRate: 11805 per second
            SendersBlockedTimer: 44.15s
            SendersBlockedTotalTimer(*): 9.4m
            TotalTime: 2.7m

    Averaged Fragment 1
        split sizes: min: 0, max: 0, avg: 0, stddev: 0
        completion times: min:3m20s max:3m27s mean: 3m23s stddev:1s715ms
        execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
        num instances: 14
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,235
        TotalCpuTime: 208ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 40.34s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 100ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (40.26s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 79.6 KiB/s
            OverallThroughput: 79.9 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 42ms
            ThriftTransmitTime(*): 40.38s
            TotalTime: 40.26s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 35ms
            GetResultsTime: 13ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,235
            RowsReturnedRate: 841 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 309.1 KiB
                RowsReturned: 137,235
                RowsReturnedRate: 841 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-17.int.abc.com (3.5m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,630
        TotalCpuTime: 203ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 44.18s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.5m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 100ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (44.22s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 72.8 KiB/s
            OverallThroughput: 72.8 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 41ms
            ThriftTransmitTime(*): 44.22s
            TotalTime: 44.22s
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 32ms
            GetResultsTime: 12ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,630
            RowsReturnedRate: 844 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 16ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 280.4 KiB
                RowsReturned: 137,630
                RowsReturnedRate: 844 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-07.int.abc.com (3.5m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,224
        TotalCpuTime: 203ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 44.17s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.5m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 100ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (44.21s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 72.6 KiB/s
            OverallThroughput: 72.6 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 42ms
            ThriftTransmitTime(*): 44.21s
            TotalTime: 44.21s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 32ms
            GetResultsTime: 12ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,224
            RowsReturnedRate: 841 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 259.2 KiB
                RowsReturned: 137,224
                RowsReturnedRate: 841 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-09.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 1ms
        RowsProduced: 137,869
        TotalCpuTime: 211ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 40.43s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (106ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 100ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 106ms
        DataStreamSender (dst_id=8) (40.45s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 79.7 KiB/s
            OverallThroughput: 79.7 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 42ms
            ThriftTransmitTime(*): 40.47s
            TotalTime: 40.45s
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 38ms
            GetResultsTime: 15ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,869
            RowsReturnedRate: 845 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.2 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 305.8 KiB
                RowsReturned: 137,869
                RowsReturnedRate: 845 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-12.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,355
        TotalCpuTime: 205ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 40.34s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 100ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (40.38s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 79.6 KiB/s
            OverallThroughput: 79.6 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 41ms
            ThriftTransmitTime(*): 40.38s
            TotalTime: 40.38s
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 33ms
            GetResultsTime: 13ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,355
            RowsReturnedRate: 842 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 306.0 KiB
                RowsReturned: 137,355
                RowsReturnedRate: 842 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-15.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,011
        TotalCpuTime: 205ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 40.32s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (108ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 101ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 108ms
        DataStreamSender (dst_id=8) (40.30s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 79.4 KiB/s
            OverallThroughput: 79.5 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 41ms
            ThriftTransmitTime(*): 40.36s
            TotalTime: 40.30s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 33ms
            GetResultsTime: 13ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,011
            RowsReturnedRate: 840 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 305.9 KiB
                RowsReturned: 137,011
                RowsReturnedRate: 840 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-14.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,294
        TotalCpuTime: 205ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 40.25s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 101ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (40.29s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 79.7 KiB/s
            OverallThroughput: 79.7 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 41ms
            ThriftTransmitTime(*): 40.29s
            TotalTime: 40.29s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 34ms
            GetResultsTime: 13ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,294
            RowsReturnedRate: 842 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 16ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 305.5 KiB
                RowsReturned: 137,294
                RowsReturnedRate: 842 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-18.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,127
        TotalCpuTime: 215ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 40.30s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (108ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 101ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 108ms
        DataStreamSender (dst_id=8) (40.27s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 79.5 KiB/s
            OverallThroughput: 79.7 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 43ms
            ThriftTransmitTime(*): 40.34s
            TotalTime: 40.27s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 38ms
            GetResultsTime: 15ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,127
            RowsReturnedRate: 840 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 12ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 387.0 KiB
                RowsReturned: 137,127
                RowsReturnedRate: 841 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-11.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,427
        TotalCpuTime: 206ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 40.21s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 100ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (40.25s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 79.9 KiB/s
            OverallThroughput: 79.9 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 41ms
            ThriftTransmitTime(*): 40.25s
            TotalTime: 40.25s
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 34ms
            GetResultsTime: 12ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,427
            RowsReturnedRate: 842 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 280.2 KiB
                RowsReturned: 137,427
                RowsReturnedRate: 843 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-04.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,226
        TotalCpuTime: 208ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 39.14s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 100ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (39.18s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 82.0 KiB/s
            OverallThroughput: 82.0 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 43ms
            ThriftTransmitTime(*): 39.18s
            TotalTime: 39.18s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 34ms
            GetResultsTime: 13ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,226
            RowsReturnedRate: 841 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 280.1 KiB
                RowsReturned: 137,226
                RowsReturnedRate: 841 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-10.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,103
        TotalCpuTime: 207ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 40.15s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 2ms
            CompileTime: 101ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (39.17s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 79.8 KiB/s
            OverallThroughput: 81.9 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 41ms
            ThriftTransmitTime(*): 40.19s
            TotalTime: 39.17s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 34ms
            GetResultsTime: 13ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,103
            RowsReturnedRate: 840 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 305.9 KiB
                RowsReturned: 137,103
                RowsReturnedRate: 841 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-16.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 136,928
        TotalCpuTime: 212ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 39.16s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 100ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (39.06s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 81.7 KiB/s
            OverallThroughput: 82.0 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 43ms
            ThriftTransmitTime(*): 39.21s
            TotalTime: 39.06s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 38ms
            GetResultsTime: 14ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 136,928
            RowsReturnedRate: 839 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 14ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 368.8 KiB
                RowsReturned: 136,928
                RowsReturnedRate: 840 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-08.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 136,961
        TotalCpuTime: 211ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 39.15s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 101ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (39.05s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 81.8 KiB/s
            OverallThroughput: 82.1 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 43ms
            ThriftTransmitTime(*): 39.19s
            TotalTime: 39.05s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 38ms
            GetResultsTime: 13ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 136,961
            RowsReturnedRate: 840 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 3ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 15ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 279.9 KiB
                RowsReturned: 136,961
                RowsReturnedRate: 840 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-05.int.abc.com (3.4m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 136,989
        TotalCpuTime: 213ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 39.06s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.4m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 101ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (38.96s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 82.0 KiB/s
            OverallThroughput: 82.3 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 43ms
            ThriftTransmitTime(*): 39.10s
            TotalTime: 38.96s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 40ms
            GetResultsTime: 13ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 136,989
            RowsReturnedRate: 840 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 13ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 305.9 KiB
                RowsReturned: 136,989
                RowsReturnedRate: 840 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m
    lab1ai-06.int.abc.com (3.3m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.00
        PeakMemoryUsage: 13.6 MiB
        PrepareTime: 2ms
        RowsProduced: 137,148
        TotalCpuTime: 210ms
        TotalNetworkReceiveTime: 2.7m
        TotalNetworkSendTime: 37.89s
        TotalStorageWaitTime: 0ns
        TotalTime: 3.3m
        CodeGen (107ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 100ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 107ms
        DataStreamSender (dst_id=8) (37.78s)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 84.5 KiB/s
            OverallThroughput: 84.9 KiB/s
            PeakMemoryUsage: 4.0 KiB
            SerializeBatchTime: 42ms
            ThriftTransmitTime(*): 37.93s
            TotalTime: 37.78s
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=7) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 36ms
            GetResultsTime: 15ms
            LoadFactor: 0.65
            PeakMemoryUsage: 13.6 MiB
            RowsReturned: 137,148
            RowsReturnedRate: 841 per second
            TotalTime: 2.7m
            EXCHANGE_NODE (id=6) (2.7m)
                AsyncTotalTime: 0ns
                BytesReceived: 3.1 MiB
                ConvertRowBatchTime: 2ms
                DataArrivalWaitTime: 2.7m
                DeserializeRowBatchTimer: 14ms
                FirstBatchArrivalWaitTime: 2.6m
                PeakMemoryUsage: 356.4 KiB
                RowsReturned: 137,148
                RowsReturnedRate: 841 per second
                SendersBlockedTimer: 0ns
                SendersBlockedTotalTimer(*): 0ns
                TotalTime: 2.7m

Collapse All

    Averaged Fragment 1
    lab1ai-17.int.abc.com
    lab1ai-07.int.abc.com
    lab1ai-09.int.abc.com
    lab1ai-12.int.abc.com
    lab1ai-15.int.abc.com
    lab1ai-14.int.abc.com
    lab1ai-18.int.abc.com
    lab1ai-11.int.abc.com
    lab1ai-04.int.abc.com
    lab1ai-10.int.abc.com
    lab1ai-16.int.abc.com
    lab1ai-08.int.abc.com
    lab1ai-05.int.abc.com
    lab1ai-06.int.abc.com

    Averaged Fragment 2
        split sizes: min: 0, max: 0, avg: 0, stddev: 0
        completion times: min:2m37s max:2m42s mean: 2m37s stddev:1s362ms
        execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
        num instances: 14
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 601.0 MiB
        PrepareTime: 4ms
        RowsProduced: 137,235
        TotalCpuTime: 1.5m
        TotalNetworkReceiveTime: 1.3m
        TotalNetworkSendTime: 17ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (156ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 150ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 156ms
        DataStreamSender (dst_id=6) (76ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 35.1 MiB/s
            OverallThroughput: 47.8 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 35ms
            ThriftTransmitTime(*): 99ms
            TotalTime: 76ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 453ms
            GetResultsTime: 10ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.0 MiB
            RowsReturned: 137,235
            RowsReturnedRate: 868 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                AsyncTotalTime: 0ns
                BuildBuckets: 131,072
                BuildRows: 12,732,582
                BuildTime: 1.55s
                LeftChildRows: 8,165,459
                LeftChildTime: 1.3m
                LoadFactor: 0.65
                PeakMemoryUsage: 582.3 MiB
                RowsReturned: 12,732,582
                RowsReturnedRate: 80365 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.50s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 113.9 MiB
                    ConvertRowBatchTime: 228ms
                    DataArrivalWaitTime: 9.03s
                    DeserializeRowBatchTimer: 583ms
                    FirstBatchArrivalWaitTime: 96ms
                    PeakMemoryUsage: 8.5 MiB
                    RowsReturned: 12,732,582
                    RowsReturnedRate: 1986210 per second
                    SendersBlockedTimer: 688ms
                    SendersBlockedTotalTimer(*): 7.31s
                    TotalTime: 9.50s
                EXCHANGE_NODE (id=4) (1.2m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 268.9 MiB
                    ConvertRowBatchTime: 128ms
                    DataArrivalWaitTime: 1.2m
                    DeserializeRowBatchTimer: 1.04s
                    FirstBatchArrivalWaitTime: 175ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,165,459
                    RowsReturnedRate: 1239242 per second
                    SendersBlockedTimer: 21.25s
                    SendersBlockedTotalTimer(*): 4.2m
                    TotalTime: 1.2m
    lab1ai-18.int.abc.com (2.7m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 2.9 GiB
        PrepareTime: 4ms
        RowsProduced: 137,210
        TotalCpuTime: 2.9m
        TotalNetworkReceiveTime: 3.02s
        TotalNetworkSendTime: 4ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.7m
        CodeGen (158ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 151ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 158ms
        DataStreamSender (dst_id=6) (54ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 38.6 MiB/s
            OverallThroughput: 57.2 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 33ms
            ThriftTransmitTime(*): 81ms
            TotalTime: 54ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.7m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 1.73s
            GetResultsTime: 7ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.0 MiB
            RowsReturned: 137,210
            RowsReturnedRate: 842 per second
            TotalTime: 2.7m
            HASH_JOIN_NODE (id=2) (2.7m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.07s
                BuildBuckets: 131,072
                BuildRows: 61,407,612
                BuildTime: 7.19s
                LeftChildRows: 8,166,306
                LeftChildTime: 2.5m
                LoadFactor: 0.65
                PeakMemoryUsage: 2.9 GiB
                RowsReturned: 61,407,612
                RowsReturnedRate: 381389 per second
                TotalTime: 2.7m
                EXCHANGE_NODE (id=5) (3.82s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 414.7 MiB
                    ConvertRowBatchTime: 1.05s
                    DataArrivalWaitTime: 453ms
                    DeserializeRowBatchTimer: 2.74s
                    FirstBatchArrivalWaitTime: 91ms
                    PeakMemoryUsage: 39.9 MiB
                    RowsReturned: 61,407,612
                    RowsReturnedRate: 16050120 per second
                    SendersBlockedTimer: 9.64s
                    SendersBlockedTotalTimer(*): 1.7m
                    TotalTime: 3.82s
                EXCHANGE_NODE (id=4) (512ms)
                    AsyncTotalTime: 0ns
                    BytesReceived: 269.0 MiB
                    ConvertRowBatchTime: 128ms
                    DataArrivalWaitTime: 173ms
                    DeserializeRowBatchTimer: 1.19s
                    FirstBatchArrivalWaitTime: 173ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,166,306
                    RowsReturnedRate: 15933723 per second
                    SendersBlockedTimer: 2.6m
                    SendersBlockedTotalTimer(*): 29.3m
                    TotalTime: 512ms
    lab1ai-05.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 429.5 MiB
        PrepareTime: 4ms
        RowsProduced: 137,197
        TotalCpuTime: 1.5m
        TotalNetworkReceiveTime: 1.3m
        TotalNetworkSendTime: 203ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (157ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 151ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 157ms
        DataStreamSender (dst_id=6) (260ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 11.1 MiB/s
            OverallThroughput: 12.0 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 283ms
            TotalTime: 260ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 370ms
            GetResultsTime: 10ms
            LoadFactor: 0.65
            PeakMemoryUsage: 15.9 MiB
            RowsReturned: 137,197
            RowsReturnedRate: 871 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 9,656,934
                BuildTime: 1.08s
                LeftChildRows: 8,165,816
                LeftChildTime: 1.2m
                LoadFactor: 0.65
                PeakMemoryUsage: 411.5 MiB
                RowsReturned: 9,656,934
                RowsReturnedRate: 61472 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.98s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 96.3 MiB
                    ConvertRowBatchTime: 196ms
                    DataArrivalWaitTime: 9.68s
                    DeserializeRowBatchTimer: 436ms
                    FirstBatchArrivalWaitTime: 94ms
                    PeakMemoryUsage: 5.9 MiB
                    RowsReturned: 9,656,934
                    RowsReturnedRate: 967740 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.98s
                EXCHANGE_NODE (id=4) (1.2m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 269.0 MiB
                    ConvertRowBatchTime: 128ms
                    DataArrivalWaitTime: 1.2m
                    DeserializeRowBatchTimer: 925ms
                    FirstBatchArrivalWaitTime: 175ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,165,816
                    RowsReturnedRate: 114674 per second
                    SendersBlockedTimer: 10.92s
                    SendersBlockedTotalTimer(*): 2.5m
                    TotalTime: 1.2m
    lab1ai-04.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 416.4 MiB
        PrepareTime: 4ms
        RowsProduced: 136,821
        TotalCpuTime: 1.5m
        TotalNetworkReceiveTime: 1.3m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (155ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 149ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 155ms
        DataStreamSender (dst_id=6) (64ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 40.8 MiB/s
            OverallThroughput: 48.4 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 76ms
            TotalTime: 64ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 353ms
            GetResultsTime: 11ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.0 MiB
            RowsReturned: 136,821
            RowsReturnedRate: 868 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 8,804,493
                BuildTime: 1.02s
                LeftChildRows: 8,165,491
                LeftChildTime: 1.3m
                LoadFactor: 0.65
                PeakMemoryUsage: 398.5 MiB
                RowsReturned: 8,804,493
                RowsReturnedRate: 56032 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (10.04s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 89.1 MiB
                    ConvertRowBatchTime: 179ms
                    DataArrivalWaitTime: 9.77s
                    DeserializeRowBatchTimer: 412ms
                    FirstBatchArrivalWaitTime: 96ms
                    PeakMemoryUsage: 6.0 MiB
                    RowsReturned: 8,804,493
                    RowsReturnedRate: 877226 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 10.04s
                EXCHANGE_NODE (id=4) (1.1m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 269.0 MiB
                    ConvertRowBatchTime: 126ms
                    DataArrivalWaitTime: 1.1m
                    DeserializeRowBatchTimer: 1.10s
                    FirstBatchArrivalWaitTime: 177ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,165,491
                    RowsReturnedRate: 120695 per second
                    SendersBlockedTimer: 10.80s
                    SendersBlockedTotalTimer(*): 2.3m
                    TotalTime: 1.1m
    lab1ai-10.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 409.5 MiB
        PrepareTime: 4ms
        RowsProduced: 137,229
        TotalCpuTime: 1.2m
        TotalNetworkReceiveTime: 1.6m
        TotalNetworkSendTime: 2ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (156ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 150ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 156ms
        DataStreamSender (dst_id=6) (64ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 41.4 MiB/s
            OverallThroughput: 48.9 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 75ms
            TotalTime: 64ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 329ms
            GetResultsTime: 11ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.1 MiB
            RowsReturned: 137,229
            RowsReturnedRate: 871 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 8,353,392
                BuildTime: 1.11s
                LeftChildRows: 8,161,745
                LeftChildTime: 58.63s
                LoadFactor: 0.65
                PeakMemoryUsage: 391.6 MiB
                RowsReturned: 8,353,392
                RowsReturnedRate: 53154 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.96s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 85.5 MiB
                    ConvertRowBatchTime: 141ms
                    DataArrivalWaitTime: 9.74s
                    DeserializeRowBatchTimer: 401ms
                    FirstBatchArrivalWaitTime: 97ms
                    PeakMemoryUsage: 5.8 MiB
                    RowsReturned: 8,353,392
                    RowsReturnedRate: 838900 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.96s
                EXCHANGE_NODE (id=4) (1.5m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 268.8 MiB
                    ConvertRowBatchTime: 135ms
                    DataArrivalWaitTime: 1.5m
                    DeserializeRowBatchTimer: 1.09s
                    FirstBatchArrivalWaitTime: 176ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,161,745
                    RowsReturnedRate: 93167 per second
                    SendersBlockedTimer: 10.78s
                    SendersBlockedTotalTimer(*): 1.4m
                    TotalTime: 1.5m
    lab1ai-06.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 433.0 MiB
        PrepareTime: 4ms
        RowsProduced: 137,423
        TotalCpuTime: 1.5m
        TotalNetworkReceiveTime: 1.3m
        TotalNetworkSendTime: 2ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (154ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 148ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 154ms
        DataStreamSender (dst_id=6) (61ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 38.8 MiB/s
            OverallThroughput: 50.7 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 80ms
            TotalTime: 61ms
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 386ms
            GetResultsTime: 11ms
            LoadFactor: 0.65
            PeakMemoryUsage: 15.9 MiB
            RowsReturned: 137,423
            RowsReturnedRate: 872 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 9,899,179
                BuildTime: 1.30s
                LeftChildRows: 8,165,721
                LeftChildTime: 1.3m
                LoadFactor: 0.65
                PeakMemoryUsage: 415.2 MiB
                RowsReturned: 9,899,179
                RowsReturnedRate: 63016 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.77s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 98.8 MiB
                    ConvertRowBatchTime: 167ms
                    DataArrivalWaitTime: 9.51s
                    DeserializeRowBatchTimer: 458ms
                    FirstBatchArrivalWaitTime: 97ms
                    PeakMemoryUsage: 8.4 MiB
                    RowsReturned: 9,899,179
                    RowsReturnedRate: 1013451 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.77s
                EXCHANGE_NODE (id=4) (1.2m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 268.9 MiB
                    ConvertRowBatchTime: 132ms
                    DataArrivalWaitTime: 1.2m
                    DeserializeRowBatchTimer: 888ms
                    FirstBatchArrivalWaitTime: 175ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,165,721
                    RowsReturnedRate: 116448 per second
                    SendersBlockedTimer: 11.05s
                    SendersBlockedTotalTimer(*): 2.6m
                    TotalTime: 1.2m
    lab1ai-11.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 408.9 MiB
        PrepareTime: 4ms
        RowsProduced: 136,883
        TotalCpuTime: 1.4m
        TotalNetworkReceiveTime: 1.4m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (156ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 150ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 156ms
        DataStreamSender (dst_id=6) (63ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 38.1 MiB/s
            OverallThroughput: 49.5 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 82ms
            TotalTime: 63ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 341ms
            GetResultsTime: 11ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.0 MiB
            RowsReturned: 136,883
            RowsReturnedRate: 869 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 8,314,033
                BuildTime: 1.07s
                LeftChildRows: 8,163,479
                LeftChildTime: 1.2m
                LoadFactor: 0.65
                PeakMemoryUsage: 391.0 MiB
                RowsReturned: 8,314,033
                RowsReturnedRate: 52911 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.99s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 84.6 MiB
                    ConvertRowBatchTime: 161ms
                    DataArrivalWaitTime: 9.75s
                    DeserializeRowBatchTimer: 382ms
                    FirstBatchArrivalWaitTime: 98ms
                    PeakMemoryUsage: 4.3 MiB
                    RowsReturned: 8,314,033
                    RowsReturnedRate: 832358 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.99s
                EXCHANGE_NODE (id=4) (1.2m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 268.9 MiB
                    ConvertRowBatchTime: 122ms
                    DataArrivalWaitTime: 1.2m
                    DeserializeRowBatchTimer: 1.11s
                    FirstBatchArrivalWaitTime: 176ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,163,479
                    RowsReturnedRate: 111735 per second
                    SendersBlockedTimer: 10.84s
                    SendersBlockedTotalTimer(*): 2.0m
                    TotalTime: 1.2m
    lab1ai-12.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 412.3 MiB
        PrepareTime: 4ms
        RowsProduced: 137,586
        TotalCpuTime: 1.5m
        TotalNetworkReceiveTime: 1.4m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (155ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 148ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 155ms
        DataStreamSender (dst_id=6) (64ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 38.0 MiB/s
            OverallThroughput: 48.6 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 82ms
            TotalTime: 64ms
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 338ms
            GetResultsTime: 11ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.0 MiB
            RowsReturned: 137,586
            RowsReturnedRate: 873 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 8,536,440
                BuildTime: 1.16s
                LeftChildRows: 8,162,860
                LeftChildTime: 1.2m
                LoadFactor: 0.65
                PeakMemoryUsage: 394.4 MiB
                RowsReturned: 8,536,440
                RowsReturnedRate: 54327 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.91s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 86.9 MiB
                    ConvertRowBatchTime: 155ms
                    DataArrivalWaitTime: 9.68s
                    DeserializeRowBatchTimer: 410ms
                    FirstBatchArrivalWaitTime: 96ms
                    PeakMemoryUsage: 6.2 MiB
                    RowsReturned: 8,536,440
                    RowsReturnedRate: 861375 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.91s
                EXCHANGE_NODE (id=4) (1.2m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 268.9 MiB
                    ConvertRowBatchTime: 124ms
                    DataArrivalWaitTime: 1.2m
                    DeserializeRowBatchTimer: 1.10s
                    FirstBatchArrivalWaitTime: 175ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,162,860
                    RowsReturnedRate: 113522 per second
                    SendersBlockedTimer: 10.80s
                    SendersBlockedTotalTimer(*): 2.3m
                    TotalTime: 1.2m
    lab1ai-15.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 410.3 MiB
        PrepareTime: 4ms
        RowsProduced: 137,557
        TotalCpuTime: 1.3m
        TotalNetworkReceiveTime: 1.5m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (158ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 152ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 158ms
        DataStreamSender (dst_id=6) (64ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 37.1 MiB/s
            OverallThroughput: 48.8 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 84ms
            TotalTime: 64ms
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 330ms
            GetResultsTime: 11ms
            LoadFactor: 0.65
            PeakMemoryUsage: 15.9 MiB
            RowsReturned: 137,557
            RowsReturnedRate: 873 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.07s
                BuildBuckets: 131,072
                BuildRows: 8,395,986
                BuildTime: 1.13s
                LeftChildRows: 8,166,507
                LeftChildTime: 1.1m
                LoadFactor: 0.65
                PeakMemoryUsage: 392.2 MiB
                RowsReturned: 8,395,986
                RowsReturnedRate: 53431 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.93s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 85.9 MiB
                    ConvertRowBatchTime: 161ms
                    DataArrivalWaitTime: 9.69s
                    DeserializeRowBatchTimer: 416ms
                    FirstBatchArrivalWaitTime: 93ms
                    PeakMemoryUsage: 7.0 MiB
                    RowsReturned: 8,395,986
                    RowsReturnedRate: 845581 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.93s
                EXCHANGE_NODE (id=4) (1.3m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 269.0 MiB
                    ConvertRowBatchTime: 133ms
                    DataArrivalWaitTime: 1.3m
                    DeserializeRowBatchTimer: 1.11s
                    FirstBatchArrivalWaitTime: 171ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,166,507
                    RowsReturnedRate: 103454 per second
                    SendersBlockedTimer: 10.88s
                    SendersBlockedTotalTimer(*): 2.5m
                    TotalTime: 1.3m
    lab1ai-14.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 414.2 MiB
        PrepareTime: 4ms
        RowsProduced: 136,944
        TotalCpuTime: 1.3m
        TotalNetworkReceiveTime: 1.5m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (156ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 150ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 156ms
        DataStreamSender (dst_id=6) (62ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 34.7 MiB/s
            OverallThroughput: 49.8 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 36ms
            ThriftTransmitTime(*): 90ms
            TotalTime: 62ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 355ms
            GetResultsTime: 9ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.0 MiB
            RowsReturned: 136,944
            RowsReturnedRate: 869 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 8,661,509
                BuildTime: 1.05s
                LeftChildRows: 8,163,365
                LeftChildTime: 1.1m
                LoadFactor: 0.65
                PeakMemoryUsage: 396.3 MiB
                RowsReturned: 8,661,509
                RowsReturnedRate: 55130 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (10.01s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 88.2 MiB
                    ConvertRowBatchTime: 178ms
                    DataArrivalWaitTime: 9.74s
                    DeserializeRowBatchTimer: 419ms
                    FirstBatchArrivalWaitTime: 95ms
                    PeakMemoryUsage: 5.5 MiB
                    RowsReturned: 8,661,509
                    RowsReturnedRate: 865278 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 10.01s
                EXCHANGE_NODE (id=4) (1.4m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 268.9 MiB
                    ConvertRowBatchTime: 132ms
                    DataArrivalWaitTime: 1.4m
                    DeserializeRowBatchTimer: 1.09s
                    FirstBatchArrivalWaitTime: 175ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,163,365
                    RowsReturnedRate: 99892 per second
                    SendersBlockedTimer: 10.81s
                    SendersBlockedTotalTimer(*): 2.2m
                    TotalTime: 1.4m
    lab1ai-09.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 418.4 MiB
        PrepareTime: 4ms
        RowsProduced: 136,972
        TotalCpuTime: 1.5m
        TotalNetworkReceiveTime: 1.3m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (154ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 148ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 154ms
        DataStreamSender (dst_id=6) (60ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 35.3 MiB/s
            OverallThroughput: 52.0 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 88ms
            TotalTime: 60ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 351ms
            GetResultsTime: 8ms
            LoadFactor: 0.65
            PeakMemoryUsage: 15.9 MiB
            RowsReturned: 136,972
            RowsReturnedRate: 869 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 8,932,276
                BuildTime: 1.04s
                LeftChildRows: 8,162,710
                LeftChildTime: 1.3m
                LoadFactor: 0.65
                PeakMemoryUsage: 400.4 MiB
                RowsReturned: 8,932,276
                RowsReturnedRate: 56851 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (10.02s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 90.6 MiB
                    ConvertRowBatchTime: 168ms
                    DataArrivalWaitTime: 9.78s
                    DeserializeRowBatchTimer: 387ms
                    FirstBatchArrivalWaitTime: 97ms
                    PeakMemoryUsage: 4.9 MiB
                    RowsReturned: 8,932,276
                    RowsReturnedRate: 890947 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 10.02s
                EXCHANGE_NODE (id=4) (1.1m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 268.8 MiB
                    ConvertRowBatchTime: 118ms
                    DataArrivalWaitTime: 1.1m
                    DeserializeRowBatchTimer: 943ms
                    FirstBatchArrivalWaitTime: 175ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,162,710
                    RowsReturnedRate: 118765 per second
                    SendersBlockedTimer: 10.86s
                    SendersBlockedTotalTimer(*): 2.2m
                    TotalTime: 1.1m
    lab1ai-17.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 423.4 MiB
        PrepareTime: 4ms
        RowsProduced: 137,673
        TotalCpuTime: 1.5m
        TotalNetworkReceiveTime: 1.3m
        TotalNetworkSendTime: 4ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (154ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 148ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 154ms
        DataStreamSender (dst_id=6) (62ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 34.0 MiB/s
            OverallThroughput: 50.1 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 36ms
            ThriftTransmitTime(*): 92ms
            TotalTime: 62ms
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 373ms
            GetResultsTime: 9ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.0 MiB
            RowsReturned: 137,673
            RowsReturnedRate: 874 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 9,264,357
                BuildTime: 1.22s
                LeftChildRows: 8,170,143
                LeftChildTime: 1.3m
                LoadFactor: 0.65
                PeakMemoryUsage: 405.5 MiB
                RowsReturned: 9,264,357
                RowsReturnedRate: 58975 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.84s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 93.0 MiB
                    ConvertRowBatchTime: 154ms
                    DataArrivalWaitTime: 9.60s
                    DeserializeRowBatchTimer: 447ms
                    FirstBatchArrivalWaitTime: 97ms
                    PeakMemoryUsage: 6.3 MiB
                    RowsReturned: 9,264,357
                    RowsReturnedRate: 941492 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.84s
                EXCHANGE_NODE (id=4) (1.2m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 269.1 MiB
                    ConvertRowBatchTime: 127ms
                    DataArrivalWaitTime: 1.2m
                    DeserializeRowBatchTimer: 1.11s
                    FirstBatchArrivalWaitTime: 178ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,170,143
                    RowsReturnedRate: 117079 per second
                    SendersBlockedTimer: 10.81s
                    SendersBlockedTotalTimer(*): 2.3m
                    TotalTime: 1.2m
    lab1ai-08.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 418.2 MiB
        PrepareTime: 4ms
        RowsProduced: 137,490
        TotalCpuTime: 1.4m
        TotalNetworkReceiveTime: 1.4m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (156ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 149ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 156ms
        DataStreamSender (dst_id=6) (61ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 34.9 MiB/s
            OverallThroughput: 51.0 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 34ms
            ThriftTransmitTime(*): 90ms
            TotalTime: 61ms
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 347ms
            GetResultsTime: 8ms
            LoadFactor: 0.65
            PeakMemoryUsage: 15.9 MiB
            RowsReturned: 137,490
            RowsReturnedRate: 873 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 8,924,326
                BuildTime: 988ms
                LeftChildRows: 8,167,194
                LeftChildTime: 1.2m
                LoadFactor: 0.65
                PeakMemoryUsage: 400.3 MiB
                RowsReturned: 8,924,326
                RowsReturnedRate: 56801 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (10.08s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 89.5 MiB
                    ConvertRowBatchTime: 146ms
                    DataArrivalWaitTime: 9.85s
                    DeserializeRowBatchTimer: 393ms
                    FirstBatchArrivalWaitTime: 95ms
                    PeakMemoryUsage: 6.1 MiB
                    RowsReturned: 8,924,326
                    RowsReturnedRate: 885679 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 10.08s
                EXCHANGE_NODE (id=4) (1.2m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 269.0 MiB
                    ConvertRowBatchTime: 123ms
                    DataArrivalWaitTime: 1.2m
                    DeserializeRowBatchTimer: 867ms
                    FirstBatchArrivalWaitTime: 175ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,167,194
                    RowsReturnedRate: 113217 per second
                    SendersBlockedTimer: 11.06s
                    SendersBlockedTotalTimer(*): 2.5m
                    TotalTime: 1.2m
    lab1ai-07.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 420.0 MiB
        PrepareTime: 4ms
        RowsProduced: 136,742
        TotalCpuTime: 1.2m
        TotalNetworkReceiveTime: 1.7m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (155ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 149ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 155ms
        DataStreamSender (dst_id=6) (61ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 33.6 MiB/s
            OverallThroughput: 50.8 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 36ms
            ThriftTransmitTime(*): 93ms
            TotalTime: 61ms
            UncompressedRowBatchSize: 6.1 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 337ms
            GetResultsTime: 8ms
            LoadFactor: 0.65
            PeakMemoryUsage: 15.9 MiB
            RowsReturned: 136,742
            RowsReturnedRate: 868 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.08s
                BuildBuckets: 131,072
                BuildRows: 9,040,222
                BuildTime: 1.15s
                LeftChildRows: 8,170,955
                LeftChildTime: 56.20s
                LoadFactor: 0.65
                PeakMemoryUsage: 402.1 MiB
                RowsReturned: 9,040,222
                RowsReturnedRate: 57535 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.91s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 91.3 MiB
                    ConvertRowBatchTime: 153ms
                    DataArrivalWaitTime: 9.68s
                    DeserializeRowBatchTimer: 427ms
                    FirstBatchArrivalWaitTime: 98ms
                    PeakMemoryUsage: 5.6 MiB
                    RowsReturned: 9,040,222
                    RowsReturnedRate: 911904 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.91s
                EXCHANGE_NODE (id=4) (1.5m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 269.1 MiB
                    ConvertRowBatchTime: 135ms
                    DataArrivalWaitTime: 1.5m
                    DeserializeRowBatchTimer: 1.07s
                    FirstBatchArrivalWaitTime: 177ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,170,955
                    RowsReturnedRate: 90784 per second
                    SendersBlockedTimer: 10.85s
                    SendersBlockedTotalTimer(*): 2.3m
                    TotalTime: 1.5m
    lab1ai-16.int.abc.com (2.6m) Go To Host
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.07
        PeakMemoryUsage: 435.6 MiB
        PrepareTime: 4ms
        RowsProduced: 137,565
        TotalCpuTime: 1.3m
        TotalNetworkReceiveTime: 1.5m
        TotalNetworkSendTime: 3ms
        TotalStorageWaitTime: 0ns
        TotalTime: 2.6m
        CodeGen (156ms)
            AsyncTotalTime: 0ns
            CodegenTime: 1ms
            CompileTime: 150ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 156ms
        DataStreamSender (dst_id=6) (60ms)
            AsyncTotalTime: 0ns
            BytesSent: 3.1 MiB
            NetworkThroughput(*): 35.6 MiB/s
            OverallThroughput: 51.9 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 35ms
            ThriftTransmitTime(*): 88ms
            TotalTime: 60ms
            UncompressedRowBatchSize: 6.2 MiB
        AGGREGATION_NODE (id=3) (2.6m)
            ExecOption: Codegen Enabled
            AsyncTotalTime: 0ns
            BuildBuckets: 131,072
            BuildTime: 405ms
            GetResultsTime: 8ms
            LoadFactor: 0.65
            PeakMemoryUsage: 16.0 MiB
            RowsReturned: 137,565
            RowsReturnedRate: 873 per second
            TotalTime: 2.6m
            HASH_JOIN_NODE (id=2) (2.6m)
                ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously
                AsyncTotalTime: 11.07s
                BuildBuckets: 131,072
                BuildRows: 10,065,393
                BuildTime: 1.24s
                LeftChildRows: 8,164,134
                LeftChildTime: 1.1m
                LoadFactor: 0.65
                PeakMemoryUsage: 417.7 MiB
                RowsReturned: 10,065,393
                RowsReturnedRate: 64088 per second
                TotalTime: 2.6m
                EXCHANGE_NODE (id=5) (9.82s)
                    AsyncTotalTime: 0ns
                    BytesReceived: 99.7 MiB
                    ConvertRowBatchTime: 190ms
                    DataArrivalWaitTime: 9.53s
                    DeserializeRowBatchTimer: 442ms
                    FirstBatchArrivalWaitTime: 96ms
                    PeakMemoryUsage: 7.6 MiB
                    RowsReturned: 10,065,393
                    RowsReturnedRate: 1024896 per second
                    SendersBlockedTimer: 0ns
                    SendersBlockedTotalTimer(*): 0ns
                    TotalTime: 9.82s
                EXCHANGE_NODE (id=4) (1.3m)
                    AsyncTotalTime: 0ns
                    BytesReceived: 268.9 MiB
                    ConvertRowBatchTime: 125ms
                    DataArrivalWaitTime: 1.3m
                    DeserializeRowBatchTimer: 925ms
                    FirstBatchArrivalWaitTime: 176ms
                    PeakMemoryUsage: 17.7 MiB
                    RowsReturned: 8,164,134
                    RowsReturnedRate: 102237 per second
                    SendersBlockedTimer: 11.31s
                    SendersBlockedTotalTimer(*): 2.1m
                    TotalTime: 1.3m

Collapse All

    Averaged Fragment 2
    lab1ai-18.int.abc.com
    lab1ai-05.int.abc.com
    lab1ai-04.int.abc.com
    lab1ai-10.int.abc.com
    lab1ai-06.int.abc.com
    lab1ai-11.int.abc.com
    lab1ai-12.int.abc.com
    lab1ai-15.int.abc.com
    lab1ai-14.int.abc.com
    lab1ai-09.int.abc.com
    lab1ai-17.int.abc.com
    lab1ai-08.int.abc.com
    lab1ai-07.int.abc.com
    lab1ai-16.int.abc.com

    Averaged Fragment 3
        split sizes: min: 373.34 MB, max: 498.02 MB, avg: 406.75 MB, stddev: 54.97 MB
        completion times: min:8s119ms max:11s009ms mean: 9s390ms stddev:776.455ms
        execution rates: min:40.26 MB/sec max:56.03 MB/sec mean:43.27 MB/sec stddev:4.11 MB/sec
        num instances: 15
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.23
        PeakMemoryUsage: 65.2 MiB
        PrepareTime: 68.28us
        RowsProduced: 11,883,743
        TotalCpuTime: 32.76s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.29s
        TotalStorageWaitTime: 75ms
        TotalTime: 9.37s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (9.25s)
            AsyncTotalTime: 0ns
            BytesSent: 106.3 MiB
            NetworkThroughput(*): 9.6 MiB/s
            OverallThroughput: 11.5 MiB/s
            PeakMemoryUsage: 501.9 KiB
            SerializeBatchTime: 997ms
            ThriftTransmitTime(*): 11.02s
            TotalTime: 9.25s
            UncompressedRowBatchSize: 226.7 MiB
        HDFS_SCAN_NODE (id=1) (95ms)
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.01
            AverageScannerThreadConcurrency: 3.25
            BytesRead: 43.2 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 43.2 MiB
            BytesReadShortCircuit: 43.2 MiB
            DecompressionTime: 146ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 64.8 MiB
            PerReadThreadRawHdfsThroughput: 1.2 GiB/s
            RowsRead: 11,883,743
            RowsReturned: 11,883,743
            RowsReturnedRate: 124096214 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 39
            ScannerThreadsTotalWallClockTime: 30.68s
                MaterializeTupleTime(*): 30.43s
                ScannerThreadsSysTime: 116ms
                ScannerThreadsUserTime: 814ms
            ScannerThreadsVoluntaryContextSwitches: 11,856
            TotalRawHdfsReadTime(*): 34ms
            TotalReadThroughput: 4.5 MiB/s
            TotalTime: 95ms
    lab1ai-06.int.abc.com (10.98s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 4:1/124.54 MB 5:1/124.34 MB 6:1/124.39 MB 9:1/124.57 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 5.00
        PeakMemoryUsage: 78.5 MiB
        PrepareTime: 69.97us
        RowsProduced: 14,544,205
        TotalCpuTime: 46.33s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 8.41s
        TotalStorageWaitTime: 125ms
        TotalTime: 10.98s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (10.84s)
            AsyncTotalTime: 0ns
            BytesSent: 135.6 MiB
            NetworkThroughput(*): 10.5 MiB/s
            OverallThroughput: 12.5 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 1.26s
            ThriftTransmitTime(*): 12.86s
            TotalTime: 10.84s
            UncompressedRowBatchSize: 277.5 MiB
        HDFS_SCAN_NODE (id=1) (117ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 4.00
            BytesRead: 52.9 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 52.9 MiB
            BytesReadShortCircuit: 52.9 MiB
            DecompressionTime: 181ms
            NumColumns: 0
            NumDisksAccessed: 4
            NumScannerThreadsStarted: 4
            PeakMemoryUsage: 78.1 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 14,544,205
            RowsReturned: 14,544,205
            RowsReturnedRate: 123467180 per second
            ScanRangesComplete: 4
            ScannerThreadsInvoluntaryContextSwitches: 50
            ScannerThreadsTotalWallClockTime: 43.80s
                MaterializeTupleTime(*): 43.45s
                ScannerThreadsSysTime: 159ms
                ScannerThreadsUserTime: 1.08s
            ScannerThreadsVoluntaryContextSwitches: 14,594
            TotalRawHdfsReadTime(*): 36ms
            TotalReadThroughput: 4.5 MiB/s
            TotalTime: 117ms
    lab1ai-11.int.abc.com (10.73s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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.1 MiB
        PrepareTime: 71.77us
        RowsProduced: 14,549,452
        TotalCpuTime: 45.26s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 8.25s
        TotalStorageWaitTime: 84ms
        TotalTime: 10.73s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (10.60s)
            AsyncTotalTime: 0ns
            BytesSent: 128.8 MiB
            NetworkThroughput(*): 10.2 MiB/s
            OverallThroughput: 12.2 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 1.16s
            ThriftTransmitTime(*): 12.63s
            TotalTime: 10.60s
            UncompressedRowBatchSize: 277.6 MiB
        HDFS_SCAN_NODE (id=1) (106ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:95.45% 1:0% 2:0% 3:0% 4:4.545% 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.18
            AverageScannerThreadConcurrency: 4.00
            BytesRead: 52.9 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 52.9 MiB
            BytesReadShortCircuit: 52.9 MiB
            DecompressionTime: 187ms
            NumColumns: 0
            NumDisksAccessed: 4
            NumScannerThreadsStarted: 4
            PeakMemoryUsage: 77.7 MiB
            PerReadThreadRawHdfsThroughput: 1.2 GiB/s
            RowsRead: 14,549,452
            RowsReturned: 14,549,452
            RowsReturnedRate: 136134181 per second
            ScanRangesComplete: 4
            ScannerThreadsInvoluntaryContextSwitches: 45
            ScannerThreadsTotalWallClockTime: 42.78s
                MaterializeTupleTime(*): 42.48s
                ScannerThreadsSysTime: 141ms
                ScannerThreadsUserTime: 1.05s
            ScannerThreadsVoluntaryContextSwitches: 14,516
            TotalRawHdfsReadTime(*): 43ms
            TotalReadThroughput: 4.6 MiB/s
            TotalTime: 106ms
    lab1ai-08.int.abc.com (10.71s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/124.54 MB 11:1/124.46 MB 2:1/124.43 MB 7:1/124.60 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 5.00
        PeakMemoryUsage: 78.5 MiB
        PrepareTime: 67.46us
        RowsProduced: 14,550,948
        TotalCpuTime: 45.18s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 8.24s
        TotalStorageWaitTime: 110ms
        TotalTime: 10.71s
        CodeGen (63ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 57ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 63ms
        DataStreamSender (dst_id=5) (10.59s)
            AsyncTotalTime: 0ns
            BytesSent: 130.1 MiB
            NetworkThroughput(*): 10.2 MiB/s
            OverallThroughput: 12.3 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 1.18s
            ThriftTransmitTime(*): 12.69s
            TotalTime: 10.59s
            UncompressedRowBatchSize: 277.6 MiB
        HDFS_SCAN_NODE (id=1) (104ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 4.00
            BytesRead: 53.0 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 53.0 MiB
            BytesReadShortCircuit: 53.0 MiB
            DecompressionTime: 173ms
            NumColumns: 0
            NumDisksAccessed: 4
            NumScannerThreadsStarted: 4
            PeakMemoryUsage: 78.1 MiB
            PerReadThreadRawHdfsThroughput: 1.1 GiB/s
            RowsRead: 14,550,948
            RowsReturned: 14,550,948
            RowsReturnedRate: 139540345 per second
            ScanRangesComplete: 4
            ScannerThreadsInvoluntaryContextSwitches: 60
            ScannerThreadsTotalWallClockTime: 42.72s
                MaterializeTupleTime(*): 42.41s
                ScannerThreadsSysTime: 118ms
                ScannerThreadsUserTime: 984ms
            ScannerThreadsVoluntaryContextSwitches: 14,517
            TotalRawHdfsReadTime(*): 45ms
            TotalReadThroughput: 4.8 MiB/s
            TotalTime: 104ms
    lab1ai-15.int.abc.com (9.26s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 1:1/124.54 MB 3:1/124.44 MB 4:1/124.57 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 3.89
        PeakMemoryUsage: 60.1 MiB
        PrepareTime: 68.60us
        RowsProduced: 10,914,971
        TotalCpuTime: 29.64s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.25s
        TotalStorageWaitTime: 70ms
        TotalTime: 9.26s
        CodeGen (63ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 57ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 63ms
        DataStreamSender (dst_id=5) (9.15s)
            AsyncTotalTime: 0ns
            BytesSent: 100.1 MiB
            NetworkThroughput(*): 9.4 MiB/s
            OverallThroughput: 10.9 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 1.01s
            ThriftTransmitTime(*): 10.69s
            TotalTime: 9.15s
            UncompressedRowBatchSize: 208.2 MiB
        HDFS_SCAN_NODE (id=1) (91ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 2.89
            BytesRead: 39.7 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 39.7 MiB
            BytesReadShortCircuit: 39.7 MiB
            DecompressionTime: 133ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 59.7 MiB
            PerReadThreadRawHdfsThroughput: 1.0 GiB/s
            RowsRead: 10,914,971
            RowsReturned: 10,914,971
            RowsReturnedRate: 119576401 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 34
            ScannerThreadsTotalWallClockTime: 27.61s
                MaterializeTupleTime(*): 27.38s
                ScannerThreadsSysTime: 98ms
                ScannerThreadsUserTime: 723ms
            ScannerThreadsVoluntaryContextSwitches: 10,843
            TotalRawHdfsReadTime(*): 38ms
            TotalReadThroughput: 4.2 MiB/s
            TotalTime: 91ms
    lab1ai-16.int.abc.com (9.24s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 2:1/124.52 MB 3:1/124.60 MB 8:1/124.58 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 3.95
        PeakMemoryUsage: 59.6 MiB
        PrepareTime: 66.41us
        RowsProduced: 10,913,030
        TotalCpuTime: 29.48s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.29s
        TotalStorageWaitTime: 70ms
        TotalTime: 9.24s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (9.13s)
            AsyncTotalTime: 0ns
            BytesSent: 99.8 MiB
            NetworkThroughput(*): 9.0 MiB/s
            OverallThroughput: 10.9 MiB/s
            PeakMemoryUsage: 488.0 KiB
            SerializeBatchTime: 940ms
            ThriftTransmitTime(*): 11.11s
            TotalTime: 9.13s
            UncompressedRowBatchSize: 208.2 MiB
        HDFS_SCAN_NODE (id=1) (93ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 2.95
            BytesRead: 39.7 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 39.7 MiB
            BytesReadShortCircuit: 39.7 MiB
            DecompressionTime: 129ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 59.2 MiB
            PerReadThreadRawHdfsThroughput: 1.1 GiB/s
            RowsRead: 10,913,030
            RowsReturned: 10,913,030
            RowsReturnedRate: 116440568 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 41
            ScannerThreadsTotalWallClockTime: 27.52s
                MaterializeTupleTime(*): 27.30s
                ScannerThreadsSysTime: 113ms
                ScannerThreadsUserTime: 776ms
            ScannerThreadsVoluntaryContextSwitches: 10,770
            TotalRawHdfsReadTime(*): 35ms
            TotalReadThroughput: 4.2 MiB/s
            TotalTime: 93ms
    lab1ai-12.int.abc.com (9.22s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 6:1/124.68 MB 7:1/124.64 MB 10:1/124.38 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.00
        PeakMemoryUsage: 60.6 MiB
        PrepareTime: 56.04us
        RowsProduced: 10,914,173
        TotalCpuTime: 29.53s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.28s
        TotalStorageWaitTime: 66ms
        TotalTime: 9.22s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (9.12s)
            AsyncTotalTime: 0ns
            BytesSent: 100.5 MiB
            NetworkThroughput(*): 9.4 MiB/s
            OverallThroughput: 11.0 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 966ms
            ThriftTransmitTime(*): 10.66s
            TotalTime: 9.12s
            UncompressedRowBatchSize: 208.2 MiB
        HDFS_SCAN_NODE (id=1) (92ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 3.00
            BytesRead: 39.7 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 39.7 MiB
            BytesReadShortCircuit: 39.7 MiB
            DecompressionTime: 136ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.2 MiB
            PerReadThreadRawHdfsThroughput: 1.1 GiB/s
            RowsRead: 10,914,173
            RowsReturned: 10,914,173
            RowsReturnedRate: 117989280 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 29
            ScannerThreadsTotalWallClockTime: 27.58s
                MaterializeTupleTime(*): 27.34s
                ScannerThreadsSysTime: 88ms
                ScannerThreadsUserTime: 741ms
            ScannerThreadsVoluntaryContextSwitches: 10,908
            TotalRawHdfsReadTime(*): 34ms
            TotalReadThroughput: 4.2 MiB/s
            TotalTime: 92ms
    lab1ai-10.int.abc.com (9.22s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 11:1/124.54 MB 5:1/124.68 MB 7:1/124.76 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.00
        PeakMemoryUsage: 60.5 MiB
        PrepareTime: 65.48us
        RowsProduced: 10,918,885
        TotalCpuTime: 29.36s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.31s
        TotalStorageWaitTime: 73ms
        TotalTime: 9.22s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (9.10s)
            AsyncTotalTime: 0ns
            BytesSent: 100.6 MiB
            NetworkThroughput(*): 9.5 MiB/s
            OverallThroughput: 11.1 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 930ms
            ThriftTransmitTime(*): 10.62s
            TotalTime: 9.10s
            UncompressedRowBatchSize: 208.3 MiB
        HDFS_SCAN_NODE (id=1) (98ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 135ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.1 MiB
            PerReadThreadRawHdfsThroughput: 1.1 GiB/s
            RowsRead: 10,918,885
            RowsReturned: 10,918,885
            RowsReturnedRate: 110482316 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 34
            ScannerThreadsTotalWallClockTime: 27.44s
                MaterializeTupleTime(*): 27.20s
                ScannerThreadsSysTime: 108ms
                ScannerThreadsUserTime: 811ms
            ScannerThreadsVoluntaryContextSwitches: 10,862
            TotalRawHdfsReadTime(*): 35ms
            TotalReadThroughput: 4.2 MiB/s
            TotalTime: 98ms
    lab1ai-14.int.abc.com (9.18s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 2:1/124.48 MB 5:1/124.43 MB 8:1/124.43 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.00
        PeakMemoryUsage: 60.5 MiB
        PrepareTime: 70.41us
        RowsProduced: 10,911,465
        TotalCpuTime: 29.31s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.22s
        TotalStorageWaitTime: 64ms
        TotalTime: 9.18s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (9.07s)
            AsyncTotalTime: 0ns
            BytesSent: 98.5 MiB
            NetworkThroughput(*): 9.3 MiB/s
            OverallThroughput: 10.9 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 957ms
            ThriftTransmitTime(*): 10.64s
            TotalTime: 9.07s
            UncompressedRowBatchSize: 208.2 MiB
        HDFS_SCAN_NODE (id=1) (93ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 129ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.1 MiB
            PerReadThreadRawHdfsThroughput: 1.2 GiB/s
            RowsRead: 10,911,465
            RowsReturned: 10,911,465
            RowsReturnedRate: 116258263 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 25
            ScannerThreadsTotalWallClockTime: 27.33s
                MaterializeTupleTime(*): 27.11s
                ScannerThreadsSysTime: 117ms
                ScannerThreadsUserTime: 748ms
            ScannerThreadsVoluntaryContextSwitches: 10,947
            TotalRawHdfsReadTime(*): 31ms
            TotalReadThroughput: 4.2 MiB/s
            TotalTime: 93ms
    lab1ai-17.int.abc.com (9.16s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 5:1/124.55 MB 7:1/124.44 MB 9:1/124.40 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.00
        PeakMemoryUsage: 60.6 MiB
        PrepareTime: 69.83us
        RowsProduced: 10,911,772
        TotalCpuTime: 29.33s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.14s
        TotalStorageWaitTime: 60ms
        TotalTime: 9.16s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (9.06s)
            AsyncTotalTime: 0ns
            BytesSent: 100.1 MiB
            NetworkThroughput(*): 9.4 MiB/s
            OverallThroughput: 11.1 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 1.04s
            ThriftTransmitTime(*): 10.62s
            TotalTime: 9.06s
            UncompressedRowBatchSize: 208.2 MiB
        HDFS_SCAN_NODE (id=1) (91ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 128ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.1 MiB
            PerReadThreadRawHdfsThroughput: 1.2 GiB/s
            RowsRead: 10,911,772
            RowsReturned: 10,911,772
            RowsReturnedRate: 119400590 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 35
            ScannerThreadsTotalWallClockTime: 27.28s
                MaterializeTupleTime(*): 27.06s
                ScannerThreadsSysTime: 100ms
                ScannerThreadsUserTime: 658ms
            ScannerThreadsVoluntaryContextSwitches: 10,878
            TotalRawHdfsReadTime(*): 31ms
            TotalReadThroughput: 4.2 MiB/s
            TotalTime: 91ms
    lab1ai-09.int.abc.com (9.16s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 4:1/124.56 MB 5:1/124.48 MB 6:1/124.45 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.00
        PeakMemoryUsage: 60.6 MiB
        PrepareTime: 63.81us
        RowsProduced: 10,912,598
        TotalCpuTime: 29.25s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.26s
        TotalStorageWaitTime: 63ms
        TotalTime: 9.16s
        CodeGen (61ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 55ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 61ms
        DataStreamSender (dst_id=5) (9.06s)
            AsyncTotalTime: 0ns
            BytesSent: 100.5 MiB
            NetworkThroughput(*): 9.5 MiB/s
            OverallThroughput: 11.1 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 924ms
            ThriftTransmitTime(*): 10.59s
            TotalTime: 9.06s
            UncompressedRowBatchSize: 208.2 MiB
        HDFS_SCAN_NODE (id=1) (88ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 3.00
            BytesRead: 39.7 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 39.7 MiB
            BytesReadShortCircuit: 39.7 MiB
            DecompressionTime: 129ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.1 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 10,912,598
            RowsReturned: 10,912,598
            RowsReturnedRate: 123859861 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 23
            ScannerThreadsTotalWallClockTime: 27.32s
                MaterializeTupleTime(*): 27.11s
                ScannerThreadsSysTime: 96ms
                ScannerThreadsUserTime: 713ms
            ScannerThreadsVoluntaryContextSwitches: 10,890
            TotalRawHdfsReadTime(*): 27ms
            TotalReadThroughput: 4.1 MiB/s
            TotalTime: 88ms
    lab1ai-07.int.abc.com (9.00s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 5:1/124.39 MB 7:1/124.51 MB 8:1/124.59 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.00
        PeakMemoryUsage: 60.6 MiB
        PrepareTime: 69.50us
        RowsProduced: 10,916,416
        TotalCpuTime: 28.78s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.09s
        TotalStorageWaitTime: 68ms
        TotalTime: 9.00s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (8.89s)
            AsyncTotalTime: 0ns
            BytesSent: 98.0 MiB
            NetworkThroughput(*): 8.9 MiB/s
            OverallThroughput: 11.0 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 922ms
            ThriftTransmitTime(*): 11.03s
            TotalTime: 8.89s
            UncompressedRowBatchSize: 208.3 MiB
        HDFS_SCAN_NODE (id=1) (95ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 126ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.1 MiB
            PerReadThreadRawHdfsThroughput: 1.1 GiB/s
            RowsRead: 10,916,416
            RowsReturned: 10,916,416
            RowsReturnedRate: 114809546 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 25
            ScannerThreadsTotalWallClockTime: 26.85s
                MaterializeTupleTime(*): 26.63s
                ScannerThreadsSysTime: 126ms
                ScannerThreadsUserTime: 797ms
            ScannerThreadsVoluntaryContextSwitches: 10,903
            TotalRawHdfsReadTime(*): 35ms
            TotalReadThroughput: 4.4 MiB/s
            TotalTime: 95ms
    lab1ai-04.int.abc.com (8.90s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 1:1/124.54 MB 3:1/124.51 MB 5:1/124.53 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 3.89
        PeakMemoryUsage: 60.6 MiB
        PrepareTime: 59.08us
        RowsProduced: 10,916,488
        TotalCpuTime: 28.48s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 7.00s
        TotalStorageWaitTime: 55ms
        TotalTime: 8.90s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (8.80s)
            AsyncTotalTime: 0ns
            BytesSent: 97.5 MiB
            NetworkThroughput(*): 9.4 MiB/s
            OverallThroughput: 11.1 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 901ms
            ThriftTransmitTime(*): 10.32s
            TotalTime: 8.80s
            UncompressedRowBatchSize: 208.3 MiB
        HDFS_SCAN_NODE (id=1) (90ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 2.89
            BytesRead: 39.7 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 39.7 MiB
            BytesReadShortCircuit: 39.7 MiB
            DecompressionTime: 138ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.2 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 10,916,488
            RowsReturned: 10,916,488
            RowsReturnedRate: 120679433 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 57
            ScannerThreadsTotalWallClockTime: 26.54s
                MaterializeTupleTime(*): 26.33s
                ScannerThreadsSysTime: 123ms
                ScannerThreadsUserTime: 772ms
            ScannerThreadsVoluntaryContextSwitches: 10,909
            TotalRawHdfsReadTime(*): 27ms
            TotalReadThroughput: 4.4 MiB/s
            TotalTime: 90ms
    lab1ai-13.int.abc.com (8.86s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 11:1/124.51 MB 7:1/124.43 MB 8:1/124.60 MB 9:1/124.45 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.78
        PeakMemoryUsage: 78.5 MiB
        PrepareTime: 76.15us
        RowsProduced: 14,549,262
        TotalCpuTime: 37.57s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 6.58s
        TotalStorageWaitTime: 103ms
        TotalTime: 8.86s
        CodeGen (63ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 57ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 63ms
        DataStreamSender (dst_id=5) (8.76s)
            AsyncTotalTime: 0ns
            BytesSent: 117.0 MiB
            NetworkThroughput(*): 10.9 MiB/s
            OverallThroughput: 13.4 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 1.02s
            ThriftTransmitTime(*): 10.75s
            TotalTime: 8.76s
            UncompressedRowBatchSize: 277.6 MiB
        HDFS_SCAN_NODE (id=1) (85ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 204ms
            NumColumns: 0
            NumDisksAccessed: 4
            NumScannerThreadsStarted: 4
            PeakMemoryUsage: 78.1 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 14,549,262
            RowsReturned: 14,549,262
            RowsReturnedRate: 170258585 per second
            ScanRangesComplete: 4
            ScannerThreadsInvoluntaryContextSwitches: 29
            ScannerThreadsTotalWallClockTime: 35.30s
                MaterializeTupleTime(*): 34.95s
                ScannerThreadsSysTime: 77ms
                ScannerThreadsUserTime: 928ms
            ScannerThreadsVoluntaryContextSwitches: 14,408
            TotalRawHdfsReadTime(*): 37ms
            TotalReadThroughput: 5.6 MiB/s
            TotalTime: 85ms
    lab1ai-05.int.abc.com (8.79s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 11:1/124.62 MB 5:1/124.37 MB 8:1/124.57 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.00
        PeakMemoryUsage: 60.5 MiB
        PrepareTime: 71.46us
        RowsProduced: 10,912,386
        TotalCpuTime: 27.91s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 6.94s
        TotalStorageWaitTime: 59ms
        TotalTime: 8.79s
        CodeGen (62ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 62ms
        DataStreamSender (dst_id=5) (8.68s)
            AsyncTotalTime: 0ns
            BytesSent: 96.0 MiB
            NetworkThroughput(*): 9.4 MiB/s
            OverallThroughput: 11.1 MiB/s
            PeakMemoryUsage: 488.0 KiB
            SerializeBatchTime: 863ms
            ThriftTransmitTime(*): 10.27s
            TotalTime: 8.68s
            UncompressedRowBatchSize: 208.2 MiB
        HDFS_SCAN_NODE (id=1) (92ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 130ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.1 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 10,912,386
            RowsReturned: 10,912,386
            RowsReturnedRate: 118061764 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 35
            ScannerThreadsTotalWallClockTime: 26.02s
                MaterializeTupleTime(*): 25.80s
                ScannerThreadsSysTime: 111ms
                ScannerThreadsUserTime: 725ms
            ScannerThreadsVoluntaryContextSwitches: 10,876
            TotalRawHdfsReadTime(*): 28ms
            TotalReadThroughput: 4.7 MiB/s
            TotalTime: 92ms
    lab1ai-18.int.abc.com (8.09s) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 11:1/124.60 MB 1:1/124.56 MB 3:1/124.72 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 4.00
        PeakMemoryUsage: 60.6 MiB
        PrepareTime: 78.27us
        RowsProduced: 10,920,101
        TotalCpuTime: 26.06s
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 6.17s
        TotalStorageWaitTime: 57ms
        TotalTime: 8.09s
        CodeGen (63ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 56ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 63ms
        DataStreamSender (dst_id=5) (7.98s)
            AsyncTotalTime: 0ns
            BytesSent: 91.1 MiB
            NetworkThroughput(*): 9.3 MiB/s
            OverallThroughput: 11.4 MiB/s
            PeakMemoryUsage: 504.0 KiB
            SerializeBatchTime: 878ms
            ThriftTransmitTime(*): 9.80s
            TotalTime: 7.98s
            UncompressedRowBatchSize: 208.3 MiB
        HDFS_SCAN_NODE (id=1) (95ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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: 136ms
            NumColumns: 0
            NumDisksAccessed: 3
            NumScannerThreadsStarted: 3
            PeakMemoryUsage: 60.1 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 10,920,101
            RowsReturned: 10,920,101
            RowsReturnedRate: 114484908 per second
            ScanRangesComplete: 3
            ScannerThreadsInvoluntaryContextSwitches: 73
            ScannerThreadsTotalWallClockTime: 24.10s
                MaterializeTupleTime(*): 23.88s
                ScannerThreadsSysTime: 158ms
                ScannerThreadsUserTime: 708ms
            ScannerThreadsVoluntaryContextSwitches: 11,023
            TotalRawHdfsReadTime(*): 27ms
            TotalReadThroughput: 5.0 MiB/s
            TotalTime: 95ms

Collapse All

    Averaged Fragment 3
    lab1ai-06.int.abc.com
    lab1ai-11.int.abc.com
    lab1ai-08.int.abc.com
    lab1ai-15.int.abc.com
    lab1ai-16.int.abc.com
    lab1ai-12.int.abc.com
    lab1ai-10.int.abc.com
    lab1ai-14.int.abc.com
    lab1ai-17.int.abc.com
    lab1ai-09.int.abc.com
    lab1ai-07.int.abc.com
    lab1ai-04.int.abc.com
    lab1ai-13.int.abc.com
    lab1ai-05.int.abc.com
    lab1ai-18.int.abc.com

    Averaged Fragment 4
        split sizes: min: 53.25 MB, max: 218.76 MB, avg: 123.67 MB, stddev: 41.25 MB
        completion times: min:1m9s max:2m37s mean: 2m6s stddev:24s953ms
        execution rates: min:780.14 KB/sec max:1.39 MB/sec mean:973.23 KB/sec stddev:163.23 KB/sec
        num instances: 14
        AsyncTotalTime: 0ns
        AverageThreadTokens: 2.06
        PeakMemoryUsage: 91.2 MiB
        PrepareTime: 83.16us
        RowsProduced: 8,165,459
        TotalCpuTime: 2.3m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.1m
        TotalStorageWaitTime: 15ms
        TotalTime: 2.1m
        CodeGen (72ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 63ms
            LoadTime: 7ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 72ms
        DataStreamSender (dst_id=4) (2.1m)
            AsyncTotalTime: 0ns
            BytesSent: 268.9 MiB
            NetworkThroughput(*): 1.0 MiB/s
            OverallThroughput: 2.1 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 2.79s
            ThriftTransmitTime(*): 4.3m
            TotalTime: 2.1m
            UncompressedRowBatchSize: 372.9 MiB
        HDFS_SCAN_NODE (id=0) (81ms)
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 1.06
            BytesRead: 123.8 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 123.8 MiB
            BytesReadShortCircuit: 123.8 MiB
            DecompressionTime: 396ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 90.7 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 8,165,459
            RowsReturned: 8,165,459
            RowsReturnedRate: 98148843 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 61
            ScannerThreadsTotalWallClockTime: 2.3m
                MaterializeTupleTime(*): 2.3m
                ScannerThreadsSysTime: 43ms
                ScannerThreadsUserTime: 975ms
            ScannerThreadsVoluntaryContextSwitches: 7,146
            TotalRawHdfsReadTime(*): 86ms
            TotalReadThroughput: 974.7 KiB/s
            TotalTime: 81ms
    lab1ai-07.int.abc.com (2.6m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 11:1/106.23 MB 1:1/112.52 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 2.98
        PeakMemoryUsage: 166.6 MiB
        PrepareTime: 87.50us
        RowsProduced: 14,725,734
        TotalCpuTime: 5.3m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.5m
        TotalStorageWaitTime: 25ms
        TotalTime: 2.6m
        CodeGen (78ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 71ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 78ms
        DataStreamSender (dst_id=4) (2.6m)
            AsyncTotalTime: 0ns
            BytesSent: 494.2 MiB
            NetworkThroughput(*): 1.6 MiB/s
            OverallThroughput: 3.1 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 4.97s
            ThriftTransmitTime(*): 5.1m
            TotalTime: 2.6m
            UncompressedRowBatchSize: 668.8 MiB
        HDFS_SCAN_NODE (id=0) (134ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:4
            ExecOption: Codegen enabled: 0 out of 2
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 1.98
            BytesRead: 219.0 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 219.0 MiB
            BytesReadShortCircuit: 219.0 MiB
            DecompressionTime: 711ms
            NumColumns: 0
            NumDisksAccessed: 2
            NumScannerThreadsStarted: 2
            PeakMemoryUsage: 166.2 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 14,725,734
            RowsReturned: 14,725,734
            RowsReturnedRate: 109177902 per second
            ScanRangesComplete: 2
            ScannerThreadsInvoluntaryContextSwitches: 83
            ScannerThreadsTotalWallClockTime: 5.2m
                MaterializeTupleTime(*): 5.2m
                ScannerThreadsSysTime: 92ms
                ScannerThreadsUserTime: 1.82s
            ScannerThreadsVoluntaryContextSwitches: 14,299
            TotalRawHdfsReadTime(*): 148ms
            TotalReadThroughput: 1.4 MiB/s
            TotalTime: 134ms
    lab1ai-08.int.abc.com (2.5m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 3:1/158.23 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.99
        PeakMemoryUsage: 91.0 MiB
        PrepareTime: 108.89us
        RowsProduced: 10,746,509
        TotalCpuTime: 2.6m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.4m
        TotalStorageWaitTime: 13ms
        TotalTime: 2.5m
        CodeGen (68ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 58ms
            LoadTime: 8ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 68ms
        DataStreamSender (dst_id=4) (2.5m)
            AsyncTotalTime: 0ns
            BytesSent: 359.0 MiB
            NetworkThroughput(*): 1.3 MiB/s
            OverallThroughput: 2.4 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 3.55s
            ThriftTransmitTime(*): 4.6m
            TotalTime: 2.5m
            UncompressedRowBatchSize: 495.4 MiB
        HDFS_SCAN_NODE (id=0) (87ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.99
            BytesRead: 158.3 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 158.3 MiB
            BytesReadShortCircuit: 158.3 MiB
            DecompressionTime: 502ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 90.6 MiB
            PerReadThreadRawHdfsThroughput: 1.7 GiB/s
            RowsRead: 10,746,509
            RowsReturned: 10,746,509
            RowsReturnedRate: 122440138 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 73
            ScannerThreadsTotalWallClockTime: 2.5m
                MaterializeTupleTime(*): 2.5m
                ScannerThreadsSysTime: 53ms
                ScannerThreadsUserTime: 1.29s
            ScannerThreadsVoluntaryContextSwitches: 9,280
            TotalRawHdfsReadTime(*): 89ms
            TotalReadThroughput: 1.1 MiB/s
            TotalTime: 87ms
    lab1ai-09.int.abc.com (2.5m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 8:1/168.39 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.98
        PeakMemoryUsage: 91.1 MiB
        PrepareTime: 75.92us
        RowsProduced: 10,792,149
        TotalCpuTime: 2.5m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.4m
        TotalStorageWaitTime: 13ms
        TotalTime: 2.5m
        CodeGen (65ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 57ms
            LoadTime: 7ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 65ms
        DataStreamSender (dst_id=4) (2.5m)
            AsyncTotalTime: 0ns
            BytesSent: 369.9 MiB
            NetworkThroughput(*): 1.3 MiB/s
            OverallThroughput: 2.5 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 3.61s
            ThriftTransmitTime(*): 4.7m
            TotalTime: 2.5m
            UncompressedRowBatchSize: 495.8 MiB
        HDFS_SCAN_NODE (id=0) (94ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.98
            BytesRead: 168.5 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 168.5 MiB
            BytesReadShortCircuit: 168.5 MiB
            DecompressionTime: 475ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 90.7 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 10,792,149
            RowsReturned: 10,792,149
            RowsReturnedRate: 114099026 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 83
            ScannerThreadsTotalWallClockTime: 2.4m
                MaterializeTupleTime(*): 2.4m
                ScannerThreadsSysTime: 52ms
                ScannerThreadsUserTime: 1.08s
            ScannerThreadsVoluntaryContextSwitches: 9,594
            TotalRawHdfsReadTime(*): 118ms
            TotalReadThroughput: 1.1 MiB/s
            TotalTime: 94ms
    lab1ai-04.int.abc.com (2.4m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 9:1/144.91 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.99
        PeakMemoryUsage: 90.9 MiB
        PrepareTime: 59.67us
        RowsProduced: 9,843,842
        TotalCpuTime: 2.5m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.3m
        TotalStorageWaitTime: 14ms
        TotalTime: 2.4m
        CodeGen (67ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 58ms
            LoadTime: 8ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 67ms
        DataStreamSender (dst_id=4) (2.4m)
            AsyncTotalTime: 0ns
            BytesSent: 314.8 MiB
            NetworkThroughput(*): 1.3 MiB/s
            OverallThroughput: 2.2 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 3.55s
            ThriftTransmitTime(*): 4.0m
            TotalTime: 2.4m
            UncompressedRowBatchSize: 447.3 MiB
        HDFS_SCAN_NODE (id=0) (92ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.99
            BytesRead: 145.0 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 145.0 MiB
            BytesReadShortCircuit: 145.0 MiB
            DecompressionTime: 496ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 90.5 MiB
            PerReadThreadRawHdfsThroughput: 1.3 GiB/s
            RowsRead: 9,843,842
            RowsReturned: 9,843,842
            RowsReturnedRate: 106247175 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 59
            ScannerThreadsTotalWallClockTime: 2.4m
                MaterializeTupleTime(*): 2.4m
                ScannerThreadsSysTime: 56ms
                ScannerThreadsUserTime: 1.18s
            ScannerThreadsVoluntaryContextSwitches: 8,623
            TotalRawHdfsReadTime(*): 106ms
            TotalReadThroughput: 1.0 MiB/s
            TotalTime: 92ms
    lab1ai-11.int.abc.com (2.4m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/145.55 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.99
        PeakMemoryUsage: 90.9 MiB
        PrepareTime: 104.72us
        RowsProduced: 9,630,302
        TotalCpuTime: 2.4m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.3m
        TotalStorageWaitTime: 18ms
        TotalTime: 2.4m
        CodeGen (79ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 69ms
            LoadTime: 9ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 79ms
        DataStreamSender (dst_id=4) (2.4m)
            AsyncTotalTime: 0ns
            BytesSent: 314.6 MiB
            NetworkThroughput(*): 1.1 MiB/s
            OverallThroughput: 2.2 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 3.34s
            ThriftTransmitTime(*): 4.6m
            TotalTime: 2.4m
            UncompressedRowBatchSize: 438.1 MiB
        HDFS_SCAN_NODE (id=0) (98ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.99
            BytesRead: 145.6 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 145.6 MiB
            BytesReadShortCircuit: 145.6 MiB
            DecompressionTime: 430ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 90.5 MiB
            PerReadThreadRawHdfsThroughput: 1.2 GiB/s
            RowsRead: 9,630,302
            RowsReturned: 9,630,302
            RowsReturnedRate: 97549262 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 69
            ScannerThreadsTotalWallClockTime: 2.4m
                MaterializeTupleTime(*): 2.4m
                ScannerThreadsSysTime: 44ms
                ScannerThreadsUserTime: 1.09s
            ScannerThreadsVoluntaryContextSwitches: 8,498
            TotalRawHdfsReadTime(*): 114ms
            TotalReadThroughput: 1.0 MiB/s
            TotalTime: 98ms
    lab1ai-14.int.abc.com (2.2m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 3:1/119.68 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 2.00
        PeakMemoryUsage: 91.0 MiB
        PrepareTime: 102.48us
        RowsProduced: 7,695,841
        TotalCpuTime: 2.2m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.1m
        TotalStorageWaitTime: 11ms
        TotalTime: 2.2m
        CodeGen (67ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 57ms
            LoadTime: 9ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 67ms
        DataStreamSender (dst_id=4) (2.2m)
            AsyncTotalTime: 0ns
            BytesSent: 261.1 MiB
            NetworkThroughput(*): 1,009.7 KiB/s
            OverallThroughput: 2.0 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 2.67s
            ThriftTransmitTime(*): 4.4m
            TotalTime: 2.2m
            UncompressedRowBatchSize: 353.0 MiB
        HDFS_SCAN_NODE (id=0) (76ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 1.00
            BytesRead: 119.8 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 119.8 MiB
            BytesReadShortCircuit: 119.8 MiB
            DecompressionTime: 389ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 90.6 MiB
            PerReadThreadRawHdfsThroughput: 1.6 GiB/s
            RowsRead: 7,695,841
            RowsReturned: 7,695,841
            RowsReturnedRate: 99957209 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 57
            ScannerThreadsTotalWallClockTime: 2.2m
                MaterializeTupleTime(*): 2.2m
                ScannerThreadsSysTime: 36ms
                ScannerThreadsUserTime: 935ms
            ScannerThreadsVoluntaryContextSwitches: 6,698
            TotalRawHdfsReadTime(*): 73ms
            TotalReadThroughput: 939.8 KiB/s
            TotalTime: 76ms
    lab1ai-12.int.abc.com (2.2m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 6:1/119.21 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 2.00
        PeakMemoryUsage: 87.1 MiB
        PrepareTime: 77.55us
        RowsProduced: 7,594,835
        TotalCpuTime: 2.2m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.1m
        TotalStorageWaitTime: 13ms
        TotalTime: 2.2m
        CodeGen (66ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 58ms
            LoadTime: 7ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 66ms
        DataStreamSender (dst_id=4) (2.2m)
            AsyncTotalTime: 0ns
            BytesSent: 256.6 MiB
            NetworkThroughput(*): 955.3 KiB/s
            OverallThroughput: 2.0 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 2.56s
            ThriftTransmitTime(*): 4.6m
            TotalTime: 2.2m
            UncompressedRowBatchSize: 347.0 MiB
        HDFS_SCAN_NODE (id=0) (77ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 1.00
            BytesRead: 119.3 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 119.3 MiB
            BytesReadShortCircuit: 119.3 MiB
            DecompressionTime: 381ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 86.6 MiB
            PerReadThreadRawHdfsThroughput: 1.1 GiB/s
            RowsRead: 7,594,835
            RowsReturned: 7,594,835
            RowsReturnedRate: 98460955 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 61
            ScannerThreadsTotalWallClockTime: 2.2m
                MaterializeTupleTime(*): 2.2m
                ScannerThreadsSysTime: 33ms
                ScannerThreadsUserTime: 955ms
            ScannerThreadsVoluntaryContextSwitches: 6,341
            TotalRawHdfsReadTime(*): 105ms
            TotalReadThroughput: 939.8 KiB/s
            TotalTime: 77ms
    lab1ai-18.int.abc.com (2.2m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:1/115.22 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 2.00
        PeakMemoryUsage: 87.0 MiB
        PrepareTime: 81.50us
        RowsProduced: 7,298,700
        TotalCpuTime: 2.2m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.1m
        TotalStorageWaitTime: 13ms
        TotalTime: 2.2m
        CodeGen (69ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 61ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 69ms
        DataStreamSender (dst_id=4) (2.2m)
            AsyncTotalTime: 0ns
            BytesSent: 248.7 MiB
            NetworkThroughput(*): 967.1 KiB/s
            OverallThroughput: 1.9 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 2.57s
            ThriftTransmitTime(*): 4.4m
            TotalTime: 2.2m
            UncompressedRowBatchSize: 335.8 MiB
        HDFS_SCAN_NODE (id=0) (75ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 1.00
            BytesRead: 115.3 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 115.3 MiB
            BytesReadShortCircuit: 115.3 MiB
            DecompressionTime: 394ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 86.5 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 7,298,700
            RowsReturned: 7,298,700
            RowsReturnedRate: 97242751 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 68
            ScannerThreadsTotalWallClockTime: 2.1m
                MaterializeTupleTime(*): 2.1m
                ScannerThreadsSysTime: 38ms
                ScannerThreadsUserTime: 971ms
            ScannerThreadsVoluntaryContextSwitches: 6,333
            TotalRawHdfsReadTime(*): 79ms
            TotalReadThroughput: 911.8 KiB/s
            TotalTime: 75ms
    lab1ai-15.int.abc.com (2.1m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 1:1/108.71 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.98
        PeakMemoryUsage: 87.1 MiB
        PrepareTime: 86.62us
        RowsProduced: 7,295,611
        TotalCpuTime: 2.2m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.1m
        TotalStorageWaitTime: 18ms
        TotalTime: 2.1m
        CodeGen (86ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 76ms
            LoadTime: 9ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 86ms
        DataStreamSender (dst_id=4) (2.1m)
            AsyncTotalTime: 0ns
            BytesSent: 240.5 MiB
            NetworkThroughput(*): 978.1 KiB/s
            OverallThroughput: 1.9 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 2.64s
            ThriftTransmitTime(*): 4.2m
            TotalTime: 2.1m
            UncompressedRowBatchSize: 337.5 MiB
        HDFS_SCAN_NODE (id=0) (81ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 1:1/108.71 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 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.98
            BytesRead: 108.8 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 108.8 MiB
            BytesReadShortCircuit: 108.8 MiB
            DecompressionTime: 373ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 86.6 MiB
            PerReadThreadRawHdfsThroughput: 1.0 GiB/s
            RowsRead: 7,295,611
            RowsReturned: 7,295,611
            RowsReturnedRate: 89668503 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 64
            ScannerThreadsTotalWallClockTime: 2.1m
                MaterializeTupleTime(*): 2.1m
                ScannerThreadsSysTime: 45ms
                ScannerThreadsUserTime: 901ms
            ScannerThreadsVoluntaryContextSwitches: 6,222
            TotalRawHdfsReadTime(*): 101ms
            TotalReadThroughput: 863.7 KiB/s
            TotalTime: 81ms
    lab1ai-16.int.abc.com (2.1m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 10:1/101.78 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.98
        PeakMemoryUsage: 83.4 MiB
        PrepareTime: 82.16us
        RowsProduced: 6,866,119
        TotalCpuTime: 2.1m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.0m
        TotalStorageWaitTime: 14ms
        TotalTime: 2.1m
        CodeGen (70ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 63ms
            LoadTime: 6ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 70ms
        DataStreamSender (dst_id=4) (2.1m)
            AsyncTotalTime: 0ns
            BytesSent: 227.3 MiB
            NetworkThroughput(*): 865.7 KiB/s
            OverallThroughput: 1.8 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 2.55s
            ThriftTransmitTime(*): 4.5m
            TotalTime: 2.1m
            UncompressedRowBatchSize: 311.5 MiB
        HDFS_SCAN_NODE (id=0) (72ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.99
            BytesRead: 101.9 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 101.9 MiB
            BytesReadShortCircuit: 101.9 MiB
            DecompressionTime: 323ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 83.0 MiB
            PerReadThreadRawHdfsThroughput: 1.7 GiB/s
            RowsRead: 6,866,119
            RowsReturned: 6,866,119
            RowsReturnedRate: 94572350 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 69
            ScannerThreadsTotalWallClockTime: 2.0m
                MaterializeTupleTime(*): 2.0m
                ScannerThreadsSysTime: 37ms
                ScannerThreadsUserTime: 850ms
            ScannerThreadsVoluntaryContextSwitches: 5,896
            TotalRawHdfsReadTime(*): 59ms
            TotalReadThroughput: 844.7 KiB/s
            TotalTime: 72ms
    lab1ai-06.int.abc.com (2.1m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 7:1/109.36 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.99
        PeakMemoryUsage: 87.0 MiB
        PrepareTime: 59.55us
        RowsProduced: 7,236,761
        TotalCpuTime: 2.1m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.0m
        TotalStorageWaitTime: 14ms
        TotalTime: 2.1m
        CodeGen (64ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 57ms
            LoadTime: 5ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 64ms
        DataStreamSender (dst_id=4) (2.1m)
            AsyncTotalTime: 0ns
            BytesSent: 217.9 MiB
            NetworkThroughput(*): 947.5 KiB/s
            OverallThroughput: 1.8 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 2.33s
            ThriftTransmitTime(*): 3.9m
            TotalTime: 2.1m
            UncompressedRowBatchSize: 330.2 MiB
        HDFS_SCAN_NODE (id=0) (73ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.99
            BytesRead: 109.5 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 109.5 MiB
            BytesReadShortCircuit: 109.5 MiB
            DecompressionTime: 359ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 86.5 MiB
            PerReadThreadRawHdfsThroughput: 1.3 GiB/s
            RowsRead: 7,236,761
            RowsReturned: 7,236,761
            RowsReturnedRate: 99044272 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 63
            ScannerThreadsTotalWallClockTime: 2.0m
                MaterializeTupleTime(*): 2.0m
                ScannerThreadsSysTime: 39ms
                ScannerThreadsUserTime: 822ms
            ScannerThreadsVoluntaryContextSwitches: 6,203
            TotalRawHdfsReadTime(*): 80ms
            TotalReadThroughput: 907.6 KiB/s
            TotalTime: 73ms
    lab1ai-17.int.abc.com (2.1m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 5:1/112.02 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.99
        PeakMemoryUsage: 86.9 MiB
        PrepareTime: 84.80us
        RowsProduced: 7,268,553
        TotalCpuTime: 2.1m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 2.0m
        TotalStorageWaitTime: 13ms
        TotalTime: 2.1m
        CodeGen (67ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 59ms
            LoadTime: 7ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 67ms
        DataStreamSender (dst_id=4) (2.1m)
            AsyncTotalTime: 0ns
            BytesSent: 224.6 MiB
            NetworkThroughput(*): 894.6 KiB/s
            OverallThroughput: 1.8 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 2.30s
            ThriftTransmitTime(*): 4.3m
            TotalTime: 2.1m
            UncompressedRowBatchSize: 327.2 MiB
        HDFS_SCAN_NODE (id=0) (76ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.99
            BytesRead: 112.1 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 112.1 MiB
            BytesReadShortCircuit: 112.1 MiB
            DecompressionTime: 339ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 86.4 MiB
            PerReadThreadRawHdfsThroughput: 1.6 GiB/s
            RowsRead: 7,268,553
            RowsReturned: 7,268,553
            RowsReturnedRate: 94455768 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 59
            ScannerThreadsTotalWallClockTime: 2.0m
                MaterializeTupleTime(*): 2.0m
                ScannerThreadsSysTime: 44ms
                ScannerThreadsUserTime: 848ms
            ScannerThreadsVoluntaryContextSwitches: 6,033
            TotalRawHdfsReadTime(*): 68ms
            TotalReadThroughput: 933.4 KiB/s
            TotalTime: 76ms
    lab1ai-05.int.abc.com (1.2m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 3:1/56.26 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.99
        PeakMemoryUsage: 68.9 MiB
        PrepareTime: 75.32us
        RowsProduced: 3,847,921
        TotalCpuTime: 1.2m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 1.2m
        TotalStorageWaitTime: 16ms
        TotalTime: 1.2m
        CodeGen (68ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 58ms
            LoadTime: 8ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 68ms
        DataStreamSender (dst_id=4) (1.2m)
            AsyncTotalTime: 0ns
            BytesSent: 124.6 MiB
            NetworkThroughput(*): 622.3 KiB/s
            OverallThroughput: 1.7 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 1.27s
            ThriftTransmitTime(*): 3.4m
            TotalTime: 1.2m
            UncompressedRowBatchSize: 174.8 MiB
        HDFS_SCAN_NODE (id=0) (50ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.99
            BytesRead: 56.4 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 56.4 MiB
            BytesReadShortCircuit: 56.4 MiB
            DecompressionTime: 190ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 68.5 MiB
            PerReadThreadRawHdfsThroughput: 1.4 GiB/s
            RowsRead: 3,847,921
            RowsReturned: 3,847,921
            RowsReturnedRate: 76683454 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 26
            ScannerThreadsTotalWallClockTime: 1.2m
                MaterializeTupleTime(*): 1.2m
                ScannerThreadsSysTime: 17ms
                ScannerThreadsUserTime: 449ms
            ScannerThreadsVoluntaryContextSwitches: 3,278
            TotalRawHdfsReadTime(*): 39ms
            TotalReadThroughput: 790.6 KiB/s
            TotalTime: 50ms
    lab1ai-10.int.abc.com (1.2m) Go To Host
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 2:1/53.25 MB
        AsyncTotalTime: 0ns
        AverageThreadTokens: 1.98
        PeakMemoryUsage: 67.5 MiB
        PrepareTime: 77.54us
        RowsProduced: 3,473,549
        TotalCpuTime: 1.2m
        TotalNetworkReceiveTime: 0ns
        TotalNetworkSendTime: 1.1m
        TotalStorageWaitTime: 13ms
        TotalTime: 1.2m
        CodeGen (88ms)
            AsyncTotalTime: 0ns
            CodegenTime: 0ns
            CompileTime: 80ms
            LoadTime: 7ms
            ModuleFileSize: 105.5 KiB
            TotalTime: 88ms
        DataStreamSender (dst_id=4) (1.2m)
            AsyncTotalTime: 0ns
            BytesSent: 111.5 MiB
            NetworkThroughput(*): 597.4 KiB/s
            OverallThroughput: 1.6 MiB/s
            PeakMemoryUsage: 448.0 KiB
            SerializeBatchTime: 1.18s
            ThriftTransmitTime(*): 3.2m
            TotalTime: 1.2m
            UncompressedRowBatchSize: 158.8 MiB
        HDFS_SCAN_NODE (id=0) (46ms)
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): 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:2
            ExecOption: Codegen enabled: 0 out of 1
            AsyncTotalTime: 0ns
            AverageHdfsReadThreadConcurrency: 0.00
            AverageScannerThreadConcurrency: 0.99
            BytesRead: 53.3 MiB
            BytesReadDataNodeCache: 0 B
            BytesReadLocal: 53.3 MiB
            BytesReadShortCircuit: 53.3 MiB
            DecompressionTime: 178ms
            NumColumns: 0
            NumDisksAccessed: 1
            NumScannerThreadsStarted: 1
            PeakMemoryUsage: 67.0 MiB
            PerReadThreadRawHdfsThroughput: 1.8 GiB/s
            RowsRead: 3,473,549
            RowsReturned: 3,473,549
            RowsReturnedRate: 74485043 per second
            ScanRangesComplete: 1
            ScannerThreadsInvoluntaryContextSwitches: 23
            ScannerThreadsTotalWallClockTime: 1.1m
                MaterializeTupleTime(*): 1.1m
                ScannerThreadsSysTime: 16ms
                ScannerThreadsUserTime: 446ms
            ScannerThreadsVoluntaryContextSwitches: 2,754
            TotalRawHdfsReadTime(*): 29ms
            TotalReadThroughput: 780.4 KiB/s
            TotalTime: 46ms

Collapse All

    Averaged Fragment 4
    lab1ai-07.int.abc.com
    lab1ai-08.int.abc.com
    lab1ai-09.int.abc.com
    lab1ai-04.int.abc.com
    lab1ai-11.int.abc.com
    lab1ai-14.int.abc.com
    lab1ai-12.int.abc.com
    lab1ai-18.int.abc.com
    lab1ai-15.int.abc.com
    lab1ai-16.int.abc.com
    lab1ai-06.int.abc.com
    lab1ai-17.int.abc.com
    lab1ai-05.int.abc.com
    lab1ai-10.int.abc.com