Commitf91b3ac

authored

fix: group routine workspace agent stats by id (#6601)

Before this was creating separate rows for distinct stat entries, whichresulted in significantly more data being sent to telemetry.

1 parent17bc579 commitf91b3acCopy full SHA for f91b3ac

File tree

-2

lines changed

-2

lines changed

Lines changed: 4 additions & 1 deletion

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

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -92,6 +92,7 @@ WITH agent_stats AS (`
`92`	`92`	`WHEREworkspace_agent_stats.created_at> $1AND connection_median_latency_ms>0GROUP BY user_id, agent_id, workspace_id, template_id`
`93`	`93`	`), latest_agent_statsAS (`
`94`	`94`	`SELECT`
	`95`	`+a.agent_id,`
`95`	`96`	`coalesce(SUM(session_count_vscode),0)::bigintAS session_count_vscode,`
`96`	`97`	`coalesce(SUM(session_count_ssh),0)::bigintAS session_count_ssh,`
`97`	`98`	`coalesce(SUM(session_count_jetbrains),0)::bigintAS session_count_jetbrains,`
`@@ -101,4 +102,4 @@ WITH agent_stats AS (`
`101`	`102`	`FROM workspace_agent_statsWHERE created_at> $1`
`102`	`103`	`)AS aWHEREa.rn=1GROUP BYa.user_id,a.agent_id,a.workspace_id,a.template_id`
`103`	`104`	`)`
`104`		`-SELECT*FROM agent_stats,latest_agent_stats;`
	`105`	`+SELECT*FROM agent_statsJOINlatest_agent_statsONagent_stats.agent_id=latest_agent_stats.agent_id;`

Comments

(0)