Improve query performance when filtering merge requests by deployments
The following discussion from !44041 (merged) should be addressed:
-
@sabrams started a discussion: (+4 comments) @yorickpeterse, great feature! From the database perspective, I'd just like to look at a few examples of the queries generated by the finders to see what their explain plans look like. Thanks!
The performance of the queries introduced in !44041 (merged) appears to not be good enough. Unfortunately, this merge request got merged despite the discussion surrounding these queries not being resolved. We'll need to improve the query performance before we can enable and later remove the feature flag.