Difference between revisions of "EXPLAIN ANALYZE (MySQL)"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Line 5: Line 5:
  
 
== Related terms ==
 
== Related terms ==
* [[EXPLAIN]]
+
* <code>[[EXPLAIN]]</code>
  
 
== See also ==
 
== See also ==

Revision as of 08:23, 23 March 2023

EXPLAIN ANALYZE is a profiling tool for your queries that will show you where MySQL spends time on your query and why.

EXPLAIN [ ( option [, ...] ) ] statement
EXPLAIN [ ANALYZE ] [ VERBOSE ] statement

Related terms

See also

Advertising: