Title: Slow queries
Last modified: November 21, 2020

---

# Slow queries

 *  Resolved [igears](https://wordpress.org/support/users/igears/)
 * (@igears)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/slow-queries-20/)
 * Hi,
 * I have installed the query monitor plugin and it reports a couple of duplicate
   querys as well as a couple of slow queries from Yoast. Below is an example of
   a slow query:
 *     ```
       SELECT COUNT(term_id)
       FROM wpdc_term_taxonomy
       WHERE term_id NOT IN (
       SELECT object_id
       FROM wpdc_yoast_indexable
       WHERE object_type = 'term'
       AND permalink_hash IS NOT NULL )
       AND taxonomy IN ('category', 'post_tag', 'post_format', 'product_cat', 'product_tag', 'product_shipping_class')
       ```
   
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fslow-queries-20%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Md Mazedul Islam Khan](https://wordpress.org/support/users/mazedulislamkhan/)
 * (@mazedulislamkhan)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/slow-queries-20/#post-13691130)
 * We are sorry to hear that you are having trouble with our plugin. Can you please
   confirm whether you have performed the SEO data optimization from the SEO → Tools
   page? If not, please run the relevant analysis to see whether this improves anything.
 * However, if you have already performed the relevant analysis but you are still
   seeing the duplicate queries in the Query Monitor plugin, we recommend you please
   try resetting the Indexables tables and migrations by using the [Yoast Test Helper](https://wordpress.org/plugins/yoast-test-helper/).
   You can find the relevant steps given below:
    - Go to Tools → Yoast Test → Yoast SEO → Reset Indexables tables & migrations
      options to reset it.
    - Run the SEO data optimization again from the Yoast SEO → Tools page to see
      whether this improves the relevant slow queries.
 * Last but not least, can you please confirm on which exact page you are seeing
   the relevant duplicate queries in the Query Monitor plugin?
 * We look forward to hearing from you.
 *  [devnihil](https://wordpress.org/support/users/devnihil/)
 * (@devnihil)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/slow-queries-20/#post-13717345)
 * We are going ahead and marking this issue as resolved due to inactivity. If you
   require any further assistance please create a new issue.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Slow queries’ is closed to new replies.

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

## Tags

 * [slow query](https://wordpress.org/support/topic-tag/slow-query/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 2 replies
 * 3 participants
 * Last reply from: [devnihil](https://wordpress.org/support/users/devnihil/)
 * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/slow-queries-20/#post-13717345)
 * Status: resolved