Verdant TCS

WordPress Debug and Query Monitor

4 min read

WordPress Debug and the excellent Query Monitor plugin are a highly effective combination to help you diagnose performance issues on your individual WordPress websites.

AN INTRO TO WP_DEBUG

If you’re having issues with your site, WordPress debug mode can help you find out what’s going wrong by recording any and all PHP errors that occur across your website. These errors will be displayed directly inside your dashboard, as well as also logging them in the WP Debug Log.

This information will help you identify the specific functions that are throwing errors, and tie them back to the source of the problem.

We recommend using Debug on your staging websites, but if you are using it on a production website, be sure to turn it off again as soon as you’re finished troubleshooting as it can reveal parts of your PHP to website visitors.

AN INTRO TO QUERY MONITOR

Query Monitor has a ton of features. Here we’ll be focusing on identifying PHP and database issues that are harming your websites performance, and with Query Monitor you can view every transaction that takes place as the webpage is loaded, and you can do this on any page on your website – both front end and admin side. 

Once installed, each page you load will generate a report, and each query is recorded along with the time it takes to run and the function that generated it. Armed with this information you’ll be able pinpoint exactly where things are going wrong and take action accordingly. 

It’s beyond the scope of this article to analyse everything this plugin can do in detail, but you can learn more about everything it has to offer over on the plugins website here: https://querymonitor.com/ and the plugin page here: https://wordpress.org/plugins/query-monitor/

Step 1. Activate WP_DEBUG and Query Monitor

vCanopy has a very handy toggle built right into your websites configuration modal that will both turn on debug and debug logging, and also install and activate the query monitor plugin.

In your vCanopy  account, head to your Sites page and click on the domain your experiencing trouble with to open up configuration modal. Click through to the Logs tab, and toggle on “Enable Secure WP Debug“.

Step 2. Login and Begin your Diagnosis

First login to your site. WP_DEBUG will display any PHP errors or warnings at the top of each page in your dashboard.

If you have a specific page you’ve been having trouble with, head there first. If it’s a general performance issue across the whole website, head to your homepage.

In the admin bar at the top of your site you’ll see some stats provided by Query Monitor. 

These metrics mean the following:

  1. Page load time
  2. Peak memory usage
  3. Database query time
  4. Number of database queries

This is a great feature that you can show you at a glance whether the page your on has a performance issue that needs to be addressed.

Hover over the admin bar to see an overview of what you can dive into.

If you have any Notices or Warnings highlighted at the top, this is the info we’re looking for. If there are no warnings, continue to step 3 below.

Click through to the warnings/notices to view the offending queries and the responsible component (usually a plugin). With the information you gather here you can now begin testing. If you deactivate the plugins / change the theme causing the problems does your website speed go back to normal?

If yes, then you’ve now identified the cause of your slow website and can begin to make plans to fix the issue either by contacting the plugin/theme developer or replacing it with something more performant. 

Step 3. Diving into to your queries

Queries are the most interesting of the available options in terms of the data it provides us. 

You can sort queries by caller (includes plugins), the number of affected rows, and time. Sorting by time allows you to focus on the heaviest queries first and see the root cause responsible for them.

It’s important to note that some functionality is query heavy – for example Woocommerce store pages.

Or it may be poorly constructed theme along with inefficient plugins all bringing down your sites performance together.

Here we’re looking to identify what’s causing the website to work so hard. If it is database heavy processes that are integral to your website, then you may need to look at object caching, or specific solutions that can address your problems.

If it’s not obvious what’s slowing down your site, then you may need to begin deactivating plugins one by one until your can identify the cause. Or better yet, deactivate all plugins and switch to a default theme to get a performance baseline, and then begin reactivating them one by one.

A staging environment is perfect this kind of testing.

Step 4. Reviewing the WP Debug Log

Inside your vCanopy account, open up your website configuration modal and navigate to the logs tab like you did in step 1.

Here you can review any information gathered as you’ve been navigating around your website. 

Information gathered here and inside the Nginx Error Log is often enough to see what’s going wrong on your website – and it’s usually plugin related.

Don’t forget to toggle debug off once you’re done!

Search the Knowledge Base

New to vCanopy?

Get started with our FREE Core plan today! We bring the software, you bring the hardware.