Query (id=d5d61e90f4c24e69:9ced2cd10ed955d9):
   - PlanningTime: 10ms
  Query d5d61e90f4c24e69:9ced2cd10ed955d9:(549ms 0.00%)
    Aggregate Profile:
    Coordinator Fragment:(9s508ms 0.00%)
       - RowsProduced: 89
      CodeGen:
         - CodegenTime: 4ms
         - CompileTime: 153ms
         - LoadTime: 6ms
         - ModuleFileSize: 44.61 KB
      SORT_NODE (id=4):(9s508ms 0.00%)
         - MemoryUsed: 0.00 
         - RowsReturned: 89
         - RowsReturnedRate: 9.00 /sec
      AGGREGATION_NODE (id=7):(9s513ms 0.59%)
         - BuildBuckets: 1.02K
         - BuildTime: 141K clock cycles
         - GetResultsTime: 14K clock cycles
         - MemoryUsed: 48.38 KB
         - RowsReturned: 89
         - RowsReturnedRate: 9.00 /sec
      EXCHANGE_NODE (id=6):(9s457ms 99.46%)
         - BytesReceived: 16.73 KB
         - ConvertRowBatchTime: 11K clock cycles
         - DeserializeRowBatchTimer: 26K clock cycles
         - MemoryUsed: 0.00 
         - RowsReturned: 89
         - RowsReturnedRate: 9.00 /sec
    Averaged Fragment 2:(7s906ms 0.00%)
      completion times: min:7s620ms  max:9s495ms  mean: 8s056ms  stddev:653ms
      execution rates: min:342.95 MB/sec  max:436.42 MB/sec  mean:409.84 MB/sec  stddev:31.25 MB/sec
      split sizes:  min: 3.15 GB, max: 3.28 GB, avg: 3.20 GB, stddev: 40.16 MB
       - RowsProduced: 506
      CodeGen:
         - CodegenTime: 623K clock cycles
         - CompileTime: 74ms
         - LoadTime: 5ms
         - ModuleFileSize: 44.61 KB
      DataStreamSender:
         - BytesSent: 102.57 KB
         - DataSinkTime: 10ms
         - SerializeBatchTime: 2ms
         - ThriftTransmitTime: 125ms
      HDFS_SCAN_NODE (id=1):(7s906ms 100.00%)
         - BytesRead: 3.20 GB
         - DecompressionTime: 0K clock cycles
         - MaterializeTupleTime: 1m31s
         - MemoryUsed: 0.00 
         - PerDiskReadThroughput: 296.85 MB/sec
         - RowsReturned: 506
         - RowsReturnedRate: 63.00 /sec
         - ScanRangesComplete: 28
         - ScannerThreadsReadTime: 10s842ms
         - TotalReadThroughput: 403.62 MB/sec
    Averaged Fragment 1:(9s585ms 0.00%)
      completion times: min:9s581ms  max:9s594ms  mean: 9s585ms  stddev:5ms
      execution rates: min:0.00 /sec  max:1.26 KB/sec  mean:430.00 B/sec  stddev:608.00 B/sec
      split sizes:  min: 0.00 , max: 12.10 KB, avg: 4.03 KB, stddev: 5.71 KB
       - RowsProduced: 29
      CodeGen:
         - CodegenTime: 6ms
         - CompileTime: 276ms
         - LoadTime: 6ms
         - ModuleFileSize: 44.61 KB
      DataStreamSender:
         - BytesSent: 5.58 KB
         - DataSinkTime: 35K clock cycles
         - SerializeBatchTime: 18K clock cycles
         - ThriftTransmitTime: 375K clock cycles
      AGGREGATION_NODE (id=3):(9s589ms 0.45%)
         - BuildBuckets: 1.02K
         - BuildTime: 392K clock cycles
         - GetResultsTime: 5K clock cycles
         - MemoryUsed: 37.46 KB
         - RowsReturned: 29
         - RowsReturnedRate: 3.00 /sec
      HASH_JOIN_NODE (id=2):(9s548ms 0.36%)
         - BuildBuckets: 1.02K
         - BuildRows: 3.04K
         - BuildTime: 1ms
         - MemoryUsed: 0.00 
         - ProbeRows: 29
         - ProbeTime: 208K clock cycles
         - RowsReturned: 1.01K
         - RowsReturnedRate: 105.00 /sec
        EXCHANGE_NODE (id=5):(9s511ms 99.12%)
           - BytesReceived: 615.43 KB
           - ConvertRowBatchTime: 873K clock cycles
           - DeserializeRowBatchTimer: 3ms
           - MemoryUsed: 0.00 
           - RowsReturned: 3.04K
           - RowsReturnedRate: 305.00 /sec
      HDFS_SCAN_NODE (id=0):(3ms 0.12%)
         - BytesRead: 4.03 KB
         - DelimiterParseTime: 7K clock cycles
         - MaterializeTupleTime: 2K clock cycles
         - MemoryUsed: 0.00 
         - PerDiskReadThroughput: 386.12 MB/sec
         - RowsReturned: 29
         - RowsReturnedRate: 2.48 K/sec
         - ScanRangesComplete: 0
         - ScannerThreadsReadTime: 7K clock cycles
         - TotalReadThroughput: 0.00 /sec
    Fragment 1:
      Instance d5d61e90f4c24e69:9ced2cd10ed955db:(9s593ms 0.00%)
        Hdfs split stats (:<# splits>/): 0:1/12.39K 
         - RowsProduced: 89
        CodeGen:
           - CodegenTime: 6ms
           - CompileTime: 275ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 16.73 KB
           - DataSinkTime: 107K clock cycles
           - SerializeBatchTime: 54K clock cycles
           - ThriftTransmitTime: 1126K clock cycles
        AGGREGATION_NODE (id=3):(9s598ms 0.45%)
           - BuildBuckets: 1.02K
           - BuildTime: 1173K clock cycles
           - GetResultsTime: 14K clock cycles
           - MemoryUsed: 48.38 KB
           - RowsReturned: 89
           - RowsReturnedRate: 9.00 /sec
        HASH_JOIN_NODE (id=2):(9s555ms 0.36%)
           - BuildBuckets: 1.02K
           - BuildRows: 3.04K
           - BuildTime: 1ms
           - MemoryUsed: 0.00 
           - ProbeRows: 89
           - ProbeTime: 626K clock cycles
           - RowsReturned: 3.04K
           - RowsReturnedRate: 317.00 /sec
          EXCHANGE_NODE (id=5):(9s509ms 99.12%)
             - BytesReceived: 615.43 KB
             - ConvertRowBatchTime: 920K clock cycles
             - DeserializeRowBatchTimer: 5ms
             - MemoryUsed: 0.00 
             - RowsReturned: 3.04K
             - RowsReturnedRate: 319.00 /sec
        HDFS_SCAN_NODE (id=0):(11ms 0.12%)
          File Formats: TEXT/NONE:1 
           - BytesRead: 12.10 KB
           - DelimiterParseTime: 23K clock cycles
           - MaterializeTupleTime: 7K clock cycles
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 1.13 GB/sec
           - RowsReturned: 89
           - RowsReturnedRate: 7.46 K/sec
           - ScanRangesComplete: 1
           - ScannerThreadsReadTime: 21K clock cycles
           - TotalReadThroughput: 0.00 /sec
      Instance d5d61e90f4c24e69:9ced2cd10ed955dc:(9s581ms 0.00%)
         - RowsProduced: 0
        CodeGen:
           - CodegenTime: 5ms
           - CompileTime: 277ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 0.00 
           - DataSinkTime: 0K clock cycles
           - SerializeBatchTime: 0K clock cycles
           - ThriftTransmitTime: 0K clock cycles
        AGGREGATION_NODE (id=3):(9s585ms 0.42%)
           - BuildBuckets: 1.02K
           - BuildTime: 2K clock cycles
           - GetResultsTime: 1K clock cycles
           - MemoryUsed: 32.00 KB
           - RowsReturned: 0
           - RowsReturnedRate: 0
        HASH_JOIN_NODE (id=2):(9s545ms 0.34%)
           - BuildBuckets: 1.02K
           - BuildRows: 3.04K
           - BuildTime: 2061K clock cycles
           - MemoryUsed: 0.00 
           - ProbeRows: 0
           - ProbeTime: 0K clock cycles
           - RowsReturned: 0
           - RowsReturnedRate: 0
          EXCHANGE_NODE (id=5):(9s512ms 99.28%)
             - BytesReceived: 615.43 KB
             - ConvertRowBatchTime: 860K clock cycles
             - DeserializeRowBatchTimer: 2ms
             - MemoryUsed: 0.00 
             - RowsReturned: 3.04K
             - RowsReturnedRate: 299.00 /sec
        HDFS_SCAN_NODE (id=0):(4K clock cycles 0.00%)
           - BytesRead: 0.00 
           - MaterializeTupleTime: 0K clock cycles
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 0.00 /sec
           - RowsReturned: 0
           - RowsReturnedRate: 0
           - ScanRangesComplete: 0
           - ScannerThreadsReadTime: 0K clock cycles
           - TotalReadThroughput: 0.00 /sec
      Instance d5d61e90f4c24e69:9ced2cd10ed955dd:(9s581ms 0.00%)
         - RowsProduced: 0
        CodeGen:
           - CodegenTime: 5ms
           - CompileTime: 277ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 0.00 
           - DataSinkTime: 0K clock cycles
           - SerializeBatchTime: 0K clock cycles
           - ThriftTransmitTime: 0K clock cycles
        AGGREGATION_NODE (id=3):(9s585ms 0.42%)
           - BuildBuckets: 1.02K
           - BuildTime: 2K clock cycles
           - GetResultsTime: 0K clock cycles
           - MemoryUsed: 32.00 KB
           - RowsReturned: 0
           - RowsReturnedRate: 0
        HASH_JOIN_NODE (id=2):(9s545ms 0.35%)
           - BuildBuckets: 1.02K
           - BuildRows: 3.04K
           - BuildTime: 1ms
           - MemoryUsed: 0.00 
           - ProbeRows: 0
           - ProbeTime: 0K clock cycles
           - RowsReturned: 0
           - RowsReturnedRate: 0
          EXCHANGE_NODE (id=5):(9s511ms 99.27%)
             - BytesReceived: 615.43 KB
             - ConvertRowBatchTime: 838K clock cycles
             - DeserializeRowBatchTimer: 1ms
             - MemoryUsed: 0.00 
             - RowsReturned: 3.04K
             - RowsReturnedRate: 299.00 /sec
        HDFS_SCAN_NODE (id=0):(6K clock cycles 0.00%)
           - BytesRead: 0.00 
           - MaterializeTupleTime: 0K clock cycles
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 0.00 /sec
           - RowsReturned: 0
           - RowsReturnedRate: 0
           - ScanRangesComplete: 0
           - ScannerThreadsReadTime: 0K clock cycles
           - TotalReadThroughput: 0.00 /sec
    Fragment 2:
      Instance d5d61e90f4c24e69:9ced2cd10ed955de:(7s729ms 0.00%)
        Hdfs split stats (:<# splits>/): 0:4/404.22M 1:7/784.67M 2:4/404.18M 3:5/659.21M 4:2/268.44M 5:7/918.94M 
         - RowsProduced: 726
        CodeGen:
           - CodegenTime: 499K clock cycles
           - CompileTime: 73ms
           - LoadTime: 4ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 147.11 KB
           - DataSinkTime: 4ms
           - SerializeBatchTime: 2ms
           - ThriftTransmitTime: 165ms
        HDFS_SCAN_NODE (id=1):(7s729ms 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:29 
           - BytesRead: 3.20 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 1m29s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 297.05 MB/sec
           - RowsReturned: 726
           - RowsReturnedRate: 93.00 /sec
           - ScanRangesComplete: 29
           - ScannerThreadsReadTime: 11s043ms
           - TotalReadThroughput: 410.04 MB/sec
      Instance d5d61e90f4c24e69:9ced2cd10ed955df:(7s553ms 0.00%)
        Hdfs split stats (:<# splits>/): 0:5/565.62M 1:7/807.80M 2:3/394.81M 3:5/662.27M 4:3/297.92M 5:5/652.67M 
         - RowsProduced: 653
        CodeGen:
           - CodegenTime: 682K clock cycles
           - CompileTime: 76ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 133.80 KB
           - DataSinkTime: 9ms
           - SerializeBatchTime: 5ms
           - ThriftTransmitTime: 100ms
        HDFS_SCAN_NODE (id=1):(7s553ms 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:28 
           - BytesRead: 3.15 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 1m38s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 293.77 MB/sec
           - RowsReturned: 653
           - RowsReturnedRate: 86.00 /sec
           - ScanRangesComplete: 28
           - ScannerThreadsReadTime: 10s976ms
           - TotalReadThroughput: 429.93 MB/sec
      Instance d5d61e90f4c24e69:9ced2cd10ed955e0:(7s449ms 0.00%)
        Hdfs split stats (:<# splits>/): 0:6/576.90M 1:5/537.36M 2:5/647.36M 3:9/1.04B 4:5/658.76M 
         - RowsProduced: 506
        CodeGen:
           - CodegenTime: 503K clock cycles
           - CompileTime: 73ms
           - LoadTime: 4ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 100.89 KB
           - DataSinkTime: 30ms
           - SerializeBatchTime: 1410K clock cycles
           - ThriftTransmitTime: 195ms
        HDFS_SCAN_NODE (id=1):(7s449ms 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:30 
           - BytesRead: 3.22 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 1m30s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 288.02 MB/sec
           - RowsReturned: 506
           - RowsReturnedRate: 63.00 /sec
           - ScanRangesComplete: 30
           - ScannerThreadsReadTime: 10s748ms
           - TotalReadThroughput: 437.32 MB/sec
      Instance d5d61e90f4c24e69:9ced2cd10ed955e1:(7s518ms 0.00%)
        Hdfs split stats (:<# splits>/): 0:5/535.37M 1:3/257.52M 2:7/912.04M 3:4/524.27M 4:4/509.36M 5:6/778.70M 
         - RowsProduced: 371
        CodeGen:
           - CodegenTime: 689K clock cycles
           - CompileTime: 74ms
           - LoadTime: 5ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 74.27 KB
           - DataSinkTime: 1ms
           - SerializeBatchTime: 775K clock cycles
           - ThriftTransmitTime: 104ms
        HDFS_SCAN_NODE (id=1):(7s518ms 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:29 
           - BytesRead: 3.28 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 1m38s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 281.73 MB/sec
           - RowsReturned: 371
           - RowsReturnedRate: 46.00 /sec
           - ScanRangesComplete: 29
           - ScannerThreadsReadTime: 11s163ms
           - TotalReadThroughput: 419.29 MB/sec
      Instance d5d61e90f4c24e69:9ced2cd10ed955e2:(9s395ms 0.00%)
        Hdfs split stats (:<# splits>/): 0:8/912.14M 1:5/656.85M 2:9/1.19B 3:7/652.57M 
         - RowsProduced: 276
        CodeGen:
           - CodegenTime: 702K clock cycles
           - CompileTime: 76ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 55.98 KB
           - DataSinkTime: 1ms
           - SerializeBatchTime: 651K clock cycles
           - ThriftTransmitTime: 50ms
        HDFS_SCAN_NODE (id=1):(9s395ms 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:29 
           - BytesRead: 3.18 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 1m14s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 328.87 MB/sec
           - RowsReturned: 276
           - RowsReturnedRate: 29.00 /sec
           - ScanRangesComplete: 29
           - ScannerThreadsReadTime: 9s901ms
           - TotalReadThroughput: 340.24 MB/sec
      Instance d5d61e90f4c24e69:9ced2cd10ed955e3:(7s792ms 0.00%)
        Hdfs split stats (:<# splits>/): 0:6/671.13M 1:4/529.46M 2:5/526.14M 3:3/390.22M 4:7/929.80M 5:3/384.54M 
         - RowsProduced: 506
        CodeGen:
           - CodegenTime: 664K clock cycles
           - CompileTime: 73ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 103.36 KB
           - DataSinkTime: 16ms
           - SerializeBatchTime: 2ms
           - ThriftTransmitTime: 136ms
        HDFS_SCAN_NODE (id=1):(7s792ms 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:28 
           - BytesRead: 3.20 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 1m36s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 291.64 MB/sec
           - RowsReturned: 506
           - RowsReturnedRate: 64.00 /sec
           - ScanRangesComplete: 28
           - ScannerThreadsReadTime: 11s220ms
           - TotalReadThroughput: 384.89 MB/sec