I used the Query Monitor plugin to find slow query on my WordPress site. The below-mentioned
WP_Query->get_posts() takes about 0.3446 query time out of the total Database Query time of 0.3976.
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (203598) AND ( wp_term_relationships.term_taxonomy_id IN (17) OR wp_term_relationships.term_taxonomy_id IN (11652,20693,21952,23971,24907,24908,25928) ) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6
I'm guessing it has something to do with the 20,000+ Tags used on posts on my site. Is that so? If yes, how do you suggest fixing this slow query? Or how should I go about deleting Tags which aren't used in more than 5 posts of all the posts on the site?