Run EXPLAIN on slow queries to find sequential scans

Last updated on

8 September 2016

This is documentation for Drupal 7, which is no longer supported. Learn more and find resources for Drupal 7 sites

A database system executes each query in one or several steps.
The query plan displays the execution time of each step of query processing.

This short article discusses how to use EXPLAIN ANALYSE to optimize queries.

Help improve this page

Page status: No known problems

You can:

Log in, click Edit, and edit this page
Log in, click Discuss, update the Page status value, and suggest an improvement
Log in and create a Documentation issue with your suggestion