From 3734a85650cc4a34d5bfa06d151edcc7efe7144e Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Thu, 4 May 2023 08:32:43 +0100 Subject: Use the package_derivations system id in a query Rather than the derivations system id, as this helps PostgreSQL run the query faster. --- guix-data-service/model/build.scm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/guix-data-service/model/build.scm b/guix-data-service/model/build.scm index 92d4969..4f347f5 100644 --- a/guix-data-service/model/build.scm +++ b/guix-data-service/model/build.scm @@ -146,7 +146,7 @@ ORDER BY status")) `(("guix_revisions.commit = $" . ,revision-commit)) '()) ,@(if system - `(("derivations.system_id = $" . + `(("package_derivations.system_id = $" . ,(number->string (system->system-id conn system)))) '()) ,@(if target -- cgit v1.2.3