diff options
| author | Christopher Baines <mail@cbaines.net> | 2023-05-04 08:32:43 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2023-05-04 08:32:43 +0100 |
| commit | 3734a85650cc4a34d5bfa06d151edcc7efe7144e (patch) | |
| tree | 76991236fed8541f399df33b4a3a91ef8797f7eb | |
| parent | 639c6ff183bda97947dcb0a618fc6ad1ffdb1f88 (diff) | |
| download | data-service-3734a85650cc4a34d5bfa06d151edcc7efe7144e.tar data-service-3734a85650cc4a34d5bfa06d151edcc7efe7144e.tar.gz | |
Use the package_derivations system id in a query
Rather than the derivations system id, as this helps PostgreSQL run the query
faster.
| -rw-r--r-- | guix-data-service/model/build.scm | 2 |
1 files changed, 1 insertions, 1 deletions
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 |