Difference between revisions of "EXPLAIN ANALYZE (MySQL)"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 3: Line 3:
 
  EXPLAIN [ ( option [, ...] ) ] statement
 
  EXPLAIN [ ( option [, ...] ) ] statement
 
  EXPLAIN [ ANALYZE ] [ VERBOSE ] statement
 
  EXPLAIN [ ANALYZE ] [ VERBOSE ] statement
 +
 +
== Related terms ==
 +
* [[EXPLAIN]]
  
 
== See also ==
 
== See also ==

Revision as of 06:33, 6 August 2021

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: