Commit70b093f

authored

fix: filter session count sums bycreated_at (#6529)

Fixes the session totals being waaaaay too high!

1 parent1cc10f2 commit70b093fCopy full SHA for 70b093f

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 1 deletion

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

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -70,7 +70,7 @@ WITH agent_stats AS (`
`70`	`70`	`coalesce(SUM(session_count_reconnecting_pty),0)::bigintAS session_count_reconnecting_pty`
`71`	`71`	`FROM (`
`72`	`72`	`SELECT*, ROW_NUMBER() OVER(PARTITION BY agent_idORDER BY created_atDESC)AS rn`
`73`		`-FROM workspace_agent_stats`
	`73`	`+FROM workspace_agent_statsWHERE created_at> $1`
`74`	`74`	`)AS aWHEREa.rn=1`
`75`	`75`	`)`
`76`	`76`	`SELECT*FROM agent_stats, latest_agent_stats;`

Comments

(0)