| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf |
| route-pattern | /:user_id/:repository/pull/:id/commits(.:format) |
| route-controller | pull_requests |
| route-action | commits |
| fetch-nonce | v2:018549a3-8413-aa1a-5888-db35b6d39f01 |
| current-catalog-service-hash | ae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b |
| request-id | 9E88:27D28D:1437D0:1D76B3:6AFB0E52 |
| html-safe-nonce | c904632e6a3cad8e6c26ee71d3f0845c7568f3e8260d412e285cfa2d6a9c3d6a |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5RTg4OjI3RDI4RDoxNDM3RDA6MUQ3NkIzOjZBRkIwRTUyIiwidmlzaXRvcl9pZCI6IjE2ODI0MTY4MTcwOTMxNTIzMzgiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | a6014a00af2503c2594bd6e51222068e8c242b8e533cfc27bcaf1c695e2751e2 |
| hovercard-subject-tag | pull_request:5057563490 |
| github-keyboard-shortcuts | repository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | ///pull_requests/show/commits |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/simstudioai/sim/pull/9419/commits |
| twitter:image | https://opengraph.githubassets.com/038e619571b0a56e589a0cc8c7814798bc39706c20191853f981c268cf31c617/simstudioai/sim/pull/9419 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/038e619571b0a56e589a0cc8c7814798bc39706c20191853f981c268cf31c617/simstudioai/sim/pull/9419 |
| og:image:alt | Summary
Cuts Sim's heaviest database work and closes cleanup gaps. Each change was checked against production query statistics and plans first; reads return the same results as before.
Billing
... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | waleedlatif1 |
| hostname | github.com |
| expected-hostname | github.com |
| None | 4275ec98d19a530a209480d02854be81de24ad5a05b648333242fc516bfb573c |
| turbo-cache-control | no-cache |
| go-import | github.com/simstudioai/sim git https://github.com/simstudioai/sim.git |
| octolytics-dimension-user_id | 199344406 |
| octolytics-dimension-user_login | simstudioai |
| octolytics-dimension-repository_id | 912559512 |
| octolytics-dimension-repository_nwo | simstudioai/sim |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 912559512 |
| octolytics-dimension-repository_network_root_nwo | simstudioai/sim |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | ba13208acc32a4e7a4a3b54cb2f0dea6001ba5f8 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | pull-requests |
| Skip to content | https://github.com/simstudioai/sim/pull/9419/commits#start-of-content |
| https://github.com/ |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F9419%2Fcommits |
| GitHubRepository hosting, code review, and collaboration | https://github.com/platform |
| CopilotAI coding agent for tasks, projects, and automated work | https://github.com/features/copilot |
| ActionsCI/CD and automation | https://github.com/features/actions |
| Code QualityQuality analysis, fixes, and enforcement | https://github.com/features/code-quality |
| CodespacesCloud development environments | https://github.com/features/codespaces |
| Code SecurityVulnerability detection and remediation | https://github.com/security/advanced-security/code-security |
| Secret ProtectionSecret scanning and leak prevention | https://github.com/security/advanced-security/secret-protection |
| All Features | https://github.com/features |
| Documentation | https://docs.github.com/en |
| Training | https://learn.github.com/skills |
| Certifications | https://learn.github.com/credentials |
| Build with Copilot | https://github.com/features/ai |
| Customize Copilot | https://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview |
| Integrations | https://github.com/marketplace |
| Trending repos | https://github.com/trending |
| GitHub Sponsors | https://github.com/open-source/sponsors |
| Developer articles | https://github.com/resources/articles |
| ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place. | https://github.blog/changelog/ |
| Enterprises | https://github.com/enterprise |
| Team | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| Healthcare | https://github.com/solutions/industry/healthcare |
| Financial services | https://github.com/solutions/industry/financial-services |
| Manufacturing | https://github.com/solutions/industry/manufacturing |
| Government | https://github.com/solutions/industry/government |
| See all industries | https://github.com/solutions/industry |
| Why GitHub | https://github.com/why-github |
| Customer Stories | https://github.com/customer-stories |
| Business insights | https://github.com/solutions/executive-insights |
| Trust Center | https://github.com/trust-center |
| GitHub Advanced SecurityEnterprise-grade code security | https://github.com/security/advanced-security |
| Copilot for businessEnterprise-grade AI features | https://github.com/features/copilot/copilot-business |
| Premium SupportEnterprise-grade 24/7 support | https://github.com/enterprise/premium-support |
| Documentation | https://docs.github.com/en |
| Resource center | https://github.com/resources |
| Blog | https://github.blog/ |
| Events & webinars | https://github.com/resources/events |
| Community Forum | https://github.com/orgs/community/discussions |
| Customer Stories | https://github.com/customer-stories |
| Integrations | https://github.com/marketplace |
| Customer support | https://help.github.com/ |
| Training | https://learn.github.com/skills |
| GitHub Status | https://www.githubstatus.com/ |
| About | https://github.com/about |
| Partners | https://github.com/partners |
| Changelog | https://github.blog/changelog/ |
| GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub. | https://githubuniverse.com/ |
| Pricing | https://github.com/pricing |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F9419%2Fcommits |
| Sign up | https://github.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=simstudioai%2Fsim |
| Reload | https://github.com/simstudioai/sim/pull/9419/commits |
| Reload | https://github.com/simstudioai/sim/pull/9419/commits |
| Reload | https://github.com/simstudioai/sim/pull/9419/commits |
| simstudioai | https://github.com/simstudioai |
| sim | https://github.com/simstudioai/sim |
| Code | https://github.com/simstudioai/sim |
| Issues129 (129) | https://github.com/simstudioai/sim/issues |
| Pull requests198 (198) | https://github.com/simstudioai/sim/pulls |
| Actions | https://github.com/simstudioai/sim/actions |
| Projects | https://github.com/simstudioai/sim/projects |
| Security and quality | https://github.com/simstudioai/sim/security |
| Insights | https://github.com/simstudioai/sim/pulse |
| https://github.com/simstudioai/sim |
| waleedlatif1 | https://github.com/waleedlatif1 |
| staging | https://github.com/simstudioai/sim/tree/staging |
| perf/db-hot-paths | https://github.com/simstudioai/sim/tree/perf/db-hot-paths |
| Conversation | https://github.com/simstudioai/sim/pull/9419 |
| Commits24 (24) | https://github.com/simstudioai/sim/pull/9419/commits |
| Checks | https://github.com/simstudioai/sim/pull/9419/checks |
| Files changed | https://github.com/simstudioai/sim/pull/9419/files |
| perf(db): cut hot-path database work and close copilot cleanup gaps | https://github.com/simstudioai/sim/pull/9419/commits#top |
| waleedlatif1 | https://github.com/waleedlatif1 |
| staging | https://github.com/simstudioai/sim/tree/staging |
| perf/db-hot-paths | https://github.com/simstudioai/sim/tree/perf/db-hot-paths |
| fix(billing): revoke a removed member's sessions after the workspace handoff locks | https://github.com/simstudioai/sim/pull/9419/commits/5c99b5bc120a37480006dce98a243cf4995665c5 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 5c99b5b | https://github.com/simstudioai/sim/pull/9419/commits/5c99b5bc120a37480006dce98a243cf4995665c5 |
| https://github.com/simstudioai/sim/tree/5c99b5bc120a37480006dce98a243cf4995665c5 |
| perf(billing): admit wand and chat-title model calls through the usage gate cache | https://github.com/simstudioai/sim/pull/9419/commits/c9212090d62349ff1458cbf812760ee3f7abd869 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| c921209 | https://github.com/simstudioai/sim/pull/9419/commits/c9212090d62349ff1458cbf812760ee3f7abd869 |
| https://github.com/simstudioai/sim/tree/c9212090d62349ff1458cbf812760ee3f7abd869 |
| perf(workflows): withhold the deployed state blob when this process already caches it | https://github.com/simstudioai/sim/pull/9419/commits/265cacef4269c7a480f5cd61c8d8778f2ff71b68 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 265cace | https://github.com/simstudioai/sim/pull/9419/commits/265cacef4269c7a480f5cd61c8d8778f2ff71b68 |
| https://github.com/simstudioai/sim/tree/265cacef4269c7a480f5cd61c8d8778f2ff71b68 |
| perf(audit-logs): read each scope branch through its keyset index | https://github.com/simstudioai/sim/pull/9419/commits/152f5b824f03953c5a61eb428a88a51113169f08 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 152f5b8 | https://github.com/simstudioai/sim/pull/9419/commits/152f5b824f03953c5a61eb428a88a51113169f08 |
| https://github.com/simstudioai/sim/tree/152f5b824f03953c5a61eb428a88a51113169f08 |
| perf(tables): fetch only the mutated workspace's table triggers | https://github.com/simstudioai/sim/pull/9419/commits/f3f57b990b6e0a9b7d9d3f5307b8bc65dd0e1b45 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| f3f57b9 | https://github.com/simstudioai/sim/pull/9419/commits/f3f57b990b6e0a9b7d9d3f5307b8bc65dd0e1b45 |
| https://github.com/simstudioai/sim/tree/f3f57b990b6e0a9b7d9d3f5307b8bc65dd0e1b45 |
| perf(audit): hold a run's rollups for a minute instead of two seconds | https://github.com/simstudioai/sim/pull/9419/commits/03ca9c53f00c9cf00bd801d243e64443ca051441 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 03ca9c5 | https://github.com/simstudioai/sim/pull/9419/commits/03ca9c53f00c9cf00bd801d243e64443ca051441 |
| https://github.com/simstudioai/sim/tree/03ca9c53f00c9cf00bd801d243e64443ca051441 |
| perf(file-search): lock only the files a backfill page actually seeds | https://github.com/simstudioai/sim/pull/9419/commits/c25eab556c58eede70bb8591a6b8671f2d39f2a3 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| c25eab5 | https://github.com/simstudioai/sim/pull/9419/commits/c25eab556c58eede70bb8591a6b8671f2d39f2a3 |
| https://github.com/simstudioai/sim/tree/c25eab556c58eede70bb8591a6b8671f2d39f2a3 |
| perf(knowledge): count a completed listing window by window | https://github.com/simstudioai/sim/pull/9419/commits/0fe01409d2d4e958d425c58b0306470158cfdfd4 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 0fe0140 | https://github.com/simstudioai/sim/pull/9419/commits/0fe01409d2d4e958d425c58b0306470158cfdfd4 |
| https://github.com/simstudioai/sim/tree/0fe01409d2d4e958d425c58b0306470158cfdfd4 |
| perf(files): coalesce workspace list invalidation broadcasts per tab | https://github.com/simstudioai/sim/pull/9419/commits/120b88703c572c81d33536f66df7c8a801c5845b |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 120b887 | https://github.com/simstudioai/sim/pull/9419/commits/120b88703c572c81d33536f66df7c8a801c5845b |
| https://github.com/simstudioai/sim/tree/120b88703c572c81d33536f66df7c8a801c5845b |
| fix(copilot): purge the copilot backend and stored files when a chat is hard-deleted | https://github.com/simstudioai/sim/pull/9419/commits/ca8dd7e7642c47be40d827702faafcbabdf2f8a6 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| ca8dd7e | https://github.com/simstudioai/sim/pull/9419/commits/ca8dd7e7642c47be40d827702faafcbabdf2f8a6 |
| https://github.com/simstudioai/sim/tree/ca8dd7e7642c47be40d827702faafcbabdf2f8a6 |
| fix(copilot): queue copilot backend cleanup for chats an account removal cascades away | https://github.com/simstudioai/sim/pull/9419/commits/f40a58e94930e43dd6f06da87eb4c94e2fedc4c0 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| f40a58e | https://github.com/simstudioai/sim/pull/9419/commits/f40a58e94930e43dd6f06da87eb4c94e2fedc4c0 |
| https://github.com/simstudioai/sim/tree/f40a58e94930e43dd6f06da87eb4c94e2fedc4c0 |
| improvement(outbox): prune completed checkpoint expiry, file, memory and chat cleanup events | https://github.com/simstudioai/sim/pull/9419/commits/ab4448f3e0b464b87ded6e8b6e638d4072d11d4f |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| ab4448f | https://github.com/simstudioai/sim/pull/9419/commits/ab4448f3e0b464b87ded6e8b6e638d4072d11d4f |
| https://github.com/simstudioai/sim/tree/ab4448f3e0b464b87ded6e8b6e638d4072d11d4f |
| perf(idempotency): drop the full-table stat scans and resume each cleanup batch where the last ended | https://github.com/simstudioai/sim/pull/9419/commits/81c750d01686cba3b36f2f3c765c062a664d41c0 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 81c750d | https://github.com/simstudioai/sim/pull/9419/commits/81c750d01686cba3b36f2f3c765c062a664d41c0 |
| https://github.com/simstudioai/sim/tree/81c750d01686cba3b36f2f3c765c062a664d41c0 |
| perf(db): drop prefix-covered indexes and vacuum churn-heavy tables sooner | https://github.com/simstudioai/sim/pull/9419/commits/f35d8ce70e207c081cd8252255e2ee7f828a0d87 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| f35d8ce | https://github.com/simstudioai/sim/pull/9419/commits/f35d8ce70e207c081cd8252255e2ee7f828a0d87 |
| https://github.com/simstudioai/sim/tree/f35d8ce70e207c081cd8252255e2ee7f828a0d87 |
| perf(db): cover usage_log period sums with one index led by both period stamps | https://github.com/simstudioai/sim/pull/9419/commits/2d4a0dd6a27bfae1a0f4288ac4cea1e046985000 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 2d4a0dd | https://github.com/simstudioai/sim/pull/9419/commits/2d4a0dd6a27bfae1a0f4288ac4cea1e046985000 |
| https://github.com/simstudioai/sim/tree/2d4a0dd6a27bfae1a0f4288ac4cea1e046985000 |
| chore(outbox): read the retention suite's database through a typed handle | https://github.com/simstudioai/sim/pull/9419/commits/da014cbc761f9e93a1d51943061c748b5346c162 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| da014cb | https://github.com/simstudioai/sim/pull/9419/commits/da014cbc761f9e93a1d51943061c748b5346c162 |
| https://github.com/simstudioai/sim/tree/da014cbc761f9e93a1d51943061c748b5346c162 |
| improvement(files): drop the unobserved folder-tree room callback memo and a pre-existing-behavior test | https://github.com/simstudioai/sim/pull/9419/commits/405d5f622cde6998764bd97c21cbd80e26b72a23 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 405d5f6 | https://github.com/simstudioai/sim/pull/9419/commits/405d5f622cde6998764bd97c21cbd80e26b72a23 |
| https://github.com/simstudioai/sim/tree/405d5f622cde6998764bd97c21cbd80e26b72a23 |
| revert(billing): read the usage gate fresh for wand and chat-title model calls | https://github.com/simstudioai/sim/pull/9419/commits/0c598668e3bd3c65ad2879aa6ef476b659b1ee6e |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 0c59866 | https://github.com/simstudioai/sim/pull/9419/commits/0c598668e3bd3c65ad2879aa6ef476b659b1ee6e |
| https://github.com/simstudioai/sim/tree/0c598668e3bd3c65ad2879aa6ef476b659b1ee6e |
| fix(copilot): record a deleted chat's backend and file purge durably with its delete | https://github.com/simstudioai/sim/pull/9419/commits/bde298c237133127c1eb37855823478211ca18f3 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| bde298c | https://github.com/simstudioai/sim/pull/9419/commits/bde298c237133127c1eb37855823478211ca18f3 |
| https://github.com/simstudioai/sim/tree/bde298c237133127c1eb37855823478211ca18f3 |
| docs(knowledge): say what the windowed reconciliation counts do and do not guarantee | https://github.com/simstudioai/sim/pull/9419/commits/71185092e486e2e0daf51934c7d13e635dd072ad |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 7118509 | https://github.com/simstudioai/sim/pull/9419/commits/71185092e486e2e0daf51934c7d13e635dd072ad |
| https://github.com/simstudioai/sim/tree/71185092e486e2e0daf51934c7d13e635dd072ad |
| chore(copilot): prove the cleanup rollback tests fail on the fixture trigger, not any error | https://github.com/simstudioai/sim/pull/9419/commits/99c077748c6b2813ae2eb131ac286632bf004bd8 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 99c0777 | https://github.com/simstudioai/sim/pull/9419/commits/99c077748c6b2813ae2eb131ac286632bf004bd8 |
| https://github.com/simstudioai/sim/tree/99c077748c6b2813ae2eb131ac286632bf004bd8 |
| docs(auth): state what the admin removal cleanup hook cannot cover | https://github.com/simstudioai/sim/pull/9419/commits/6e714dc94619d1bb903d9da4f543462de0482759 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| 6e714dc | https://github.com/simstudioai/sim/pull/9419/commits/6e714dc94619d1bb903d9da4f543462de0482759 |
| https://github.com/simstudioai/sim/tree/6e714dc94619d1bb903d9da4f543462de0482759 |
| revert(audit): keep a run's rollup window at two seconds | https://github.com/simstudioai/sim/pull/9419/commits/d299e7b08b8d9a89fb2a7d8ca3b738f19a07147b |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| d299e7b | https://github.com/simstudioai/sim/pull/9419/commits/d299e7b08b8d9a89fb2a7d8ca3b738f19a07147b |
| https://github.com/simstudioai/sim/tree/d299e7b08b8d9a89fb2a7d8ca3b738f19a07147b |
| perf(billing): bound cycle close's previous-period lookup below the elapsed period | https://github.com/simstudioai/sim/pull/9419/commits/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/simstudioai/sim/commits?author=waleedlatif1 |
| aa7dc4e | https://github.com/simstudioai/sim/pull/9419/commits/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07 |
| https://github.com/simstudioai/sim/tree/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07 |
|
| https://github.com |
| Terms | https://docs.github.com/site-policy/github-terms/github-terms-of-service |
| Privacy | https://docs.github.com/site-policy/privacy-policies/github-privacy-statement |
| Security | https://github.com/security |
| Status | https://www.githubstatus.com/ |
| Community | https://github.community/ |
| Docs | https://docs.github.com/ |
| Contact | https://support.github.com?tags=dotcom-footer |