simplify query

mafredri · mafredri · commit 8195c9ab2d04 · 2024-03-20T15:26:53.000Z
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/insights.sql b/coderd/database/queries/insights.sql
@@ -262,8 +262,7 @@ WITH
 
 SELECT
 	t.template_ids,
-	array_agg(DISTINCT ai.user_id)::uuid[] AS active_user_ids,
-	''::text AS access_method, -- TODO(mafredri): Remove.
+	COUNT(DISTINCT ai.user_id) AS active_users,
 	ai.app_name AS slug_or_port,
 	ai.display_name,
 	ai.icon,
diff --git a/coderd/insights.go b/coderd/insights.go
@@ -468,9 +468,6 @@ func convertTemplateInsightsApps(usage database.GetTemplateInsightsRow, appUsage
 	//
 	// ORDER BY access_method, slug_or_port, display_name, icon, is_app
 	slices.SortFunc(appUsage, func(a, b database.GetTemplateAppInsightsRow) int {
-		if a.AccessMethod != b.AccessMethod {
-			return strings.Compare(a.AccessMethod, b.AccessMethod)
-		}
 		if a.SlugOrPort != b.SlugOrPort {
 			return strings.Compare(a.SlugOrPort, b.SlugOrPort)
 		}
