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 <[email protected]>
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
