Run EXPLAIN on slow queries to find sequential scans
Last updated on
8 September 2016
Drupal 7 will no longer be supported after January 5, 2025. 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:
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