11-- name: GetUserLatencyInsights :many
2+ -- GetUserLatencyInsights returns the median and 95th percentile connection
3+ -- latency that users have experienced. The result can be filtered on
4+ -- template_ids, meaning only user data from workspaces based on those templates
5+ -- will be included.
26SELECT
37 workspace_agent_stats .user_id ,
48 users .username ,
@@ -17,7 +21,7 @@ GROUP BY workspace_agent_stats.user_id, users.username
1721ORDER BY user_id ASC ;
1822
1923-- name: GetTemplateInsights :one
20- -- GetTemplateInsights has a garnularity of 5 minutes where if a session/app was
24+ -- GetTemplateInsights has a granularity of 5 minutes where if a session/app was
2125-- in use, we will add 5 minutes to the total usage for that session (per user).
2226WITH d AS (
2327 SELECT generate_series(@start_time::timestamptz , @end_time::timestamptz , ' 5 minute' AS d
@@ -61,6 +65,10 @@ SELECT
6165FROM usage_by_user;
6266
6367-- name: GetTemplateDailyInsights :many
68+ -- GetTemplateDailyInsights returns all daily intervals between start and end
69+ -- time, if end time is a partial day, it will be included in the results and
70+ -- that interval will be less than 24 hours. If there is no data for a selected
71+ -- interval/template, it will be included in the results with 0 active users.
6472WITH d AS (
6573 -- sqlc workaround, use SELECT generate_series instead of SELECT * FROM generate_series.
6674 SELECT generate_series(@start_time::timestamptz , @end_time::timestamptz , ' 1 day' AS d
0 commit comments