branch master updated: Use the package_derivations system id in a query

[Christopher Baines]

This is an automated email from the git hooks/post-receive script.

cbaines pushed a commit to branch master
in repository data-service.

The following commit(s) were added to refs/heads/master by this push:
     new 3734a85  Use the package_derivations system id in a query
3734a85 is described below

commit 3734a85650cc4a34d5bfa06d151edcc7efe7144e
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Thu May 4 08:32:43 2023 +0100

    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