Commit2d05109

authored

fix: ignore deleted workspaces in global stats (#6973)

1 parentaa43f99 commit2d05109Copy full SHA for 2d05109

File tree

-6

lines changed

-6

lines changed

Lines changed: 3 additions & 3 deletions

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

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -356,16 +356,16 @@ WITH workspaces_with_jobs AS (`
`356`	`356`	`build_numberDESC`
`357`	`357`	`LIMIT`
`358`	`358`	`1`
`359`		`-) latest_buildON TRUE`
	`359`	`+) latest_buildON TRUEWHERE deleted= false`
`360`	`360`	`), pending_workspacesAS (`
`361`	`361`	`SELECTCOUNT(*)AS countFROM workspaces_with_jobsWHERE`
`362`	`362`	`started_at ISNULL`
`363`	`363`	`), building_workspacesAS (`
`364`	`364`	`SELECTCOUNT(*)AS countFROM workspaces_with_jobsWHERE`
`365`	`365`	`started_atIS NOT NULLAND`
`366`	`366`	`canceled_at ISNULLAND`
`367`		`-updated_at- INTERVAL'30 seconds'< NOW()AND`
`368`		`-completed_at ISNULL`
	`367`	`+completed_at ISNULLAND`
	`368`	`+updated_at- INTERVAL'30 seconds'< NOW()`
`369`	`369`	`), running_workspacesAS (`
`370`	`370`	`SELECTCOUNT(*)AS countFROM workspaces_with_jobsWHERE`
`371`	`371`	`completed_atIS NOT NULLAND`

Comments

(0)