My site is running slow and I suspect its a module, but not sure which one. Is there a module that can display all the sql queries being run on a loaded page? If there isn't maybe there is a command line tool that others use to monitor this data?

closed as off-topic by Pierre.Vriens, DRUPWAY, No Sssweat, Adrian Cid Almaguer, mradcliffe Jan 23 '17 at 18:27

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions asking to recommend or find a book, tool, module, theme, distribution, tutorial, or other off-site resource are off-topic for Drupal Answers as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – Pierre.Vriens, DRUPWAY, No Sssweat, Adrian Cid Almaguer, mradcliffe
If this question can be reworded to fit the rules in the help center, please edit the question.


There is better query log we can get from mysql log( more here: https://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log )

It shows real mysql queries with real values while the Devel's log shows placeholders.

So to get log of a page shutdown Mysql server, add the "log=" line in my.ini and restart the server then do the page load and then again stop the server and comment the log command.


The Devel module has a query log option, which when enabled will show every query that's been run for a request at the footer of the page.

You can enable it at admin/config/development/devel once the module's installed.

  • 1
    Seems this is no longer available in D8. – Randell Jul 31 at 5:46

Not the answer you're looking for? Browse other questions tagged or ask your own question.