coder
diff --git a/‎coderd/database/queries.sql.go
+20-27 b/‎coderd/database/queries.sql.go
+20-27
diff --git a/‎coderd/database/queries/insights.sql
+12-23 b/‎coderd/database/queries/insights.sql
+12-23
@@ -162,31 +162,20 @@ FROM
 	insights;
 
 -- name: GetTemplateInsightsByTemplate :many
-WITH agent_stats_by_interval_and_user AS (
-	SELECT
-		date_trunc('minute', was.created_at) AS created_at_trunc,
-		was.template_id,
-		was.user_id,
-		CASE WHEN SUM(was.session_count_vscode) > 0 THEN 60 ELSE 0 END AS usage_vscode_seconds,
-		CASE WHEN SUM(was.session_count_jetbrains) > 0 THEN 60 ELSE 0 END AS usage_jetbrains_seconds,
-		CASE WHEN SUM(was.session_count_reconnecting_pty) > 0 THEN 60 ELSE 0 END AS usage_reconnecting_pty_seconds,
-		CASE WHEN SUM(was.session_count_ssh) > 0 THEN 60 ELSE 0 END AS usage_ssh_seconds
-	FROM workspace_agent_stats was
-	WHERE
-		was.created_at >= @start_time::timestamptz
-		AND was.created_at < @end_time::timestamptz
-		AND was.connection_count > 0
-	GROUP BY created_at_trunc, was.template_id, was.user_id
-)
-
 SELECT
 	template_id,
-	COALESCE(COUNT(DISTINCT user_id))::bigint AS active_users,
-	COALESCE(SUM(usage_vscode_seconds), 0)::bigint AS usage_vscode_seconds,
-	COALESCE(SUM(usage_jetbrains_seconds), 0)::bigint AS usage_jetbrains_seconds,
-	COALESCE(SUM(usage_reconnecting_pty_seconds), 0)::bigint AS usage_reconnecting_pty_seconds,
-	COALESCE(SUM(usage_ssh_seconds), 0)::bigint AS usage_ssh_seconds
-FROM agent_stats_by_interval_and_user
+	COUNT(DISTINCT user_id) AS active_users,
+	(SUM(usage_mins) * 60)::bigint AS usage_total_seconds, -- Includes app usage.
+	(SUM(ssh_mins) * 60)::bigint AS usage_ssh_seconds,
+	(SUM(sftp_mins) * 60)::bigint AS usage_sftp_seconds,
+	(SUM(reconnecting_pty_mins) * 60)::bigint AS usage_reconnecting_pty_seconds,
+	(SUM(vscode_mins) * 60)::bigint AS usage_vscode_seconds,
+	(SUM(jetbrains_mins) * 60)::bigint AS usage_jetbrains_seconds
+FROM
+	template_usage_stats
+WHERE
+	start_time >= @start_time::timestamptz
+	AND end_time <= @end_time::timestamptz
 GROUP BY template_id;
 
 -- name: GetTemplateAppInsights :many