Method UpsertTemplateUsageStats

coderd/database/querier.go:1428–1428

This query aggregates the workspace_agent_stats and workspace_app_stats data into a single table for efficient storage and querying. Half-hour buckets are used to store the data, and the minutes are summed for each user and template combination. The result is stored in the template_usage_stats table

(ctx context.Context)

	// used to store the data, and the minutes are summed for each user and template
	// combination. The result is stored in the template_usage_stats table.
	UpsertTemplateUsageStats(ctx context.Context) error
	// UpsertUserAIProviderKey preserves the original id and created_at when the
	// user/provider pair already exists. On conflict, callers provide id and
	// created_at for the insert path only.