<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="show-profiles">
      </a>
      15.7.7.33 SHOW PROFILES Statement
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045169740912">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa75685929"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SHOW</span> <span class="token keyword">PROFILES</span></code></pre>
  </div>
  <p>
   The
   <a class="link" href="show-profiles.html" title="15.7.7.33 SHOW PROFILES Statement">
    <code class="literal">
     SHOW PROFILES
    </code>
   </a>
   statement,
        together with
   <a class="link" href="show-profile.html" title="15.7.7.32 SHOW PROFILE Statement">
    <code class="literal">
     SHOW PROFILE
    </code>
   </a>
   ,
        displays profiling information that indicates resource usage for
        statements executed during the course of the current session.
        For more information, see
   <a class="xref" href="show-profile.html" title="15.7.7.32 SHOW PROFILE Statement">
    Section 15.7.7.32, “SHOW PROFILE Statement”
   </a>
   .
  </p>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    The
    <a class="link" href="show-profile.html" title="15.7.7.32 SHOW PROFILE Statement">
     <code class="literal">
      SHOW PROFILE
     </code>
    </a>
    and
    <a class="link" href="show-profiles.html" title="15.7.7.33 SHOW PROFILES Statement">
     <code class="literal">
      SHOW PROFILES
     </code>
    </a>
    statements are
          deprecated; expect it to be removed in a future MySQL release.
          Use the
    <a class="link" href="performance-schema.html" title="Chapter 29 MySQL Performance Schema">
     Performance
          Schema
    </a>
    instead; see
    <a class="xref" href="performance-schema-query-profiling.html" title="29.19.1 Query Profiling Using Performance Schema">
     Section 29.19.1, “Query Profiling Using Performance Schema”
    </a>
    .
   </p>
  </div>
 </div>
 <br/>
</div>
