aboutsummaryrefslogtreecommitdiff
path: root/guix-data-service/model
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2023-10-16 17:19:44 +0100
committerChristopher Baines <mail@cbaines.net>2023-10-16 17:19:44 +0100
commit851a6c17b56a2f06839c79d914eaaa677a1061f2 (patch)
tree220ef2b0107d43cb15114e58ed40f901b59fc5ef /guix-data-service/model
parent82bb17470044d536f57b799a9feea54435544c3f (diff)
downloaddata-service-851a6c17b56a2f06839c79d914eaaa677a1061f2.tar
data-service-851a6c17b56a2f06839c79d914eaaa677a1061f2.tar.gz
Remove redundant joins from the select build query
Diffstat (limited to 'guix-data-service/model')
-rw-r--r--guix-data-service/model/build.scm5
1 files changed, 0 insertions, 5 deletions
diff --git a/guix-data-service/model/build.scm b/guix-data-service/model/build.scm
index ea4ce65..1240453 100644
--- a/guix-data-service/model/build.scm
+++ b/guix-data-service/model/build.scm
@@ -317,11 +317,6 @@ SELECT build_servers.url,
FROM builds
INNER JOIN build_servers
ON build_servers.id = builds.build_server_id
-INNER JOIN derivations_by_output_details_set
- ON builds.derivation_output_details_set_id =
- derivations_by_output_details_set.derivation_output_details_set_id
-INNER JOIN derivations
- ON derivations.id = derivations_by_output_details_set.derivation_id
WHERE build_server_id = $1 AND
builds.build_server_build_id = $2
GROUP BY builds.id, build_servers.url, builds.derivation_file_name")