Commit570880f

and

authored

update comment on index

Co-authored-by: Danny Kopping <danny@coder.com>

1 parentbd6a876 commit570880fCopy full SHA for 570880f

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`-- Add index on workspace_builds.initiator_id to optimize prebuild queries`
`2`	`2`	`-- This will dramatically improve performance for:`
`3`		`--- - GetPrebuildMetrics (called every15 seconds)`
	`3`	`+-- - GetPrebuildMetrics (called every60 seconds) (see metricsUpdateInterval in enterprise/coderd/prebuilds/metricscollector.go).`
`4`	`4`	`-- - Any other queries using workspace_prebuild_builds view`
`5`	`5`	`-- - Provisioner job queue prioritization`
`6`	`6`	`CREATEINDEXidx_workspace_builds_initiator_idON workspace_builds (initiator_id);`

Comments

(0)