Yoast Performs Slow SQL Queries

Hello, I’m investigating some performance issues and I see that Yoast tends to run some very long-running queries. Here is an example:

SELECT DISTINCT wp_users.ID
				FROM wp_users LEFT JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id )  LEFT JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id )  LEFT JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id )  LEFT JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id AND mt3.meta_key = 'wpseo_noindex_author' )  LEFT JOIN wp_usermeta AS mt4 ON ( wp_users.ID = mt4.user_id )
				WHERE 1=1 AND wp_users.ID IN ( SELECT DISTINCT wp_20_posts.post_author FROM wp_20_posts WHERE wp_20_posts.post_status = 'publish' AND wp_20_posts.post_type IN ( 'post' ) ) AND (
  (
    (
      wp_usermeta.meta_key = '_yoast_wpseo_profile_updated'
      AND
      (
        ( mt1.meta_key = 'wp_20_user_level' AND mt1.meta_value != '0' )
        AND
        (
          ( mt2.meta_key = 'wpseo_noindex_author' AND mt2.meta_value != 'on' )
          OR
          mt3.user_id IS NULL
        )
      )
    )
    AND
    (
      mt4.meta_key = 'wp_20_capabilities'
    )
  )
)
				ORDER BY wp_usermeta.meta_value+0 DESC

From [www.example_domain.com/sitemap_index.xml] in [/nas/content/live/example_env/wp-content/plugins/wordpress-seo/inc/sitemaps/class-author-sitemap-provider.php:12

What is this query doing and is there a way to opt out of it? it seems to have something to do with author sitemaps.

• This topic was modified 1 year, 1 month ago by Scott Fennell.