Apr 23, 2024 · Apr 23, 2024
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/workspaceagentstats.sql b/coderd/database/queries/workspaceagentstats.sql
 template_usage_stats
 )
 AND created_at < (
 -- Delete at most in batches of3 days (witha batch size of 3 days, we
 -- can clear out the previous 6 months of data in ~60 iterations) whilst
 -- keeping the DB load relatively low.
 -- Delete at most in batches of4 hours (withthis batch size, assuming
 --1 iteration / 10 minutes, wecan clear out the previous 6 months of
 --data in 7.5 days) whilstkeeping the DB load low.
 SELECT
 COALESCE(MIN(created_at) + '3 days'::interval, NOW())
 COALESCE(MIN(created_at) + '4 hours'::interval, NOW())
 FROM
 workspace_agent_stats
 );
Original file line number	Diff line number	Diff line change
Expand Up		@@ -87,11 +87,11 @@ WHERE
		template_usage_stats
		)
		AND created_at < (
		-- Delete at most in batches of3 days (witha batch size of 3 days, we
		-- can clear out the previous 6 months of data in ~60 iterations) whilst
		-- keeping the DB load relatively low.
		-- Delete at most in batches of4 hours (withthis batch size, assuming
		--1 iteration / 10 minutes, wecan clear out the previous 6 months of
		--data in 7.5 days) whilstkeeping the DB load low.
		SELECT
		COALESCE(MIN(created_at) + '3 days'::interval, NOW())
		COALESCE(MIN(created_at) + '4 hours'::interval, NOW())
		FROM
		workspace_agent_stats
		);
Expand Down