How to determine what is generating large amount of database queries?

You can use Query Monitor plugin

From Plugin Documention:

Here’s an overview of what’s shown:

Database Queries

  1. Shows all database queries performed on the current page
  2. Shows affected rows and time for all queries
  3. Show notifications for slow queries and queries with errors
  4. Filter queries by query type (SELECT, UPDATE, DELETE, etc)
  5. Filter queries by component (WordPress core, Plugin X, Plugin Y, theme)
  6. Filter queries by calling function
  7. View aggregate query information grouped by component, calling function, and type
  8. Super advanced: Supports multiple instances of wpdb on one page

Filtering queries by component or calling function makes it easy to
see which plugins, themes, or functions on your site are making the
most (or the slowest) database queries.

Related Posts:

  1. How to properly insert data into custom table via plugin
  2. How does WordPress handle MySQL row lock errors?
  3. Can I explicitly specify ENGINE=InnoDB in WordPress?
  4. Bad Request (Invalid Hostname) on working server, database problem
  5. Changing BIGINT to INT
  6. greatest() function returns undefined property
  7. How to write one comment and publish on every post using database or plugin?
  8. Help With MySQL to WPDB Query Conversion
  9. How can I perform high-level database merging for WordPress within continues delivery?
  10. WordPress Backend HA (Automatic failover)
  11. Automatic switch to backup database on fail
  12. Migrating to WordPress Recipe Plugin and Some SQL Issues
  13. Multiple instance of data in plugin custom database table on plugin activation
  14. Better ads plugin has 500.000 entries in wp_postmeta
  15. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  16. dbDelta not adding additional columns in plugin database update
  17. Always get creating a new table with foreign key
  18. How to do database for download stats?
  19. DB Query not working in Plugin
  20. External wpdb connections in different plugins on single page
  21. WordPress plugin: efficient way to store large data
  22. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  23. Integrating Custom Database with WordPress
  24. How to display results from a data table with an encrypted user id?
  25. add_action for publish_post doesn’t work
  26. What database state changes happen after a post is manually “updated” with no changes?
  27. Cant create table on plugin activation
  28. Performing CRUD operations on front end in wordpress
  29. Store GravityForm data in phpmyadmin (mysql)
  30. Moving a few select DB tables to a new WP instance
  31. WordPress database problem wp_posts, primary key
  32. HyperDB failover Delay
  33. Write mysql credentials in plugin
  34. How can I delete the options from DB when the plugin is deleted?
  35. Delete tables from database when deleting plugin
  36. WordPress sharding: which multi-DB plugin to use?
  37. Simple form that saves to database
  38. How do I check what plugins are enabled via the database?
  39. How can a Firebase user registration and login be integrated into a WordPress site?
  40. How to update widget_text in the wp_options table
  41. prefix table and plugins
  42. Replace existing pages with new pages, keep menu links
  43. how to show database content in wordpress post
  44. What is the easiest way to implement cascading database upgrade for my plugin?
  45. Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
  46. If I delete plugins via FTP are settings kept in DB?
  47. What kind of data is that?
  48. Cannot login to ADMIN even after changing password in phpmyadmin
  49. Building an email signup form. Where should the information be saved in the DB?
  50. Prevent duplicate records in plugin table
  51. WpDataTables – View Image Directory
  52. Create a table with wordpress plugin boilerplate
  53. WordPress page and plugin list using sql query
  54. Why this function not working for install database on plugin activation
  55. plugin code is pulling information from database in one instance and not in other. What is wrong?
  56. Can I create a table on my DB without creating a plugin?
  57. WordPress : Explain Plugins & Theme string value in database
  58. Plugins in WP_Options but not Active
  59. Mass SQL WordPress Meta Key deletion
  60. Gathering and logging data from a plugin: how to do it without race conditions?
  61. How to pass the API key to the client from the database? [closed]
  62. Updating options into the wp database performance
  63. Ajax save data to database on document ready, no data being saved
  64. How to edit a published post?
  65. Plugin has added weird data in wp_options, set to autoload
  66. How can I fetch data from another website to my wordpress website with mysql database
  67. Getting error “Warning: mysql_query(): Can’t connect to local MySQL server through socket ‘FILEPATH/cccatalog-plugin.php on line 1656”
  68. Plugin generating unexpected output – on WP mysql dump import
  69. Is this plugin safe to run?
  70. Getting URL GET parameter with Code snippets and storing it in database?
  71. how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
  72. Same Plugin tables between wordpress installations
  73. Some error in mysql script ? Can’t working to create table
  74. How to get the custom field value using SQL query
  75. Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
  76. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  77. create pages automatically and dynamically in wordPress
  78. add_action(‘the_content’, ‘my_plugin_content’) is null
  79. How to allow URL with filename & extension in wordpress?
  80. Programmatically generate new pages for a site based on page template and content elements accessed via DB
  81. PHP message: WordPress database error Deadlock found when trying to get lock
  82. using wordpress login details for other website / application / forum?
  83. how to create database to use it in wordpress website?
  84. how can i get records from wp_postmeta table using particular meta_key in database?
  85. How to create a custom page for unrelated database?
  86. User content database [closed]
  87. Help with sorting and storing data on WordPress
  88. MySql Query for WordPress
  89. How to find an option in the database?
  90. Is there a plugin that will override the “Error establishing a database connection” message? [closed]
  91. Get the url of attachments from the post?
  92. Create New Admin Menu Section – Like how custom post type works, in a way
  93. Using wp config to connect to a DB from a plugin
  94. Shortcode returning specific content of a post
  95. get_option returning a different value from what’s saved
  96. Share or sync user table data with another user table
  97. Very slow page loads
  98. Form with response button after on table after submission
  99. Split Million WordPress Post’s Into Multiple Database Server
  100. Can’t save formdata in DB