Install tools to measure performance of SQL queries

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

In this guide, the following set-up is needed:

Install Drupal devel module and display SQL execution time on each web page.
Install an SQL client like pgAdmin3 for PostgreSQL or PhpMyAdmin for MySQL to verify query execution time and use debugging techniques like EXPLAIN ANALYSE.
Enable server-side logging of the SQL slow queries running more than 30 ms.

Depending on your database, read one of the following page:

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