Slow media query on big sites

[lebada]

On wordpress version 5.8.2 the wp_enqueue_media() slow query is still there. I found several old discussions about being fixed for many years ago but in my case is still there.

SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month
FROM wp_posts
WHERE post_type = 'attachment'
ORDER BY post_date DESC

4.6238s

I have 73903 media items