coder
diff --git a/‎coderd/database/querier.go
Lines changed: 4 additions & 3 deletions b/‎coderd/database/querier.go
Lines changed: 4 additions & 3 deletions
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 6 additions & 5 deletions b/‎coderd/database/queries.sql.go
Lines changed: 6 additions & 5 deletions
diff --git a/‎coderd/database/queries/prebuilds.sql
Lines changed: 6 additions & 5 deletions b/‎coderd/database/queries/prebuilds.sql
Lines changed: 6 additions & 5 deletions
@@ -50,11 +50,12 @@ FROM workspace_latest_builds wlb
 WHERE wlb.job_status IN ('pending'::provisioner_job_status, 'running'::provisioner_job_status)
 GROUP BY t.id, wpb.template_version_id, wpb.transition;
 
--- GetPresetsBackoff groups workspace builds by template version ID.
+-- GetPresetsBackoff groups workspace builds by preset ID.
+-- Each preset is associated with exactly one template version ID.
 -- For each group, the query checks up to N of the most recent jobs that occurred within the
 -- lookback period, where N equals the number of desired instances for the corresponding preset.
--- If at least one of the job within a group has failed, we should backoff on the corresponding template version ID.
--- Query returns a list of template version IDs for which we should backoff.
+-- If at least one of the job within a group has failed, we should backoff on the corresponding preset ID.
+-- Query returns a list of preset IDs for which we should backoff.
 -- Only active template versions with configured presets are considered.
 -- We also return the number of failed workspace builds that occurred during the lookback period.
 --
@@ -75,13 +76,13 @@ WITH filtered_builds AS (
       AND wlb.transition = 'start'::workspace_transition
 ),
 time_sorted_builds AS (
-    -- Group builds by template version, then sort each group by created_at.
+    -- Group builds by preset, then sort each group by created_at.
 	SELECT fb.template_version_id, fb.created_at, fb.preset_id, fb.job_status, fb.desired_instances,
 	    ROW_NUMBER() OVER (PARTITION BY fb.preset_id ORDER BY fb.created_at DESC) as rn
 	FROM filtered_builds fb
 ),
 failed_count AS (
-    -- Count failed builds per template version/preset in the given period
+    -- Count failed builds per preset in the given period
 	SELECT preset_id, COUNT(*) AS num_failed
 	FROM filtered_builds
 	WHERE job_status = 'failed'::provisioner_job_status