Fetched 1 row(s) in 0.77s
[impala-perf-01-2:21000] > profile;
Query Runtime Profile:
Query (id=3e4970629ad3fb05:f9be78c897f5be86):
  Summary:
    Session ID: 5349143facc5bb03:8c91905d7cd073b7
    Session Type: BEESWAX
    Start Time: 2015-09-22 15:16:27.944035000
    End Time: 2015-09-22 15:16:28.717098000
    Query Type: QUERY
    Query State: FINISHED
    Query Status: OK
    Impala Version: impalad version 2.3.0-cdh5-INTERNAL RELEASE (build 0ca2cf51e37a4d834d7496f105459fb5ea8add78)
    User: root
    Connected User: root
    Delegated User:
    Network Address: 172.28.209.31:57972
    Default Db: tpch_bin_flat_parquet_30
    Sql Statement: select * from tpch_bin_flat_parquet_30.orders limit 1
    Coordinator: impala-perf-01-2.vpc.cloudera.com:22000
    Plan:
----------------
Estimated Per-Host Requirements: Memory=0B VCores=0

F00:PLAN FRAGMENT [UNPARTITIONED]
  00:SCAN HDFS [tpch_bin_flat_parquet_30.orders]
     partitions=1/1 files=30 size=3.39GB
     table stats: 45000000 rows total
     column stats: all
     limit: 1
     hosts=4 per-host-mem=unavailable
     tuple-ids=0 row-size=195B cardinality=1
----------------
    Estimated Per-Host Mem: 0
    Estimated Per-Host VCores: 0
    Request Pool: default-pool
    ExecSummary:
Operator       #Hosts   Avg Time   Max Time  #Rows  Est. #Rows  Peak Mem  Est. Peak Mem  Detail
------------------------------------------------------------------------------------------------------------------------
00:SCAN HDFS        1  758.327ms  758.327ms      1           1  71.59 MB        -1.00 B  tpch_bin_flat_parquet_30.or...
    Planner Timeline: 5.894ms
       - Analysis finished: 1.262ms (1.262ms)
       - Equivalence classes computed: 1.496ms (233.523us)
       - Single node plan created: 3.245ms (1.749ms)
       - Distributed plan created: 3.848ms (602.836us)
       - Lineage info computed: 4.527ms (679.144us)
       - Planning finished: 5.894ms (1.367ms)
    Query Timeline: 774.105ms
       - Start execution: 44.223us (44.223us)
       - Planning finished: 7.280ms (7.236ms)
       - Ready to start remote fragments: 7.977ms (697.133us)
       - Remote fragments started: 7.980ms (2.733us)
       - Rows available: 8.191ms (211.186us)
       - First row fetched: 9.781ms (1.590ms)
       - Unregister query: 773.73ms (763.291ms)
  ImpalaServer:
     - ClientFetchWaitTimer: 6.535ms
     - RowMaterializationTimer: 23.106us
  Execution Profile 3e4970629ad3fb05:f9be78c897f5be86:(Total: 758.881ms, non-child: 0ns, % non-child: 0.00%)
    Fragment start latencies: count: 0
     - FinalizationTimer: 0ns
    Coordinator Fragment F00:(Total: 758.503ms, non-child: 175.421us, % non-child: 0.02%)
      Hdfs split stats (<volume id>:<# splits>/<split lengths>): 1:17/1.92 GB 0:13/1.47 GB
      MemoryUsage(500.0ms): 33.74 MB, 57.74 MB
      ThreadUsage(500.0ms): 2, 2
       - AverageThreadTokens: 2.00
       - PeakMemoryUsage: 71.71 MB (75191928)
       - PerHostPeakMemUsage: 0
       - PrepareTime: 222.289us
       - RowsProduced: 1 (1)
       - TotalCpuTime: 4.214ms
       - TotalNetworkReceiveTime: 0ns
       - TotalNetworkSendTime: 0ns
       - TotalStorageWaitTime: 756.191ms
      BlockMgr:
         - BlockWritesOutstanding: 0 (0)
         - BlocksCreated: 0 (0)
         - BlocksRecycled: 0 (0)
         - BufferedPins: 0 (0)
         - BytesWritten: 0
         - MaxBlockSize: 8.00 MB (8388608)
         - MemoryLimit: 19.20 GB (20615843840)
         - PeakMemoryUsage: 0
         - TotalBufferWaitTime: 0ns
         - TotalEncryptionTime: 0ns
         - TotalIntegrityCheckTime: 0ns
         - TotalReadBlockTime: 0ns
      HDFS_SCAN_NODE (id=0):(Total: 758.327ms, non-child: 758.327ms, % non-child: 100.00%)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 1:17/1.92 GB 0:13/1.47 GB
        Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:50% 3:0% 4:0% 5:50%
        ExecOption: Codegen enabled: 0 out of 1
        BytesRead(500.0ms): 100.00 KB, 37.30 MB
         - AverageHdfsReadThreadConcurrency: 5.00
         - AverageScannerThreadConcurrency: 1.00
         - BytesRead: 53.30 MB (55891129)
         - BytesReadDataNodeCache: 0
         - BytesReadLocal: 0
         - BytesReadRemoteUnexpected: 29.30 MB (30725305)
         - BytesReadShortCircuit: 0
         - DecompressionTime: 0ns
         - MaxCompressedTextFileLength: 0
         - NumColumns: 9 (9)
         - NumDisksAccessed: 1 (1)
         - NumScannerThreadsStarted: 1 (1)
         - PeakMemoryUsage: 71.59 MB (75069048)
         - PerReadThreadRawHdfsThroughput: 20.65 MB/sec
         - RemoteScanRanges: 8 (8)
         - RowsRead: 2.05K (2048)
         - RowsReturned: 1 (1)
         - RowsReturnedRate: 1.00 /sec
         - ScanRangesComplete: 0 (0)
         - ScannerThreadsInvoluntaryContextSwitches: 0 (0)
         - ScannerThreadsTotalWallClockTime: 0ns
           - MaterializeTupleTime(*): 0ns
           - ScannerThreadsSysTime: 0ns
           - ScannerThreadsUserTime: 0ns
         - ScannerThreadsVoluntaryContextSwitches: 0 (0)
         - TotalRawHdfsReadTime(*): 2s581ms
         - TotalReadThroughput: 37.30 MB/sec