fix: add index to provisioner_jobs.started_at (#5245)

coadler · web-flow · commit 8469dbc045cf · 2022-12-01T19:29:15.000-06:00
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000085_acquire_job_index.down.sql b/coderd/database/migrations/000085_acquire_job_index.down.sql
@@ -0,0 +1 @@
+DROP INDEX provisioner_jobs_started_at_idx;
diff --git a/coderd/database/migrations/000085_acquire_job_index.up.sql b/coderd/database/migrations/000085_acquire_job_index.up.sql
@@ -0,0 +1,2 @@
+CREATE INDEX provisioner_jobs_started_at_idx ON provisioner_jobs USING btree (started_at)
+    WHERE started_at IS NULL;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+DROP INDEX provisioner_jobs_started_at_idx;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+CREATE INDEX provisioner_jobs_started_at_idx ON provisioner_jobs USING btree (started_at)`
	`2`	`+ WHERE started_at IS NULL;`