From 851a6c17b56a2f06839c79d914eaaa677a1061f2 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Mon, 16 Oct 2023 17:19:44 +0100 Subject: Remove redundant joins from the select build query --- guix-data-service/model/build.scm | 5 ----- 1 file changed, 5 deletions(-) (limited to 'guix-data-service/model') 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") -- cgit v1.2.3