AND date_trunc('minute',was.created_at)=mb.minute_bucket

ANDwas.template_id=mb.template_id

ANDwas.user_id=mb.user_id

ANDwas.connection_median_latency_ms>=0

ANDwas.connection_median_latency_ms>0

mb.start_time,mb.template_id,mb.user_id

)

coalesce((PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY connection_median_latency_ms)),-1)::FLOATAS workspace_connection_latency_50,

coalesce((PERCENTILE_CONT(0.95) WITHIN GROUP (ORDER BY connection_median_latency_ms)),-1)::FLOATAS workspace_connection_latency_95

FROM workspace_agent_stats

WHEREworkspace_agent_stats.created_at> $1AND connection_median_latency_ms>0GROUP BY user_id, agent_id, workspace_id, template_id

WHEREworkspace_agent_stats.created_at> $1AND connection_median_latency_ms>0

GROUP BY user_id, agent_id, workspace_id, template_id

), latest_agent_statsAS (

a.agent_id,

agent_id,

workspace_id,

coalesce(SUM(rx_bytes),0)::bigintAS rx_bytes,

coalesce(SUM(tx_bytes),0)::bigintAS tx_bytes

coalesce(SUM(tx_bytes),0)::bigintAS tx_bytes,

coalesce(MAX(connection_median_latency_ms),0)::floatAS connection_median_latency_ms

FROM workspace_agent_stats

WHEREworkspace_agent_stats.created_at> $1

WHEREworkspace_agent_stats.created_at> $1AND connection_median_latency_ms>0

GROUP BY user_id, agent_id, workspace_id

), latest_agent_statsAS (

WHERE usage= trueAND created_at> now()-'1 minute'::interval

GROUP BY user_id, agent_id, workspace_id

), latest_agent_latenciesAS (

agent_id,

coalesce(MAX(connection_median_latency_ms),0)::floatAS connection_median_latency_ms

FROM workspace_agent_stats

GROUP BY user_id, agent_id, workspace_id

)

users.username,workspace_agents.nameAS agent_name,workspaces.nameAS workspace_name, rx_bytes, tx_bytes,

latest_agent_stats

agent_stats.agent_id=latest_agent_stats.agent_id

latest_agent_latencies

agent_stats.agent_id=latest_agent_latencies.agent_id

users