Commita69fc65

authored

chore(coderd/database): reduce dbpurge load with smaller batches of agent stats (#13049)

1 parent2f7f9d0 commita69fc65Copy full SHA for a69fc65

File tree

-8

lines changed

-8

lines changed

Lines changed: 4 additions & 4 deletions

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -87,11 +87,11 @@ WHERE`
`87`	`87`	`template_usage_stats`
`88`	`88`	`)`
`89`	`89`	`AND created_at< (`
`90`		`--- Delete at most in batches of3 days (witha batch size of 3 days, we`
`91`		`--- can clear out the previous 6 months of data in ~60 iterations) whilst`
`92`		`--- keeping the DB load relatively low.`
	`90`	`+-- Delete at most in batches of4 hours (withthis batch size, assuming`
	`91`	`+--1 iteration / 10 minutes, wecan clear out the previous 6 months of`
	`92`	`+--data in 7.5 days) whilstkeeping the DB load low.`
`93`	`93`	`SELECT`
`94`		`-COALESCE(MIN(created_at)+'3 days'::interval, NOW())`
	`94`	`+COALESCE(MIN(created_at)+'4 hours'::interval, NOW())`
`95`	`95`	`FROM`
`96`	`96`	`workspace_agent_stats`
`97`	`97`	`);`

Comments

(0)