diff options
| author | Christopher Baines <mail@cbaines.net> | 2023-03-05 10:18:30 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2023-03-05 10:18:30 +0000 |
| commit | 7e7cd3f5a95341179e0db0f7c8c825f6131c4bde (patch) | |
| tree | efa1b37fd184915e9c2517a79002fe1613cdba5e | |
| parent | 784c1da9ae85cc7adc2c2e53f1ec751aeeb84ddd (diff) | |
| download | data-service-7e7cd3f5a95341179e0db0f7c8c825f6131c4bde.tar data-service-7e7cd3f5a95341179e0db0f7c8c825f6131c4bde.tar.gz | |
Tweak the comparision query
This seems to generate better plans.
| -rw-r--r-- | guix-data-service/comparison.scm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/guix-data-service/comparison.scm b/guix-data-service/comparison.scm index 4907357..dc521a4 100644 --- a/guix-data-service/comparison.scm +++ b/guix-data-service/comparison.scm @@ -345,7 +345,7 @@ SELECT base_packages.name, base_packages.version, SELECT 1 FROM blocked_builds WHERE blocked_derivation_output_details_set_id - = builds.derivation_output_details_set_id + = base_packages.derivation_output_details_set_id ) ) ORDER BY latest_build_status.timestamp @@ -376,7 +376,7 @@ SELECT base_packages.name, base_packages.version, SELECT 1 FROM blocked_builds WHERE blocked_derivation_output_details_set_id - = builds.derivation_output_details_set_id + = target_packages.derivation_output_details_set_id ) ) ORDER BY latest_build_status.timestamp |