René's URL Explorer Experiment


Title: chore: add script to calculate workspace 'on' hours in a given time window by Emyrk · Pull Request #21505 · coder/coder · GitHub

Open Graph Title: chore: add script to calculate workspace 'on' hours in a given time window by Emyrk · Pull Request #21505 · coder/coder

X Title: chore: add script to calculate workspace 'on' hours in a given time window by Emyrk · Pull Request #21505 · coder/coder

Description: Secure environments for developers and their agents - chore: add script to calculate workspace 'on' hours in a given time window by Emyrk · Pull Request #21505 · coder/coder

Open Graph Description: Calculates how long each workspace has been "on" during a given time window defined by "start/stop". Workspaces started before only track their time that are in the window. Futu...

X Description: Calculates how long each workspace has been "on" during a given time window defined by "start/stop". Workspaces started before only track their time that are in ...

Opengraph URL: https://github.com/coder/coder/pull/21505

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository/pull/:id/commits(.:format)
route-controllerpull_requests
route-actioncommits
fetch-noncev2:82029e34-3009-7787-a9da-ad837426caf1
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idB35A:1DB9:729D08:9D546B:6992F127
html-safe-nonce547f64693a5f60a41d762336301f03f3a8b91431ffc77b044cc99a0a191b3aae
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMzVBOjFEQjk6NzI5RDA4OjlENTQ2Qjo2OTkyRjEyNyIsInZpc2l0b3JfaWQiOiI4NjA5MDU0MTkwNDQ1MTk1NTU5IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac0bd395dcc9be01664620c37282161f7ea76ad063c1916f93978d721b4a752c77
hovercard-subject-tagpull_request:3174106943
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/commits
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/coder/coder/pull/21505/commits
twitter:imagehttps://opengraph.githubassets.com/780f92031ede2ed4ad9dc14284f2e387b086ed41d286394187fe796833e2718a/coder/coder/pull/21505
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/780f92031ede2ed4ad9dc14284f2e387b086ed41d286394187fe796833e2718a/coder/coder/pull/21505
og:image:altCalculates how long each workspace has been "on" during a given time window defined by "start/stop". Workspaces started before only track their time that are in the window. Futu...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameEmyrk
hostnamegithub.com
expected-hostnamegithub.com
None01ab16879a3159e6f0717ab948b9b562e162a6aafd1f4393b786b07b747df244
turbo-cache-controlno-cache
go-importgithub.com/coder/coder git https://github.com/coder/coder.git
octolytics-dimension-user_id95932066
octolytics-dimension-user_logincoder
octolytics-dimension-repository_id440752086
octolytics-dimension-repository_nwocoder/coder
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id440752086
octolytics-dimension-repository_network_root_nwocoder/coder
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releaseb1570f3928bef80fa5fc7890ce0942e9b696ad9d
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fcoder%2Fcoder%2Fpull%2F21505%2Fcommits
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fcoder%2Fcoder%2Fpull%2F21505%2Fcommits
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Fcommits&source=header-repo&source_repo=coder%2Fcoder
Reloadhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits
Reloadhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits
Reloadhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits
coder https://patch-diff.githubusercontent.com/coder
coderhttps://patch-diff.githubusercontent.com/coder/coder
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fcoder%2Fcoder
Fork 1.2k https://patch-diff.githubusercontent.com/login?return_to=%2Fcoder%2Fcoder
Star 12.2k https://patch-diff.githubusercontent.com/login?return_to=%2Fcoder%2Fcoder
Code https://patch-diff.githubusercontent.com/coder/coder
Issues 760 https://patch-diff.githubusercontent.com/coder/coder/issues
Pull requests 74 https://patch-diff.githubusercontent.com/coder/coder/pulls
Discussions https://patch-diff.githubusercontent.com/coder/coder/discussions
Actions https://patch-diff.githubusercontent.com/coder/coder/actions
Projects 0 https://patch-diff.githubusercontent.com/coder/coder/projects
Security 5 https://patch-diff.githubusercontent.com/coder/coder/security
Insights https://patch-diff.githubusercontent.com/coder/coder/pulse
Code https://patch-diff.githubusercontent.com/coder/coder
Issues https://patch-diff.githubusercontent.com/coder/coder/issues
Pull requests https://patch-diff.githubusercontent.com/coder/coder/pulls
Discussions https://patch-diff.githubusercontent.com/coder/coder/discussions
Actions https://patch-diff.githubusercontent.com/coder/coder/actions
Projects https://patch-diff.githubusercontent.com/coder/coder/projects
Security https://patch-diff.githubusercontent.com/coder/coder/security
Insights https://patch-diff.githubusercontent.com/coder/coder/pulse
Emyrkhttps://patch-diff.githubusercontent.com/Emyrk
mainhttps://patch-diff.githubusercontent.com/coder/coder/tree/main
stevenmasley/workspace_running_audithttps://patch-diff.githubusercontent.com/coder/coder/tree/stevenmasley/workspace_running_audit
Conversationhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505
Commits21 (21)https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits
Checkshttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/checks
Files changedhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/files
chore: add script to calculate workspace 'on' hours in a given time windowhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits#top
Emyrkhttps://patch-diff.githubusercontent.com/Emyrk
mainhttps://patch-diff.githubusercontent.com/coder/coder/tree/main
stevenmasley/workspace_running_audithttps://patch-diff.githubusercontent.com/coder/coder/tree/stevenmasley/workspace_running_audit
chore: add postgres script to track 'on' duration for workspaceshttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/591ff1d8409b4945c73b9dacfb0f7bcde5824b22
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
591ff1dhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/591ff1d8409b4945c73b9dacfb0f7bcde5824b22
https://patch-diff.githubusercontent.com/coder/coder/tree/591ff1d8409b4945c73b9dacfb0f7bcde5824b22
add debug logic and finalize start/end time railinghttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/e656c4dd5be95a706e88bbc1fba62c1aff3e47fe
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
e656c4dhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/e656c4dd5be95a706e88bbc1fba62c1aff3e47fe
https://patch-diff.githubusercontent.com/coder/coder/tree/e656c4dd5be95a706e88bbc1fba62c1aff3e47fe
Add csv exporthttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/4cdf2882a3c31eeb7f704dccfa8edb3df8c76f6a
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
4cdf288https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/4cdf2882a3c31eeb7f704dccfa8edb3df8c76f6a
https://patch-diff.githubusercontent.com/coder/coder/tree/4cdf2882a3c31eeb7f704dccfa8edb3df8c76f6a
fix start time before actualhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/1221d5077a3bd2e9c5a3b1e7ece80afce5fc7de2
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
1221d50https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/1221d5077a3bd2e9c5a3b1e7ece80afce5fc7de2
https://patch-diff.githubusercontent.com/coder/coder/tree/1221d5077a3bd2e9c5a3b1e7ece80afce5fc7de2
turn off debug modehttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/592aaac7a909cfe6ca863f3e994b2b6963ab436c
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
592aaachttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/592aaac7a909cfe6ca863f3e994b2b6963ab436c
https://patch-diff.githubusercontent.com/coder/coder/tree/592aaac7a909cfe6ca863f3e994b2b6963ab436c
Round up to nearest hourhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/7cc80b2c9268779a97763503c5615ff88724963a
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
7cc80b2https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/7cc80b2c9268779a97763503c5615ff88724963a
https://patch-diff.githubusercontent.com/coder/coder/tree/7cc80b2c9268779a97763503c5615ff88724963a
add rounding commenthttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/828a1674cb97cee457505bc07c0e3359d6163f98
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
828a167https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/828a1674cb97cee457505bc07c0e3359d6163f98
https://patch-diff.githubusercontent.com/coder/coder/tree/828a1674cb97cee457505bc07c0e3359d6163f98
remove unused codehttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/d88c630ea2ebfb0bce45f3645510a0f82d52183f
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
d88c630https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/d88c630ea2ebfb0bce45f3645510a0f82d52183f
https://patch-diff.githubusercontent.com/coder/coder/tree/d88c630ea2ebfb0bce45f3645510a0f82d52183f
add commentshttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/c5608d90825f3c3ab475f41485b3e44ac0642973
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
c5608d9https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/c5608d90825f3c3ab475f41485b3e44ac0642973
https://patch-diff.githubusercontent.com/coder/coder/tree/c5608d90825f3c3ab475f41485b3e44ac0642973
add commentshttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/e0e195e5a852c61ba4271720427ae3ff8b83b099
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
e0e195ehttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/e0e195e5a852c61ba4271720427ae3ff8b83b099
https://patch-diff.githubusercontent.com/coder/coder/tree/e0e195e5a852c61ba4271720427ae3ff8b83b099
move file and have a readmehttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/c617d04f2bba4182310bdcdafbb6346ebc5fbcdb
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
c617d04https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/c617d04f2bba4182310bdcdafbb6346ebc5fbcdb
https://patch-diff.githubusercontent.com/coder/coder/tree/c617d04f2bba4182310bdcdafbb6346ebc5fbcdb
add warningshttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/c55485a7a13bf196e6c75c764017d57c4d911716
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
c55485ahttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/c55485a7a13bf196e6c75c764017d57c4d911716
https://patch-diff.githubusercontent.com/coder/coder/tree/c55485a7a13bf196e6c75c764017d57c4d911716
lintinghttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/16f6690a0510f400badd9e4e719415aa650d93c0
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
16f6690https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/16f6690a0510f400badd9e4e719415aa650d93c0
https://patch-diff.githubusercontent.com/coder/coder/tree/16f6690a0510f400badd9e4e719415aa650d93c0
lintinghttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/5400face155872b4d751809235dee1c6b68a15f4
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
5400fachttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/5400face155872b4d751809235dee1c6b68a15f4
https://patch-diff.githubusercontent.com/coder/coder/tree/5400face155872b4d751809235dee1c6b68a15f4
test: add script to test workspace-runtime-audit.sqlhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/f5f894a5f89d06fa47b9ae1077f9c53ff496f7a7
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
f5f894ahttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/f5f894a5f89d06fa47b9ae1077f9c53ff496f7a7
https://patch-diff.githubusercontent.com/coder/coder/tree/f5f894a5f89d06fa47b9ae1077f9c53ff496f7a7
remove empty linehttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/34969a6709437999fc6773af3a01a2a7bddd0258
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
34969a6https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/34969a6709437999fc6773af3a01a2a7bddd0258
https://patch-diff.githubusercontent.com/coder/coder/tree/34969a6709437999fc6773af3a01a2a7bddd0258
move to a proper tesst filehttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/f4dc50005084bb20d18a2086ad078cd45210a063
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
f4dc500https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/f4dc50005084bb20d18a2086ad078cd45210a063
https://patch-diff.githubusercontent.com/coder/coder/tree/f4dc50005084bb20d18a2086ad078cd45210a063
lintinghttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/397bb1f0df2a1713dfe19581d6618ca3d2eda32c
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
397bb1fhttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/397bb1f0df2a1713dfe19581d6618ca3d2eda32c
https://patch-diff.githubusercontent.com/coder/coder/tree/397bb1f0df2a1713dfe19581d6618ca3d2eda32c
lintinghttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/8843c40e86e471eaf5b2023e155a14a376933e38
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
8843c40https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/8843c40e86e471eaf5b2023e155a14a376933e38
https://patch-diff.githubusercontent.com/coder/coder/tree/8843c40e86e471eaf5b2023e155a14a376933e38
lintinghttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/ee51496c4b96631827e3e989d25f0d469174fd01
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
ee51496https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/ee51496c4b96631827e3e989d25f0d469174fd01
https://patch-diff.githubusercontent.com/coder/coder/tree/ee51496c4b96631827e3e989d25f0d469174fd01
lintinghttps://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/e469389d5a9b5a5a042bd01d9be773b68d911498
https://patch-diff.githubusercontent.com/Emyrk
Emyrkhttps://patch-diff.githubusercontent.com/coder/coder/commits?author=Emyrk
e469389https://patch-diff.githubusercontent.com/coder/coder/pull/21505/commits/e469389d5a9b5a5a042bd01d9be773b68d911498
https://patch-diff.githubusercontent.com/coder/coder/tree/e469389d5a9b5a5a042bd01d9be773b68d911498
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.