Query (id=15749eb43c8a4a66:bae292109b2f6d14):
   - PlanningTime: 10ms
  Query 15749eb43c8a4a66:bae292109b2f6d14:(548ms 0.00%)
    Aggregate Profile:
    Coordinator Fragment:(1m32s 0.00%)
       - RowsProduced: 89
      CodeGen:
         - CodegenTime: 4ms
         - CompileTime: 157ms
         - LoadTime: 6ms
         - ModuleFileSize: 44.61 KB
      SORT_NODE (id=4):(1m32s 0.00%)
         - MemoryUsed: 0.00 
         - RowsReturned: 89
         - RowsReturnedRate: 0
      AGGREGATION_NODE (id=7):(1m32s 0.05%)
         - BuildBuckets: 1.02K
         - BuildTime: 111K clock cycles
         - GetResultsTime: 14K clock cycles
         - MemoryUsed: 48.38 KB
         - RowsReturned: 89
         - RowsReturnedRate: 0
      EXCHANGE_NODE (id=6):(1m32s 99.95%)
         - BytesReceived: 16.73 KB
         - ConvertRowBatchTime: 9K clock cycles
         - DeserializeRowBatchTimer: 37K clock cycles
         - MemoryUsed: 0.00 
         - RowsReturned: 89
         - RowsReturnedRate: 0
    Averaged Fragment 2:(1m27s 0.00%)
      completion times: min:1m19s  max:1m32s  mean: 1m28s  stddev:4s545ms
      execution rates: min:35.33 MB/sec  max:41.00 MB/sec  mean:37.37 MB/sec  stddev:1.90 MB/sec
      split sizes:  min: 3.15 GB, max: 3.28 GB, avg: 3.20 GB, stddev: 40.16 MB
       - RowsProduced: 506
      CodeGen:
         - CodegenTime: 345K clock cycles
         - CompileTime: 71ms
         - LoadTime: 5ms
         - ModuleFileSize: 44.61 KB
      DataStreamSender:
         - BytesSent: 102.57 KB
         - DataSinkTime: 1ms
         - SerializeBatchTime: 909K clock cycles
         - ThriftTransmitTime: 86ms
      HDFS_SCAN_NODE (id=1):(1m27s 100.00%)
         - BytesRead: 3.20 GB
         - DecompressionTime: 0K clock cycles
         - MaterializeTupleTime: 28m27s
         - MemoryUsed: 0.00 
         - PerDiskReadThroughput: 530.74 MB/sec
         - RowsReturned: 506
         - RowsReturnedRate: 5.00 /sec
         - ScanRangesComplete: 28
         - ScannerThreadsReadTime: 6s056ms
         - TotalReadThroughput: 37.35 MB/sec
    Averaged Fragment 1:(1m32s 0.00%)
      completion times: min:1m32s  max:1m32s  mean: 1m32s  stddev:5ms
      execution rates: min:0.00 /sec  max:133.00 B/sec  mean:44.00 B/sec  stddev:62.00 B/sec
      split sizes:  min: 0.00 , max: 12.10 KB, avg: 4.03 KB, stddev: 5.71 KB
       - RowsProduced: 29
      CodeGen:
         - CodegenTime: 5ms
         - CompileTime: 277ms
         - LoadTime: 6ms
         - ModuleFileSize: 44.61 KB
      DataStreamSender:
         - BytesSent: 5.58 KB
         - DataSinkTime: 49K clock cycles
         - SerializeBatchTime: 26K clock cycles
         - ThriftTransmitTime: 195K clock cycles
      AGGREGATION_NODE (id=3):(1m32s 0.05%)
         - BuildBuckets: 1.02K
         - BuildTime: 575K clock cycles
         - GetResultsTime: 8K clock cycles
         - MemoryUsed: 37.46 KB
         - RowsReturned: 29
         - RowsReturnedRate: 0
      HASH_JOIN_NODE (id=2):(1m32s 0.04%)
         - BuildBuckets: 1.02K
         - BuildRows: 3.04K
         - BuildTime: 1691K clock cycles
         - MemoryUsed: 0.00 
         - ProbeRows: 29
         - ProbeTime: 260K clock cycles
         - RowsReturned: 1.01K
         - RowsReturnedRate: 10.00 /sec
        EXCHANGE_NODE (id=5):(1m32s 99.91%)
           - BytesReceived: 615.43 KB
           - ConvertRowBatchTime: 679K clock cycles
           - DeserializeRowBatchTimer: 1852K clock cycles
           - MemoryUsed: 0.00 
           - RowsReturned: 3.04K
           - RowsReturnedRate: 30.00 /sec
      HDFS_SCAN_NODE (id=0):(3ms 0.01%)
         - BytesRead: 4.03 KB
         - DelimiterParseTime: 8K clock cycles
         - MaterializeTupleTime: 2K clock cycles
         - MemoryUsed: 0.00 
         - PerDiskReadThroughput: 366.61 MB/sec
         - RowsReturned: 29
         - RowsReturnedRate: 2.57 K/sec
         - ScanRangesComplete: 0
         - ScannerThreadsReadTime: 7K clock cycles
         - TotalReadThroughput: 0.00 /sec
    Fragment 1:
      Instance 15749eb43c8a4a66:bae292109b2f6d16:(1m32s 0.00%)
        Hdfs split stats (:<# splits>/): 0:1/12.39K 
         - RowsProduced: 89
        CodeGen:
           - CodegenTime: 5ms
           - CompileTime: 279ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 16.73 KB
           - DataSinkTime: 149K clock cycles
           - SerializeBatchTime: 78K clock cycles
           - ThriftTransmitTime: 587K clock cycles
        AGGREGATION_NODE (id=3):(1m32s 0.05%)
           - BuildBuckets: 1.02K
           - BuildTime: 1722K clock cycles
           - GetResultsTime: 23K clock cycles
           - MemoryUsed: 48.38 KB
           - RowsReturned: 89
           - RowsReturnedRate: 0
        HASH_JOIN_NODE (id=2):(1m32s 0.04%)
           - BuildBuckets: 1.02K
           - BuildRows: 3.04K
           - BuildTime: 1458K clock cycles
           - MemoryUsed: 0.00 
           - ProbeRows: 89
           - ProbeTime: 780K clock cycles
           - RowsReturned: 3.04K
           - RowsReturnedRate: 32.00 /sec
          EXCHANGE_NODE (id=5):(1m32s 99.91%)
             - BytesReceived: 615.43 KB
             - ConvertRowBatchTime: 663K clock cycles
             - DeserializeRowBatchTimer: 1884K clock cycles
             - MemoryUsed: 0.00 
             - RowsReturned: 3.04K
             - RowsReturnedRate: 32.00 /sec
        HDFS_SCAN_NODE (id=0):(11ms 0.01%)
          File Formats: TEXT/NONE:1 
           - BytesRead: 12.10 KB
           - DelimiterParseTime: 25K clock cycles
           - MaterializeTupleTime: 6K clock cycles
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 1.07 GB/sec
           - RowsReturned: 89
           - RowsReturnedRate: 7.70 K/sec
           - ScanRangesComplete: 1
           - ScannerThreadsReadTime: 22K clock cycles
           - TotalReadThroughput: 0.00 /sec
      Instance 15749eb43c8a4a66:bae292109b2f6d17:(1m32s 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):(1m32s 0.05%)
           - BuildBuckets: 1.02K
           - BuildTime: 2K clock cycles
           - GetResultsTime: 0K clock cycles
           - MemoryUsed: 32.00 KB
           - RowsReturned: 0
           - RowsReturnedRate: 0
        HASH_JOIN_NODE (id=2):(1m32s 0.04%)
           - BuildBuckets: 1.02K
           - BuildRows: 3.04K
           - BuildTime: 1800K clock cycles
           - MemoryUsed: 0.00 
           - ProbeRows: 0
           - ProbeTime: 0K clock cycles
           - RowsReturned: 0
           - RowsReturnedRate: 0
          EXCHANGE_NODE (id=5):(1m32s 99.92%)
             - BytesReceived: 615.43 KB
             - ConvertRowBatchTime: 696K clock cycles
             - DeserializeRowBatchTimer: 1800K clock cycles
             - MemoryUsed: 0.00 
             - RowsReturned: 3.04K
             - RowsReturnedRate: 30.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
      Instance 15749eb43c8a4a66:bae292109b2f6d18:(1m32s 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):(1m32s 0.04%)
           - BuildBuckets: 1.02K
           - BuildTime: 1K clock cycles
           - GetResultsTime: 0K clock cycles
           - MemoryUsed: 32.00 KB
           - RowsReturned: 0
           - RowsReturnedRate: 0
        HASH_JOIN_NODE (id=2):(1m32s 0.04%)
           - BuildBuckets: 1.02K
           - BuildRows: 3.04K
           - BuildTime: 1816K clock cycles
           - MemoryUsed: 0.00 
           - ProbeRows: 0
           - ProbeTime: 0K clock cycles
           - RowsReturned: 0
           - RowsReturnedRate: 0
          EXCHANGE_NODE (id=5):(1m32s 99.92%)
             - BytesReceived: 615.43 KB
             - ConvertRowBatchTime: 679K clock cycles
             - DeserializeRowBatchTimer: 1873K clock cycles
             - MemoryUsed: 0.00 
             - RowsReturned: 3.04K
             - RowsReturnedRate: 30.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
    Fragment 2:
      Instance 15749eb43c8a4a66:bae292109b2f6d19:(1m25s 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: 298K clock cycles
           - CompileTime: 73ms
           - LoadTime: 5ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 147.11 KB
           - DataSinkTime: 2ms
           - SerializeBatchTime: 1312K clock cycles
           - ThriftTransmitTime: 102ms
        HDFS_SCAN_NODE (id=1):(1m25s 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:29 
           - BytesRead: 3.20 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 27m48s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 516.59 MB/sec
           - RowsReturned: 726
           - RowsReturnedRate: 8.00 /sec
           - ScanRangesComplete: 29
           - ScannerThreadsReadTime: 6s349ms
           - TotalReadThroughput: 38.14 MB/sec
      Instance 15749eb43c8a4a66:bae292109b2f6d1a:(1m29s 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: 391K clock cycles
           - CompileTime: 70ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 133.80 KB
           - DataSinkTime: 1ms
           - SerializeBatchTime: 868K clock cycles
           - ThriftTransmitTime: 73ms
        HDFS_SCAN_NODE (id=1):(1m29s 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:28 
           - BytesRead: 3.15 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 31m15s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 546.68 MB/sec
           - RowsReturned: 653
           - RowsReturnedRate: 7.00 /sec
           - ScanRangesComplete: 28
           - ScannerThreadsReadTime: 5s898ms
           - TotalReadThroughput: 35.83 MB/sec
      Instance 15749eb43c8a4a66:bae292109b2f6d1b:(1m27s 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: 290K clock cycles
           - CompileTime: 69ms
           - LoadTime: 5ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 100.89 KB
           - DataSinkTime: 2ms
           - SerializeBatchTime: 1090K clock cycles
           - ThriftTransmitTime: 133ms
        HDFS_SCAN_NODE (id=1):(1m27s 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:30 
           - BytesRead: 3.22 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 27m25s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 541.75 MB/sec
           - RowsReturned: 506
           - RowsReturnedRate: 5.00 /sec
           - ScanRangesComplete: 30
           - ScannerThreadsReadTime: 5s714ms
           - TotalReadThroughput: 37.73 MB/sec
      Instance 15749eb43c8a4a66:bae292109b2f6d1c:(1m32s 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: 297K clock cycles
           - CompileTime: 69ms
           - LoadTime: 5ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 74.27 KB
           - DataSinkTime: 1ms
           - SerializeBatchTime: 736K clock cycles
           - ThriftTransmitTime: 73ms
        HDFS_SCAN_NODE (id=1):(1m32s 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:29 
           - BytesRead: 3.28 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 31m23s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 521.84 MB/sec
           - RowsReturned: 371
           - RowsReturnedRate: 3.00 /sec
           - ScanRangesComplete: 29
           - ScannerThreadsReadTime: 6s027ms
           - TotalReadThroughput: 36.07 MB/sec
      Instance 15749eb43c8a4a66:bae292109b2f6d1d:(1m19s 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: 408K clock cycles
           - CompileTime: 72ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 55.98 KB
           - DataSinkTime: 1ms
           - SerializeBatchTime: 647K clock cycles
           - ThriftTransmitTime: 37ms
        HDFS_SCAN_NODE (id=1):(1m19s 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:29 
           - BytesRead: 3.18 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 21m19s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 530.23 MB/sec
           - RowsReturned: 276
           - RowsReturnedRate: 3.00 /sec
           - ScanRangesComplete: 29
           - ScannerThreadsReadTime: 6s141ms
           - TotalReadThroughput: 40.96 MB/sec
      Instance 15749eb43c8a4a66:bae292109b2f6d1e:(1m32s 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: 386K clock cycles
           - CompileTime: 70ms
           - LoadTime: 6ms
           - ModuleFileSize: 44.61 KB
        DataStreamSender:
           - BytesSent: 103.36 KB
           - DataSinkTime: 1ms
           - SerializeBatchTime: 799K clock cycles
           - ThriftTransmitTime: 95ms
        HDFS_SCAN_NODE (id=1):(1m32s 100.00%)
          File Formats: RC_FILE/SNAPPY_BLOCKED:28 
           - BytesRead: 3.20 GB
           - DecompressionTime: 0K clock cycles
           - MaterializeTupleTime: 31m32s
           - MemoryUsed: 0.00 
           - PerDiskReadThroughput: 527.31 MB/sec
           - RowsReturned: 506
           - RowsReturnedRate: 5.00 /sec
           - ScanRangesComplete: 28
           - ScannerThreadsReadTime: 6s205ms
           - TotalReadThroughput: 35.38 MB/sec