Skip to content

feat(coderd/database): use template_usage_stats in GetTemplateInsightsByInterval query #12667

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 2 commits into from
Mar 25, 2024

Conversation

mafredri
Copy link
Member

@mafredri mafredri commented Mar 19, 2024

This PR updates the GetTemplateInsightsByInterval query to use rolled up template_usage_stats instead of raw agent and app stats.

@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 3651195 to 454f328 Compare March 20, 2024 10:25
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from e64a1b0 to f0ceeea Compare March 20, 2024 10:25
Copy link
Member

@mtojek mtojek left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Stamp?

@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 454f328 to 1e05111 Compare March 20, 2024 12:37
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from f0ceeea to b10b9dd Compare March 20, 2024 12:37
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch 3 times, most recently from b9c85a5 to 2d7344a Compare March 20, 2024 14:02
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from b10b9dd to 20b839e Compare March 20, 2024 14:13
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 2d7344a to 3b66bab Compare March 20, 2024 14:53
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from 20b839e to 67c6e60 Compare March 20, 2024 14:53
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 3b66bab to dbe21aa Compare March 20, 2024 16:02
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from 67c6e60 to ec47926 Compare March 20, 2024 16:02
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from dbe21aa to b499ab2 Compare March 20, 2024 19:03
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from ec47926 to 4a074e0 Compare March 20, 2024 19:04
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from b499ab2 to b208047 Compare March 20, 2024 19:19
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from 4a074e0 to 388b328 Compare March 20, 2024 19:19
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from b208047 to 4da99d8 Compare March 20, 2024 19:55
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from 388b328 to af55118 Compare March 20, 2024 19:55
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 4da99d8 to 33c681f Compare March 21, 2024 15:06
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from af55118 to 958785d Compare March 21, 2024 15:06
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 33c681f to 5c7ed09 Compare March 21, 2024 17:54
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from 958785d to 05780db Compare March 21, 2024 17:54
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 5c7ed09 to 7e229d3 Compare March 22, 2024 15:40
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from 05780db to 3c67005 Compare March 22, 2024 15:40
@mafredri mafredri marked this pull request as ready for review March 22, 2024 16:39
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 7e229d3 to b46a8e0 Compare March 22, 2024 17:11
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from 3c67005 to bf27a9f Compare March 22, 2024 17:11
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from b46a8e0 to 87ab396 Compare March 22, 2024 17:15
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from bf27a9f to 8b32a8c Compare March 22, 2024 17:15
@mafredri mafredri changed the title feat(coderd/database): rewrite GetTemplateInsightsByInterval to use template_usage_stats feat(coderd/database): use template_usage_stats in GetTemplateInsightsByInterval query Mar 25, 2024
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsights branch from 87ab396 to 49acc52 Compare March 25, 2024 11:18
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from 8b32a8c to bfe4b8a Compare March 25, 2024 11:18
Copy link
Member Author

mafredri commented Mar 25, 2024

Merge activity

  • Mar 25, 9:33 AM EDT: @mafredri started a stack merge that includes this pull request via Graphite.
  • Mar 25, 9:34 AM EDT: Graphite rebased this pull request as part of a merge.
  • Mar 25, 9:45 AM EDT: @mafredri merged this pull request with Graphite.

Base automatically changed from mafredri/rewrite-gettemplateinsights to main March 25, 2024 13:33
@mafredri mafredri force-pushed the mafredri/rewrite-gettemplateinsightsbyinterval branch from bfe4b8a to cb74f29 Compare March 25, 2024 13:33
@mafredri mafredri merged commit 5f3be62 into main Mar 25, 2024
@mafredri mafredri deleted the mafredri/rewrite-gettemplateinsightsbyinterval branch March 25, 2024 13:45
@github-actions github-actions bot locked and limited conversation to collaborators Mar 25, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants