Mar 9, 2023 · Mar 9, 2023
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/workspaceagentstats.sql b/coderd/database/queries/workspaceagentstats.sql
 coalesce(SUM(session_count_reconnecting_pty), 0)::bigint AS session_count_reconnecting_pty
 FROM (
 SELECT *, ROW_NUMBER() OVER(PARTITION BY agent_id ORDER BY created_at DESC) AS rn
 FROM workspace_agent_stats
 FROM workspace_agent_stats WHERE created_at > $1
 ) AS a WHERE a.rn = 1
 )
 SELECT * FROM agent_stats, latest_agent_stats;
Original file line number	Diff line number	Diff line change
Expand Up		@@ -70,7 +70,7 @@ WITH agent_stats AS (
		coalesce(SUM(session_count_reconnecting_pty), 0)::bigint AS session_count_reconnecting_pty
		FROM (
		SELECT *, ROW_NUMBER() OVER(PARTITION BY agent_id ORDER BY created_at DESC) AS rn
		FROM workspace_agent_stats
		FROM workspace_agent_stats WHERE created_at > $1
		) AS a WHERE a.rn = 1
		)
		SELECT * FROM agent_stats, latest_agent_stats;