Is there a way to list all the database queries my wordpress install is making for a given event?

Posted by mattloak on Stack Overflow See other posts from Stack Overflow or by mattloak
Published on 2010-03-18T20:17:02Z Indexed on 2010/03/19 0:41 UTC
Read the original article Hit count: 367

Filed under:

Wordpress

|

database-queries

Using a method similar to the one described here: (http://stackoverflow.com/questions/14873/how-do-i-display-database-query-statistics-on-wordpress-site), I can see the total number of queries being made when I load a page.

Now I'd like to output a list of the queries that are being made when the page loads. This would allow me to see who my biggest resource hogs are without having to go through the process of elimination of all my plugins and theme scripts.

How would I do this? Thanks.

© Stack Overflow or respective owner

Related posts about Wordpress

Add Your Own Domain to Your WordPress.com Blog

as seen on How to geek - Search for 'How to geek'
Now that you’ve got a nice blog on WordPress.com, why not get your own domain to brand your site? Here’s how you can easily register a new domain or move your existing domain to your WordPress site. By default, your free WordPress address is yourblog’sname.wordpress.com. But whether this… >>> More
Moving from wordpress.com to self-hosted wordpress blog

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have been writing articles on the wordpress.com blog, now i am looking to move it to self-hosted wordpress blog but i wonder: 1) Should i move all my articles on the new blog or just put an article on my last blog that more articles will be posted on my new blog?* 2) If i move all articles… >>> More
Include WordPress Content Outside of WordPress

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking to build a mobile version of a WordPress site and have most of it built in static files, but am trying to get access to the WordPress content from inside an external PHP file that the mobile site will run from. How can I get access to the loop or database without manually writing SQL queries… >>> More
What is the difference between theme making process using Wordpress Theme and Wordpress Theme Framew

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the difference between "Wordpress Theme" and Wordpress Theme Frameworks? In terms of technicalities, Custom theme making workflow, File and folder structure, Anatomy. Wordpress default theme Vs Wordpress theme's framework's Child theme >>> More
Integration of WordPress With WordPress bbPress

as seen on Ezine Articles - Search for 'Ezine Articles'
bbPress is a powerful and fully featured forum software that can be integrated with blogging tools like WordPress. A first glance at the software, gives the impression that it is simple and devoid of any complicated structure, but one has to use it in order, to believe that it is a very powerful tool. >>> More

Related posts about database-queries

Help writing database queries for derby?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database containing multiple tables (Person, Parents, etc) Person table has certain attributes particularly ssn, countryofbirth and currentcountry. Parents table has ssn, and fathersbirthcountry I'm trying to output the SSNs of all people who have the same countryofbirth as their fathersbirthcountry… >>> More
SQL SERVER – Spatial Database Queries – What About BLOB – T-SQL Tuesday #006

as seen on SQL Authority - Search for 'SQL Authority'
Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that. I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. This… >>> More
SQL SERVER Spatial Database Queries What About BLOB T-SQL Tuesday #006

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that. I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. This… >>> More
MS Access split database queries

as seen on Super User - Search for 'Super User'
When the frontend of a MS Access db queries a MS Access backend on another machine over the network, does it pull in the whole table/database/file, or does it have some way of extracting just what it needs from the backend, thereby lessening network load. >>> More
How to keep character encoding with database queries.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am doing the following. 1) I am exporting a database and saving it to a file called dump.sql. 2) The file is then transferred to a different server via PHP ftp. 3) When the file has been successfully transferred the administrator has an option to run a 'dbtransfer' script on the new host. 4)… >>> More