Fetched 1 row(s) in 0.05s
[impala-perf-01-2:21000] > profile;
Query Runtime Profile:
Query (id=c24b2b5b3ada99e6:20d92b3f5df1eaa5):
  Summary:
    Session ID: 5349143facc5bb03:8c91905d7cd073b7
    Session Type: BEESWAX
    Start Time: 2015-09-22 15:16:06.352963000
    End Time: 2015-09-22 15:16:06.399280000
    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   34.97ms   34.97ms      1           1  47.59 MB        -1.00 B  tpch_bin_flat_parquet_30.or...
    Planner Timeline: 5.846ms
       - Analysis finished: 1.248ms (1.248ms)
       - Equivalence classes computed: 1.487ms (238.63us)
       - Single node plan created: 3.224ms (1.737ms)
       - Distributed plan created: 3.816ms (592.326us)
       - Lineage info computed: 4.475ms (659.377us)
       - Planning finished: 5.846ms (1.371ms)
    Query Timeline: 47.106ms
       - Start execution: 48.940us (48.940us)
       - Planning finished: 7.291ms (7.242ms)
       - Ready to start remote fragments: 8.37ms (745.496us)
       - Remote fragments started: 8.39ms (2.486us)
       - Rows available: 8.259ms (219.658us)
       - First row fetched: 9.784ms (1.524ms)
       - Unregister query: 46.325ms (36.541ms)
  ImpalaServer:
     - ClientFetchWaitTimer: 4.76ms
     - RowMaterializationTimer: 22.3us
  Execution Profile c24b2b5b3ada99e6:20d92b3f5df1eaa5:(Total: 34.567ms, non-child: 0ns, % non-child: 0.00%)
    Fragment start latencies: count: 0
     - FinalizationTimer: 0ns
    Coordinator Fragment F00:(Total: 34.293ms, non-child: 195.810us, % non-child: 0.57%)
      Hdfs split stats (<volume id>:<# splits>/<split lengths>): 1:17/1.92 GB 0:13/1.47 GB
       - AverageThreadTokens: 0.00
       - PeakMemoryUsage: 47.71 MB (50026104)
       - PerHostPeakMemUsage: 0
       - PrepareTime: 240.426us
       - RowsProduced: 1 (1)
       - TotalCpuTime: 38.735ms
       - TotalNetworkReceiveTime: 0ns
       - TotalNetworkSendTime: 0ns
       - TotalStorageWaitTime: 32.77ms
      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: 34.97ms, non-child: 34.97ms, % 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:0% 3:0% 4:0% 5:0%
        ExecOption: Codegen enabled: 0 out of 1
         - AverageHdfsReadThreadConcurrency: 0.00
         - AverageScannerThreadConcurrency: 0.00
         - BytesRead: 41.86 MB (43890469)
         - BytesReadDataNodeCache: 0
         - BytesReadLocal: 30.41 MB (31889787)
         - BytesReadRemoteUnexpected: 0
         - BytesReadShortCircuit: 30.41 MB (31889787)
         - DecompressionTime: 0ns
         - MaxCompressedTextFileLength: 0
         - NumColumns: 9 (9)
         - NumDisksAccessed: 1 (1)
         - NumScannerThreadsStarted: 1 (1)
         - PeakMemoryUsage: 47.59 MB (49903224)
         - PerReadThreadRawHdfsThroughput: 2.01 GB/sec
         - RemoteScanRanges: 0 (0)
         - RowsRead: 2.05K (2048)
         - RowsReturned: 1 (1)
         - RowsReturnedRate: 29.00 /sec
         - ScanRangesComplete: 1 (1)
         - ScannerThreadsInvoluntaryContextSwitches: 1 (1)
         - ScannerThreadsTotalWallClockTime: 34.673ms
           - MaterializeTupleTime(*): 759.407us
           - ScannerThreadsSysTime: 0ns
           - ScannerThreadsUserTime: 1.999ms
         - ScannerThreadsVoluntaryContextSwitches: 21 (21)
         - TotalRawHdfsReadTime(*): 20.347ms
         - TotalReadThroughput: 0.00 /sec