Sep 4, 2025 · Sep 3, 2025 · Sep 3, 2025 · Sep 4, 2025
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000363_workspace_build_initiator_index.down.sql b/coderd/database/migrations/000363_workspace_build_initiator_index.down.sql
 -- Remove index on workspace_builds.initiator_id
 DROP INDEX IF EXISTS idx_workspace_builds_initiator_id;
diff --git a/coderd/database/migrations/000363_workspace_build_initiator_index.up.sql b/coderd/database/migrations/000363_workspace_build_initiator_index.up.sql
 -- Add index on workspace_builds.initiator_id to optimize prebuild queries
 -- This will dramatically improve performance for:
 -- - GetPrebuildMetrics (called every 15 seconds)
 -- - Any other queries using workspace_prebuild_builds view
 -- - Provisioner job queue prioritization
 CREATE INDEX idx_workspace_builds_initiator_id ON workspace_builds (initiator_id);
diff --git a/enterprise/coderd/prebuilds/metricscollector.go b/enterprise/coderd/prebuilds/metricscollector.go
 )

 const (
 metricsUpdateInterval = time.Second *15
 metricsUpdateInterval = time.Second *60
 metricsUpdateTimeout  = time.Second * 10
 )
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- Remove index on workspace_builds.initiator_id
		DROP INDEX IF EXISTS idx_workspace_builds_initiator_id;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,6 @@
		-- Add index on workspace_builds.initiator_id to optimize prebuild queries
		-- This will dramatically improve performance for:
		-- - GetPrebuildMetrics (called every 15 seconds)
cstyan marked this conversation as resolved. Show resolvedHide resolved
		-- - Any other queries using workspace_prebuild_builds view
		-- - Provisioner job queue prioritization
		CREATE INDEX idx_workspace_builds_initiator_id ON workspace_builds (initiator_id);
Original file line number	Diff line number	Diff line change
Expand Up		@@ -105,7 +105,7 @@ var (
		)

		const (
		metricsUpdateInterval = time.Second *15
		metricsUpdateInterval = time.Second *60
		metricsUpdateTimeout = time.Second * 10
		)

Expand Down