<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-host-summary-by-statement-type">
      </a>
      30.4.3.6 The host_summary_by_statement_type and x$host_summary_by_statement_type
Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045063230960">
  </a>
  <a class="indexterm" name="idm46045063229504">
  </a>
  <a class="indexterm" name="idm46045063228000">
  </a>
  <a class="indexterm" name="idm46045063226496">
  </a>
  <p>
   These views summarize information about statements executed,
          grouped by host and statement type. By default, rows are
          sorted by host and descending total latency.
  </p>
  <p>
   The
   <a class="link" href="sys-host-summary-by-statement-type.html" title="30.4.3.6 The host_summary_by_statement_type and x$host_summary_by_statement_type Views">
    <code class="literal">
     host_summary_by_statement_type
    </code>
   </a>
   and
   <a class="link" href="sys-host-summary-by-statement-type.html" title="30.4.3.6 The host_summary_by_statement_type and x$host_summary_by_statement_type Views">
    <code class="literal">
     x$host_summary_by_statement_type
    </code>
   </a>
   views have these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       host
      </code>
     </p>
     <p>
      The host from which the client connected. Rows for which
              the
      <code class="literal">
       HOST
      </code>
      column in the underlying
              Performance Schema table is
      <code class="literal">
       NULL
      </code>
      are
              assumed to be for background threads and are reported with
              a host name of
      <code class="literal">
       background
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       statement
      </code>
     </p>
     <p>
      The final component of the statement event name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total
      </code>
     </p>
     <p>
      The total number of occurrences of the statement event for
              the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total_latency
      </code>
     </p>
     <p>
      The total wait time of timed occurrences of the statement
              event for the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       max_latency
      </code>
     </p>
     <p>
      The maximum single wait time of timed occurrences of the
              statement event for the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       lock_latency
      </code>
     </p>
     <p>
      The total time waiting for locks by timed occurrences of
              the statement event for the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       cpu_latency
      </code>
     </p>
     <p>
      The time spent on CPU for the current thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_sent
      </code>
     </p>
     <p>
      The total number of rows returned by occurrences of the
              statement event for the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_examined
      </code>
     </p>
     <p>
      The total number of rows read from storage engines by
              occurrences of the statement event for the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_affected
      </code>
     </p>
     <p>
      The total number of rows affected by occurrences of the
              statement event for the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       full_scans
      </code>
     </p>
     <p>
      The total number of full table scans by occurrences of the
              statement event for the host.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
