Skip to content

Commit 23638c2

Browse files
mafredrimafredri
committed
fix(coderd/database): optimize GetProvisionerDaemonsWithStatusByOrganization query via index
Fixes coder/internal#724
1 parent f94abfc commit 23638c2

File tree

2 files changed

+4
-0
lines changed

2 files changed

+4
-0
lines changed

‎coderd/database/migrations/000363_optimize_getprovisionerdaemonswithstatusbyorganization_query.down.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
DROP INDEX provisioner_jobs_worker_id_organization_id_completed_at_idx;

‎coderd/database/migrations/000363_optimize_getprovisionerdaemonswithstatusbyorganization_query.up.sql

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
CREATE INDEX provisioner_jobs_worker_id_organization_id_completed_at_idx ON provisioner_jobs (worker_id, organization_id, completed_at DESC NULLS FIRST);
2+
3+
COMMENT ON INDEX provisioner_jobs_worker_id_organization_id_completed_at_idx IS 'Support index for finding the latest completed jobs for a worker (and organization), nulls first so that active jobs have priority; targets: GetProvisionerDaemonsWithStatusByOrganization';

0 commit comments

Comments
 (0)