Skip to content
Navigation Menu
Sign in
Products
Platform
GitHub
Repository hosting, code review, and collaboration
Copilot
AI coding agent for tasks, projects, and automated work
Build & Ship
Actions
CI/CD and automation
Code Quality
Quality analysis, fixes, and enforcement
Codespaces
Cloud development environments
Secure
Code Security
Vulnerability detection and remediation
Secret Protection
Secret scanning and leak prevention
All Features
Developers
Learn
Documentation
Training
Certifications
Build
Build with Copilot
Customize Copilot
Integrations
Explore
Trending repos
GitHub Sponsors
Developer articles
Changelog
Changelog
Your source for the latest features, improvements, and fixes across GitHub products, all in one place.
Businesses
By Stage
Enterprises
Team
Startups
Nonprofits
By Industry
Healthcare
Financial services
Manufacturing
Government
See all industries
Evaluate GitHub
Why GitHub
Customer Stories
Business insights
Trust Center
Add-ons
GitHub Advanced Security
Enterprise-grade code security
Copilot for business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Resources
Learn & Connect
Documentation
Resource center
Blog
Events & webinars
Community Forum
Customer Stories
Integrations
Support
Customer support
Training
GitHub Status
Company
About
Partners
Changelog
GitHub Universe
GitHub Universe
The event for developers, by developers — talks, workshops, and what’s next for GitHub.
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
codeaucafe
coder
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Commits
Breadcrumbs
History for
coder
coderd
database
queries
workspaceagentstats.sql
on
main
User selector
All users
Datepicker
All time
Commit history
Commits on Mar 12, 2026
chore(db): remove 23 unused database methods (#22999)
Show description for e9025f9
johnstcn
authored
e9025f9
View commit details
Copy full SHA for e9025f9
View code at this point
Browse repository at this point
Commits on Dec 9, 2025
perf: optimize GetDeploymentWorkspaceAgentStats by eliminating 2nd select (#21112)
Show description for 6abb889
cstyan
authored
6abb889
View commit details
Copy full SHA for 6abb889
View code at this point
Browse repository at this point
Commits on Oct 7, 2025
chore(coderd/database/queries): remove trailing whitespace (#20192)
mafredri
authored
057d7da
View commit details
Copy full SHA for 057d7da
View code at this point
Browse repository at this point
Commits on Oct 17, 2024
fix: correct connection_median_latency_ms in query (#15086)
Show description for 5f640eb
garrettatcoder
authored
5f640eb
View commit details
Copy full SHA for 5f640eb
View code at this point
Browse repository at this point
Commits on Sep 19, 2024
fix: handle new agent stat format correctly (#14576)
Show description for 922f4c5
garrettatcoder
and
ethanndickson
authored
922f4c5
View commit details
Copy full SHA for 922f4c5
View code at this point
Browse repository at this point
Commits on Aug 30, 2024
fix: delete workspace agent stats after 180 days (#14489)
Show description for 6287502
ethanndickson
authored
6287502
View commit details
Copy full SHA for 6287502
View code at this point
Browse repository at this point
Commits on Apr 23, 2024
chore(coderd/database): reduce dbpurge load with smaller batches of agent stats (#13049)
mafredri
authored
a69fc65
View commit details
Copy full SHA for a69fc65
View code at this point
Browse repository at this point
Commits on Apr 22, 2024
feat(coderd/database): keep only 1 day of `workspace_agent_stats` after rollup (#12674)
mafredri
authored
e17e8aa
View commit details
Copy full SHA for e17e8aa
View code at this point
Browse repository at this point
Commits on Apr 9, 2024
chore: remove InsertWorkspaceAgentStat query (#12869)
Show description for 0a8c8ce
Emyrk
authored
0a8c8ce
View commit details
Copy full SHA for 0a8c8ce
View code at this point
Browse repository at this point
Commits on Dec 7, 2023
fix: implement fake DeleteOldWorkspaceAgentStats (#11076)
mtojek
authored
941e387
View commit details
Copy full SHA for 941e387
View code at this point
Browse repository at this point
Commits on Sep 19, 2023
feat(coderd): support weekly aggregated insights (#9684)
mtojek
authored
b0e3daa
View commit details
Copy full SHA for b0e3daa
View code at this point
Browse repository at this point
Commits on Aug 4, 2023
feat(coderd): batch agent stats inserts (#8875)
Show description for 9fb18f3
johnstcn
authored
9fb18f3
View commit details
Copy full SHA for 9fb18f3
View code at this point
Browse repository at this point
Commits on May 30, 2023
feat: Fix Deployment DAUs to work with local timezones (#7647)
Show description for c795a0e
Emyrk
authored
c795a0e
View commit details
Copy full SHA for c795a0e
View code at this point
Browse repository at this point
Commits on Apr 14, 2023
feat: expose agent stats via Prometheus endpoint (#7115)
Show description for 942aba3
mtojek
authored
942aba3
View commit details
Copy full SHA for 942aba3
View code at this point
Browse repository at this point
Commits on Mar 14, 2023
fix: group routine workspace agent stats by id (#6601)
Show description for f91b3ac
kylecarbs
authored
f91b3ac
View commit details
Copy full SHA for f91b3ac
View code at this point
Browse repository at this point
Commits on Mar 13, 2023
feat: add workspace agent stat reporting to telemetry (#6577)
Show description for 35df1b1
kylecarbs
authored
35df1b1
View commit details
Copy full SHA for 35df1b1
View code at this point
Browse repository at this point
Commits on Mar 9, 2023
fix: filter session count sums by `created_at` (#6529)
Show description for 70b093f
kylecarbs
authored
70b093f
View commit details
Copy full SHA for 70b093f
View code at this point
Browse repository at this point
fix: only sum connection latencies when they are set (#6524)
Show description for 1cc10f2
kylecarbs
authored
1cc10f2
View commit details
Copy full SHA for 1cc10f2
View code at this point
Browse repository at this point
feat: add connection statistics for workspace agents (#6469)
Show description for 5304b4e
kylecarbs
authored
5304b4e
View commit details
Copy full SHA for 5304b4e
View code at this point
Browse repository at this point
Commits on Mar 7, 2023
chore: use nil map on agent stats to check if report interval should be returned (#6479)
Show description for 87ed7a7
kylecarbs
authored
87ed7a7
View commit details
Copy full SHA for 87ed7a7
View code at this point
Browse repository at this point
Commits on Mar 2, 2023
feat: add agent stats for different connection types (#6412)
Show description for 2ff1c6d
kylecarbs
authored
2ff1c6d
View commit details
Copy full SHA for 2ff1c6d
View code at this point
Browse repository at this point
Commits on Feb 28, 2023
chore: convert agent stats to use a table (#6374)
Show description for 05e4499
kylecarbs
authored
05e4499
View commit details
Copy full SHA for 05e4499
View code at this point
Browse repository at this point
Loading
You can’t perform that action at this time.