Geo - Improve query to determine job artifacts to sync when selective sync is enabled
requested to merge 10286-geo-sql-statement-times-out-whilst-determining-job-artifacts-to-sync into master
What does this MR do?
Improve the query to retrieve Ci::JobArtifact to sync when selective sync is enabled removing a superfluous query in the projects table.
Relevant issues
Closes #10286 (closed)
Database checklist
-
Conforms to the database guides -
Included data that shows the performance improvement, preferably in the form of a benchmark -
Included the output of EXPLAIN (ANALYZE, BUFFERS)of the relevant queries
Edited by Michael Kozono