<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-user-summary">
      </a>
      30.4.3.41 The user_summary and x$user_summary Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045061979328">
  </a>
  <a class="indexterm" name="idm46045061977872">
  </a>
  <a class="indexterm" name="idm46045061976384">
  </a>
  <a class="indexterm" name="idm46045061974896">
  </a>
  <p>
   These views summarize statement activity, file I/O, and
          connections, grouped by user. By default, rows are sorted by
          descending total latency.
  </p>
  <p>
   The
   <a class="link" href="sys-user-summary.html" title="30.4.3.41 The user_summary and x$user_summary Views">
    <code class="literal">
     user_summary
    </code>
   </a>
   and
   <a class="link" href="sys-user-summary.html" title="30.4.3.41 The user_summary and x$user_summary Views">
    <code class="literal">
     x$user_summary
    </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">
       user
      </code>
     </p>
     <p>
      The client user name. Rows for which the
      <code class="literal">
       USER
      </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">
       statements
      </code>
     </p>
     <p>
      The total number of statements for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       statement_latency
      </code>
     </p>
     <p>
      The total wait time of timed statements for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       statement_avg_latency
      </code>
     </p>
     <p>
      The average wait time per timed statement for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       table_scans
      </code>
     </p>
     <p>
      The total number of table scans for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       file_ios
      </code>
     </p>
     <p>
      The total number of file I/O events for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       file_io_latency
      </code>
     </p>
     <p>
      The total wait time of timed file I/O events for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       current_connections
      </code>
     </p>
     <p>
      The current number of connections for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total_connections
      </code>
     </p>
     <p>
      The total number of connections for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       unique_hosts
      </code>
     </p>
     <p>
      The number of distinct hosts from which connections for
              the user have originated.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       current_memory
      </code>
     </p>
     <p>
      The current amount of allocated memory for the user.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total_memory_allocated
      </code>
     </p>
     <p>
      The total amount of allocated memory for the user.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
