Commit6c9ad14

committed

add index on workspace build initiator ID

Signed-off-by: Callum Styan <callumstyan@gmail.com>

1 parent4811c58 commit6c9ad14Copy full SHA for 6c9ad14

File tree

-0

lines changed

-0

lines changed

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- Remove index on workspace_builds.initiator_id`
	`2`	`+DROPINDEX IF EXISTS idx_workspace_builds_initiator_id;`

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,6 @@`
	`1`	`+-- Add index on workspace_builds.initiator_id to optimize prebuild queries`
	`2`	`+-- This will dramatically improve performance for:`
	`3`	`+-- - GetPrebuildMetrics (called every 15 seconds)`
	`4`	`+-- - Any other queries using workspace_prebuild_builds view`
	`5`	`+-- - Provisioner job queue prioritization`
	`6`	`+CREATEINDEXidx_workspace_builds_initiator_idON workspace_builds (initiator_id);`

Comments

(0)