fix: add index for workspace_resource.job_id column (coder#5009)

coadler · web-flow · commit f3eb66220880 · 2022-11-10T20:09:44.000Z
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000074_workspace_resources_job_id_idx.down.sql b/coderd/database/migrations/000074_workspace_resources_job_id_idx.down.sql
@@ -0,0 +1 @@
+DROP INDEX workspace_resources_job_id_idx;
diff --git a/coderd/database/migrations/000074_workspace_resources_job_id_idx.up.sql b/coderd/database/migrations/000074_workspace_resources_job_id_idx.up.sql
@@ -0,0 +1 @@
+CREATE INDEX CONCURRENTLY workspace_resources_job_id_idx ON workspace_resources USING btree (job_id);

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+DROP INDEX workspace_resources_job_id_idx;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+CREATE INDEX CONCURRENTLY workspace_resources_job_id_idx ON workspace_resources USING btree (job_id);`