@@ -22,17 +22,17 @@ GROUP BY workspace_agent_stats.user_id, users.username, users.avatar_url
2222ORDER BY user_idASC ;
2323
2424-- name: GetTemplateInsights :one
25- -- GetTemplateInsights has a granularity of1 minute where if a session/app was
26- -- in use during a minute, we will add1 minute to the total usage for that
25+ -- GetTemplateInsights has a granularity of5 minutes where if a session/app was
26+ -- in use during a minute, we will add5 minutes to the total usage for that
2727-- session/app (per user).
2828WITH tsAS (
2929SELECT
3030d::timestamptz AS from_,
31- (d::timestamptz + ' 1 minute' AS to_,
32- EXTRACT(epochFROM ' 1 minute' AS seconds
31+ (d::timestamptz + ' 5 minute' AS to_,
32+ EXTRACT(epochFROM ' 5 minute' AS seconds
3333FROM
3434-- Subtract 1 second from end_time to avoid including the next interval in the results.
35- generate_series(@start_time::timestamptz , (@end_time::timestamptz )- ' 1 second' ' 1 minute'
35+ generate_series(@start_time::timestamptz , (@end_time::timestamptz )- ' 1 second' ' 5 minute'
3636), agent_stats_by_interval_and_userAS (
3737SELECT
3838ts .from_ ,
@@ -79,11 +79,11 @@ FROM agent_stats_by_interval_and_user;
7979WITH tsAS (
8080SELECT
8181d::timestamptz AS from_,
82- (d::timestamptz + ' 1 minute' AS to_,
83- EXTRACT(epochFROM ' 1 minute' AS seconds
82+ (d::timestamptz + ' 5 minute' AS to_,
83+ EXTRACT(epochFROM ' 5 minute' AS seconds
8484FROM
8585-- Subtract 1 second from end_time to avoid including the next interval in the results.
86- generate_series(@start_time::timestamptz , (@end_time::timestamptz )- ' 1 second' ' 1 minute'
86+ generate_series(@start_time::timestamptz , (@end_time::timestamptz )- ' 1 second' ' 5 minute'
8787), app_stats_by_user_and_agentAS (
8888SELECT
8989ts .from_ ,