| 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 | /_view_fragments/voltron/pull_requests/show/:user_id/:repository/:id/pull_request_layout(.:format) |
| route-controller | voltron_pull_requests_fragments |
| route-action | pull_request_layout |
| fetch-nonce | v2:b6f08812-3c68-33c4-2d07-0d22bbc3510a |
| current-catalog-service-hash | ae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b |
| request-id | 9490:1B8129:9BE8EB:D66288:6AFB4DE9 |
| html-safe-nonce | 08b9789e96f9bf9c295a73816642abb0a3d07fe4a775997c18b675cf9f67d707 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5NDkwOjFCODEyOTo5QkU4RUI6RDY2Mjg4OjZBRkI0REU5IiwidmlzaXRvcl9pZCI6IjcyNjI4NjQ1ODIwODU2NjAxMzciLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | d8c31d8ad64e936af1d6bc75c6713858831834dddce5424057dad8b966ac502b |
| hovercard-subject-tag | pull_request:4847652947 |
| 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 | ///voltron/pull_requests_fragments/pull_request_layout |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/voltron/pull_requests/show/simstudioai/sim/8974/pull_request_layout |
| twitter:image | https://opengraph.githubassets.com/6b8fc1f00de8455817b39de92d3cef718f38a7ba6c352d2b28c3a868a4681476/simstudioai/sim/pull/8974 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/6b8fc1f00de8455817b39de92d3cef718f38a7ba6c352d2b28c3a868a4681476/simstudioai/sim/pull/8974 |
| og:image:alt | Summary
The reporting-window usage sum (sum(cost) from usage_log where billing_entity_* = … and created_at in [start, end)) is already an index-only scan. It is expensive only because a year-long w... |
| 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 | acf7616d06cc051644705b379878c9bb13dc5e70ecf4ffd9b34140f8ac01d7e1 |
| 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 | 26504db649b58525278f77a52b80ba5f10d5f4de |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | pull-requests |
| Skip to content | https://github.com/simstudioai/sim/pull/8974#start-of-content |
| https://github.com/ |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8974 |
| 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%2F8974 |
| 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%2Fvoltron%2Fpull_requests_fragments%2Fpull_request_layout&source=header-repo&source_repo=simstudioai%2Fsim |
| Reload | https://github.com/simstudioai/sim/pull/8974 |
| Reload | https://github.com/simstudioai/sim/pull/8974 |
| Reload | https://github.com/simstudioai/sim/pull/8974 |
| 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 requests197 (197) | 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/billing-usage-cache | https://github.com/simstudioai/sim/tree/perf/billing-usage-cache |
| Conversation | https://github.com/simstudioai/sim/pull/8974 |
| Commits3 (3) | https://github.com/simstudioai/sim/pull/8974/commits |
| Checks | https://github.com/simstudioai/sim/pull/8974/checks |
| Files changed | https://github.com/simstudioai/sim/pull/8974/files |
| perf(billing): sum reporting-window usage from a shared prefix plus a short tail | https://github.com/simstudioai/sim/pull/8974#top |
| waleedlatif1 | https://github.com/waleedlatif1 |
| staging | https://github.com/simstudioai/sim/tree/staging |
| perf/billing-usage-cache | https://github.com/simstudioai/sim/tree/perf/billing-usage-cache |
|
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/waleedlatif1 |
| Oct 13, 2026 | https://github.com/simstudioai/sim/pull/8974#issue-5835562708 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
|
| https://github.com/waleedlatif1 |
| perf(billing): sum reporting-window usage from a shared prefix plus a… | https://github.com/simstudioai/sim/pull/8974/commits/edfc4efdeb836161df013e425da2db01d4799d86 |
| edfc4ef | https://github.com/simstudioai/sim/pull/8974/commits/edfc4efdeb836161df013e425da2db01d4799d86 |
| https://github.com/apps/vercel |
| vercel | https://github.com/apps/vercel |
| Oct 13, 2026 | https://github.com/simstudioai/sim/pull/8974#issuecomment-6152351989 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| Vercel for GitHub | https://vercel.link/github-learn-more |
| https://vercel.com/sim-studio/docs |
| docs | https://vercel.com/sim-studio/docs |
| https://camo.githubusercontent.com/1bb29feed7826aff3191ae8ff19d3c61e80fc99f9cc9373030210090f890893b/68747470733a2f2f76657263656c2e636f6d2f7374617469632f7374617475732f63616e63656c65642e737667 |
| Skipped | https://vercel.com/sim-studio/docs/EL99aB1e5VpM7sVPmeJ7BFc63AXy |
| https://vercel.com/vercel-agent/request-review?owner=simstudioai&repo=sim&pr=8974 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
|
| https://github.com/waleedlatif1 |
| perf(billing): refresh the usage prefix every 3 minutes, discard it o… | https://github.com/simstudioai/sim/pull/8974/commits/1f572ca8a4646fdc1edd6619bdd6a2c3c539e506 |
| 1f572ca | https://github.com/simstudioai/sim/pull/8974/commits/1f572ca8a4646fdc1edd6619bdd6a2c3c539e506 |
| https://github.com/apps/cubic-dev-ai |
| cubic-dev-ai | https://github.com/apps/cubic-dev-ai |
|
Oct 13, 2026
| https://github.com/simstudioai/sim/pull/8974#pullrequestreview-5508192863 |
|
View reviewed changes
| https://github.com/simstudioai/sim/pull/8974/files/edfc4efdeb836161df013e425da2db01d4799d86 |
| cubic-dev-ai | https://github.com/apps/cubic-dev-ai |
| https://github.com/simstudioai/sim/pull/8974#pullrequestreview-5508192863 |
| Learn more | https://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment |
| Increase your flex budget | https://www.cubic.dev/settings?tab=usage |
| Turn on auto-fix | https://www.cubic.dev/action/auto-fix/pr/simstudioai/sim/8974?returnTo=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8974 |
| Re-trigger cubic | https://www.cubic.dev/action/re-review/pr/simstudioai/sim/8974/ai_pr_review_github_delivery_bdd67c0c7dc9df03cf66ed5dead20e26ca9dca07c5f3e3c2e3efc4bd7ffc7c14?returnTo=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8974 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://github.com/apps/vercel |
| vercel | https://github.com/apps/vercel |
| temporarily deployed | https://docs-ltftyny1i-sim-studio.vercel.app |
| October 13, 2026 18:31 | https://github.com/simstudioai/sim/pull/8974#event-33161114200 |
| https://github.com/apps/greptile-apps |
| greptile-apps | https://github.com/apps/greptile-apps |
| Oct 13, 2026 | https://github.com/simstudioai/sim/pull/8974#issuecomment-6152519213 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://app.greptile.com/api/retrigger?id=80095734 |
| https://camo.githubusercontent.com/7e47c9613406aca1173f09b30d9d9ae0938a504fddfe42e5593850b85c537861/68747470733a2f2f6772657074696c652d7374617469632d6173736574732e73332e616d617a6f6e6177732e636f6d2f6261646765732f70322e7376673f763d39 |
| ▶ | https://github.com/simstudioai/sim/pull/8974#discussion_r4262553627 |
| "fix(billing): discard a payer's usage pr..." | https://github.com/simstudioai/sim/commit/96385cce35f18def3cfa0ba84a453b5cc3114e34 |
| Reviewed by Greptile | https://www.greptile.com/?utm_source=greptile_expert&utm_medium=github&utm_campaign=code_reviews&utm_content=simstudioai/sim |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://github.com/apps/greptile-apps |
| greptile-apps | https://github.com/apps/greptile-apps |
|
Oct 13, 2026
| https://github.com/simstudioai/sim/pull/8974#pullrequestreview-5508246892 |
|
View reviewed changes
| https://github.com/simstudioai/sim/pull/8974/files/edfc4efdeb836161df013e425da2db01d4799d86 |
| apps/sim/lib/billing/core/reporting-usage-cache.ts | https://github.com/simstudioai/sim/pull/8974/files/edfc4efdeb836161df013e425da2db01d4799d86#diff-977dfbb8bb7a097f1980636fd3a5e4b78fdcafae0905d0fbd941eba44a35ab7f |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| apps/sim/lib/billing/core/reporting-usage-cache.ts | https://github.com/simstudioai/sim/pull/8974/files/edfc4efdeb836161df013e425da2db01d4799d86#diff-977dfbb8bb7a097f1980636fd3a5e4b78fdcafae0905d0fbd941eba44a35ab7f |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
|
| https://github.com/waleedlatif1 |
| fix(billing): discard a payer's usage prefix when a top-up raises a r… | https://github.com/simstudioai/sim/pull/8974/commits/96385cce35f18def3cfa0ba84a453b5cc3114e34 |
| 96385cc | https://github.com/simstudioai/sim/pull/8974/commits/96385cce35f18def3cfa0ba84a453b5cc3114e34 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/waleedlatif1 |
| Oct 13, 2026 | https://github.com/simstudioai/sim/pull/8974#issuecomment-6152638794 |
| @greptile | https://github.com/greptile |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/waleedlatif1 |
| Oct 13, 2026 | https://github.com/simstudioai/sim/pull/8974#issuecomment-6152639200 |
| @cubic-dev-ai | https://github.com/cubic-dev-ai |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://github.com/apps/vercel |
| vercel | https://github.com/apps/vercel |
| temporarily deployed | https://docs-rc72qspvt-sim-studio.vercel.app |
| October 13, 2026 18:42 | https://github.com/simstudioai/sim/pull/8974#event-33161940498 |
| https://github.com/apps/cubic-dev-ai |
| cubic-dev-ai | https://github.com/apps/cubic-dev-ai |
| Oct 13, 2026 | https://github.com/simstudioai/sim/pull/8974#issuecomment-6152641297 |
| @cubic-dev-ai | https://github.com/cubic-dev-ai |
| @waleedlatif1 | https://github.com/waleedlatif1 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://github.com/apps/cubic-dev-ai |
| cubic-dev-ai | https://github.com/apps/cubic-dev-ai |
|
Oct 13, 2026
| https://github.com/simstudioai/sim/pull/8974#pullrequestreview-5508370199 |
|
View reviewed changes
| https://github.com/simstudioai/sim/pull/8974/files/96385cce35f18def3cfa0ba84a453b5cc3114e34 |
| cubic-dev-ai | https://github.com/apps/cubic-dev-ai |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://github.com/simstudioai/sim/pull/8974#pullrequestreview-5508370199 |
| Learn more | https://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment |
| Increase your flex budget | https://www.cubic.dev/settings?tab=usage |
| Turn on auto-fix | https://www.cubic.dev/action/auto-fix/pr/simstudioai/sim/8974?returnTo=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8974 |
| Re-trigger cubic | https://www.cubic.dev/action/re-review/pr/simstudioai/sim/8974/ai_pr_review_1791916970139_fbe1fcff-acc1-40ac-842a-d007adefb13b?returnTo=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8974 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| apps/sim/lib/billing/core/reporting-usage-epoch.ts | https://github.com/simstudioai/sim/pull/8974/files/96385cce35f18def3cfa0ba84a453b5cc3114e34#diff-d701e999f19d01652769c666c736b8a867d285847a36b63c288e8c22351e99d9 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/waleedlatif1 |
| 25da162 | https://github.com/simstudioai/sim/commit/25da1620af06601ca853772d4fac40765a03dbe9 |
| Oct 13, 2026 | https://github.com/simstudioai/sim/pull/8974#event-33163811039 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/waleedlatif1 |
| October 13, 2026 19:12 | https://github.com/simstudioai/sim/pull/8974#event-33164130589 |
| https://github.com/waleedlatif1 |
| waleedlatif1 | https://github.com/waleedlatif1 |
|
Oct 13, 2026
| https://github.com/simstudioai/sim/pull/8974#ref-pullrequest-5837836146 |
|
v0.9.21: gemini 4 argon, db improvements, fivetran integration, search speedups
#8989
| https://github.com/simstudioai/sim/pull/8989 |
| Deployed | https://docs-rc72qspvt-sim-studio.vercel.app |
| vercel[bot] | https://github.com/apps/vercel |
|
View deployment
| https://docs-rc72qspvt-sim-studio.vercel.app |
| https://github.co/hiddenchars |
| https://github.com/simstudioai/sim/pull/{{ revealButtonHref }} |
| Sign up for free | https://github.com/join?source=comment-repo |
| Sign in to comment | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8974 |
|
| https://github.com/apps/greptile-apps |
|
greptile-apps[bot]
| https://github.com/apps/greptile-apps |
|
| https://github.com/simstudioai/sim/pull/8974/files/96385cce35f18def3cfa0ba84a453b5cc3114e34 |
|
| https://github.com/apps/cubic-dev-ai |
|
cubic-dev-ai[bot]
| https://github.com/apps/cubic-dev-ai |
|
| https://github.com/simstudioai/sim/pull/8974/files/96385cce35f18def3cfa0ba84a453b5cc3114e34 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
| Please reload this page | https://github.com/simstudioai/sim/pull/8974 |
|
| https://github.com/waleedlatif1 |
|
| 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 |