chore: add index to template_id on workspaces

coder · DanielleMaywood · Dec 2, 2024 · Nov 18, 2024 · Nov 18, 2024 · Nov 19, 2024
commit dec3d6cf85e0ec06878b9bf668f7316ab3c13b8f
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000278_workspace_next_start_at.down.sql b/coderd/database/migrations/000278_workspace_next_start_at.down.sql
@@ -6,6 +6,7 @@ DROP FUNCTION IF EXISTS nullify_next_start_at_on_template_autostart_modification
 DROP TRIGGER IF EXISTS trigger_nullify_next_start_at_on_workspace_autostart_modification ON workspaces;
 DROP FUNCTION IF EXISTS nullify_next_start_at_on_workspace_autostart_modification;
 
+DROP INDEX workspace_template_id_idx;
 DROP INDEX workspace_next_start_at_idx;
 
 ALTER TABLE ONLY workspaces DROP COLUMN IF EXISTS next_start_at;

diff --git a/coderd/database/migrations/000278_workspace_next_start_at.up.sql b/coderd/database/migrations/000278_workspace_next_start_at.up.sql
@@ -1,6 +1,7 @@
 ALTER TABLE ONLY workspaces ADD COLUMN IF NOT EXISTS next_start_at TIMESTAMPTZ DEFAULT NULL;
 
 CREATE INDEX workspace_next_start_at_idx ON workspaces USING btree (next_start_at) WHERE (deleted=false);
+CREATE INDEX workspace_template_id_idx   ON workspaces USING btree (template_id)   WHERE (deleted=false);
 
 CREATE FUNCTION nullify_next_start_at_on_workspace_autostart_modification() RETURNS trigger
 	LANGUAGE plpgsql