From 956c87fc02587aa6323ec6d0df1ec0bcf9977121 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Fri, 24 Nov 2023 16:31:30 +0000 Subject: Create index on build_starts As querying it is slow. --- sqitch/pg/deploy/build_starts_index.sql | 7 +++++++ sqitch/pg/revert/build_starts_index.sql | 7 +++++++ sqitch/pg/verify/build_starts_index.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/sqlite/deploy/build_starts_index.sql | 7 +++++++ sqitch/sqlite/revert/build_starts_index.sql | 7 +++++++ sqitch/sqlite/verify/build_starts_index.sql | 7 +++++++ 7 files changed, 43 insertions(+) create mode 100644 sqitch/pg/deploy/build_starts_index.sql create mode 100644 sqitch/pg/revert/build_starts_index.sql create mode 100644 sqitch/pg/verify/build_starts_index.sql create mode 100644 sqitch/sqlite/deploy/build_starts_index.sql create mode 100644 sqitch/sqlite/revert/build_starts_index.sql create mode 100644 sqitch/sqlite/verify/build_starts_index.sql 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 # Replace agent_st agent_status_add_processor_count 2023-03-24T09:28:47Z Chris # Add agent_status.processor_count remove_build_allocation_plan 2023-04-23T19:50:23Z Chris # Remove build_allocation_plan system_uptime 2023-05-05T18:18:35Z Chris # Add system uptime +build_starts_index 2023-11-24T16:30:13Z Chris # 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; -- cgit v1.2.3