Commitae0ee62

authored

fix(coderd/database): improve data exclusion inUpsertTemplateUsageStats (#12764)

The PostgreSQL query analyzer wasn't able to eliminate the agent stats without re-introducing this filter.Before:https://explain.dalibo.com/plan/21h7gb4f4bef391gAfter:https://explain.dalibo.com/plan/721ec1cccee91egc

1 parentf418ece commitae0ee62Copy full SHA for ae0ee62

File tree

-2

lines changed

-2

lines changed

Lines changed: 3 additions & 1 deletion

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

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -599,7 +599,9 @@ WITH`
`599`	`599`	`JOIN`
`600`	`600`	`workspace_agent_statsAS was`
`601`	`601`	`ON`
`602`		`-date_trunc('minute',was.created_at)=mb.minute_bucket`
	`602`	`+was.created_at>= (SELECT tFROM latest_start)`
	`603`	`+ANDwas.created_at< NOW()`
	`604`	`+AND date_trunc('minute',was.created_at)=mb.minute_bucket`
`603`	`605`	`ANDwas.template_id=mb.template_id`
`604`	`606`	`ANDwas.user_id=mb.user_id`
`605`	`607`	`ANDwas.connection_median_latency_ms>=0`

Comments

(0)