diff options
author | Christopher Baines <mail@cbaines.net> | 2023-11-24 16:31:30 +0000 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2023-11-24 16:31:30 +0000 |
commit | 956c87fc02587aa6323ec6d0df1ec0bcf9977121 (patch) | |
tree | 8bf77c3d168825d722aace0991ff67fd94e7a23c | |
parent | 78df0b3a9f4f27df8341da36d4dfa8e49dfad900 (diff) | |
download | build-coordinator-956c87fc02587aa6323ec6d0df1ec0bcf9977121.tar build-coordinator-956c87fc02587aa6323ec6d0df1ec0bcf9977121.tar.gz |
Create index on build_starts
As querying it is slow.
-rw-r--r-- | sqitch/pg/deploy/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
-rw-r--r-- | sqitch/sqlite/deploy/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/revert/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/build_starts_index.sql | 7 |
7 files changed, 43 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/build_starts_index.sql b/sqitch/pg/deploy/build_starts_index.sql new file mode 100644 index 0000000..cb611c5 --- /dev/null +++ b/sqitch/pg/deploy/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_starts_index to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_starts_index.sql b/sqitch/pg/revert/build_starts_index.sql new file mode 100644 index 0000000..9b1f0e3 --- /dev/null +++ b/sqitch/pg/revert/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_starts_index from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/build_starts_index.sql b/sqitch/pg/verify/build_starts_index.sql new file mode 100644 index 0000000..87c8886 --- /dev/null +++ b/sqitch/pg/verify/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_starts_index on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index c7604f4..cfb5b9d 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -45,3 +45,4 @@ replace_agent_status 2023-03-22T14:17:35Z Chris <chris@felis> # Replace agent_st agent_status_add_processor_count 2023-03-24T09:28:47Z Chris <chris@felis> # Add agent_status.processor_count remove_build_allocation_plan 2023-04-23T19:50:23Z Chris <chris@felis> # Remove build_allocation_plan system_uptime 2023-05-05T18:18:35Z Chris <chris@felis> # Add system uptime +build_starts_index 2023-11-24T16:30:13Z Chris <chris@felis> # build_starts index diff --git a/sqitch/sqlite/deploy/build_starts_index.sql b/sqitch/sqlite/deploy/build_starts_index.sql new file mode 100644 index 0000000..1d4cf2d --- /dev/null +++ b/sqitch/sqlite/deploy/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_starts_index to sqlite + +BEGIN; + +CREATE INDEX build_starts_build_id_idx ON build_starts (build_id); + +COMMIT; diff --git a/sqitch/sqlite/revert/build_starts_index.sql b/sqitch/sqlite/revert/build_starts_index.sql new file mode 100644 index 0000000..6165710 --- /dev/null +++ b/sqitch/sqlite/revert/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_starts_index from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/build_starts_index.sql b/sqitch/sqlite/verify/build_starts_index.sql new file mode 100644 index 0000000..6e99da5 --- /dev/null +++ b/sqitch/sqlite/verify/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_starts_index on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |