coder
diff --git a/‎coderd/database/queries.sql.go
+20-1 b/‎coderd/database/queries.sql.go
+20-1
diff --git a/‎coderd/database/queries/workspaceagentstats.sql
+20-1 b/‎coderd/database/queries/workspaceagentstats.sql
+20-1
@@ -90,7 +90,26 @@ ORDER BY
 	date ASC;
 
 -- name: DeleteOldWorkspaceAgentStats :exec
-DELETE FROM workspace_agent_stats WHERE created_at < NOW() - INTERVAL '180 days';
+DELETE FROM
+	workspace_agent_stats
+WHERE
+	created_at < (
+		SELECT
+			COALESCE(
+				-- When generating initial template usage stats, all the
+				-- raw agent stats are needed, after that only ~30 mins
+				-- from last rollup is needed. Deployment stats seem to
+				-- use between 15 mins and 1 hour of data. We keep a
+				-- little bit more (1 day) just in case.
+				MAX(start_time) - '1 days'::interval,
+				-- Fall back to 180 days ago if there are no template
+				-- usage stats so that we don't delete the data before
+				-- it's rolled up.
+				NOW() - '180 days'::interval
+			)
+		FROM
+			template_usage_stats
+	);
 
 -- name: GetDeploymentWorkspaceAgentStats :one
 WITH agent_stats AS (