- Notifications
You must be signed in to change notification settings - Fork928
perf(coderd/database): optimizeGetWorkspaceAgentAndLatestBuildByAuthToken#12809
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 ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
Uh oh!
There was an error while loading.Please reload this page.
Conversation
This stack of pull requests is managed by Graphite.Learn more about stacking. |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
omg
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
I welcome any optimizations of my mediocre queries with open arms, thanks so much for finding and doing this.
It would seem this was a success:  |
Uh oh!
There was an error while loading.Please reload this page.
This query is run 35k/hour on dev.coder.com, this refactor lowers the execution time from 10ms to <0.2ms in my testing (against dev.coder.com DB) and should result in a bit less load.
Original:https://explain.dalibo.com/plan/ggdbc4b4dbeg6b1c
New:https://explain.dalibo.com/plan/ee87631976a2dh62