René's URL Explorer Experiment


Title: fix(db): index large-value workflow_id FKs so workflow deletes don't seq-scan by TheodoreSpeaks · Pull Request #6136 · simstudioai/sim · GitHub

Open Graph Title: fix(db): index large-value workflow_id FKs so workflow deletes don't seq-scan by TheodoreSpeaks · Pull Request #6136 · simstudioai/sim

X Title: fix(db): index large-value workflow_id FKs so workflow deletes don't seq-scan by TheodoreSpeaks · Pull Request #6136 · simstudioai/sim

Description: Summary execution_large_values.workflow_id and execution_large_value_references.workflow_id are ON DELETE SET NULL FKs (since 0212) with no index leading on that column Postgres runs the SET NULL action as an AFTER ROW trigger — UPDATE ... SET workflow_id = NULL WHERE workflow_id = $1 once per deleted parent row — so every DELETE FROM workflow seq-scans both tables per workflow The cost is proportional to table size x workflows deleted per statement, so it was invisible while the retention job kept the archived-workflow backlog small. That job last dispatched in prod on 2026-05-22 (per trigger.dev run history); whenever it resumes it faces ~10 weeks of accumulated backlog, and those deletes would blow the statement timeout 0278 adds an index on both columns, built CONCURRENTLY below an embedded COMMIT per the runner convention in packages/db/scripts/migrate.ts Neither index serves an app query — both exist to make the referential trigger index-driven Type of Change Bug fix Testing Applied the migration against a local DB: both indexes build and report indisvalid = t, and re-running the file is a no-op (already exists, skipping) — required since everything after the embedded COMMIT runs in autocommit and replays on failure. EXPLAIN on the trigger's predicate now shows Index Scan using execution_large_values_workflow_id_idx (forced with enable_seqscan = off; the local table only has ~2.4k rows). bun run check:migrations origin/staging, bun run lint, and the full audit suite (check:boundaries, check:api-validation:strict, check:utils, check:zustand-v5, check:react-query, check:client-boundary, check:bare-icons, check:icon-paths, check:realtime-prune, skills:check, agent-stream-docs:check) all pass. bun run type-check exits 0. Note for deploy: CONCURRENTLY does two table passes and waits out in-flight transactions, so the build will run for a while on prod-sized tables — worth checking indisvalid after, since a failed concurrent build leaves an INVALID index that the next IF NOT EXISTS silently skips. Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing No new warnings introduced I confirm that I have read and agree to the terms outlined in the Contributor License Agreement (CLA)

Open Graph Description: Summary execution_large_values.workflow_id and execution_large_value_references.workflow_id are ON DELETE SET NULL FKs (since 0212) with no index leading on that column Postgres runs the SET NULL ...

X Description: Summary execution_large_values.workflow_id and execution_large_value_references.workflow_id are ON DELETE SET NULL FKs (since 0212) with no index leading on that column Postgres runs the SET NULL ...

Opengraph URL: https://github.com/simstudioai/sim/pull/6136

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,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/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:1a36fede-1aff-ccc6-1809-fe1decac30f6
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id8C32:19FA2E:901CC0:CC526C:6AFB5077
html-safe-nonce49ea6f5bf7acba6e2267ed6b5259862d473ee1e6fdb2be24a8f1b0e729eaca48
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4QzMyOjE5RkEyRTo5MDFDQzA6Q0M1MjZDOjZBRkI1MDc3IiwidmlzaXRvcl9pZCI6IjQzMDc5NTU4MzcyNDM3MDc1MTEiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmaca67947912a58d6789e6ef89b48486b4e9e7090ec1d0aa6714dea750e651ec0a7
hovercard-subject-tagpull_request:4181278496
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/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/simstudioai/sim/pull/6136/files
twitter:imagehttps://avatars.githubusercontent.com/u/19564703?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/19564703?s=400&v=4
og:image:altSummary execution_large_values.workflow_id and execution_large_value_references.workflow_id are ON DELETE SET NULL FKs (since 0212) with no index leading on that column Postgres runs the SET NULL ...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None7122bb414b542dba14d71a3f0b9f6fd2abce715b9f5912d082800563e6c806d1
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/simstudioai/sim git https://github.com/simstudioai/sim.git
octolytics-dimension-user_id199344406
octolytics-dimension-user_loginsimstudioai
octolytics-dimension-repository_id912559512
octolytics-dimension-repository_nwosimstudioai/sim
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id912559512
octolytics-dimension-repository_network_root_nwosimstudioai/sim
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releasecbf66c024bb6d10e6955baa7413c54cf13a201bb
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/6136/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F6136%2Ffiles
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
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
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://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/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F6136%2Ffiles
Sign uphttps://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%2Ffiles&source=header-repo&source_repo=simstudioai%2Fsim
Reloadhttps://github.com/simstudioai/sim/pull/6136/files
Reloadhttps://github.com/simstudioai/sim/pull/6136/files
Reloadhttps://github.com/simstudioai/sim/pull/6136/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests197 (197)https://github.com/simstudioai/sim/pulls
Actionshttps://github.com/simstudioai/sim/actions
Projectshttps://github.com/simstudioai/sim/projects
Security and qualityhttps://github.com/simstudioai/sim/security
Insightshttps://github.com/simstudioai/sim/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
TheodoreSpeakshttps://github.com/TheodoreSpeaks
staginghttps://github.com/simstudioai/sim/tree/staging
feat/soft-delete-run-budgethttps://github.com/simstudioai/sim/tree/feat/soft-delete-run-budget
Conversation 4 https://github.com/simstudioai/sim/pull/6136
Commits 1 https://github.com/simstudioai/sim/pull/6136/commits
Checks 28 https://github.com/simstudioai/sim/pull/6136/checks
Files changed https://github.com/simstudioai/sim/pull/6136/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/6136/files
fix(db): index large-value workflow_id FKs so workflow deletes don't seq-scan https://github.com/simstudioai/sim/pull/6136/files#top
Show all changes 1 commit https://github.com/simstudioai/sim/pull/6136/files
8746c4a fix(db): index large-value workflow_id FKs so workflow deletes don't … TheodoreSpeaks Jul 31, 2026 https://github.com/simstudioai/sim/pull/6136/commits/8746c4af028e4ab5247edcfcf80667dc134a3cbd
Clear filters https://github.com/simstudioai/sim/pull/6136/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/6136/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/6136/files
0278_charming_imperial_guard.sql https://github.com/simstudioai/sim/pull/6136/files#diff-43a835cab102456fe579652e852f5e1e4ce10daed46a894ba66abd182302549e
0278_snapshot.json https://github.com/simstudioai/sim/pull/6136/files#diff-63fd6a308c21c022b41315fc392987943e87514818c4d093b3d6ca09e21fe2aa
_journal.json https://github.com/simstudioai/sim/pull/6136/files#diff-37150cc65ad16ee6fbc5fa318fc096be7730e16d63eaf863e3df5521b7030649
schema.ts https://github.com/simstudioai/sim/pull/6136/files#diff-9a959e2ce3cb4c86957bbae021d06eae364f7b0cb18964f5873bab53220af928
packages/db/migrations/0278_charming_imperial_guard.sqlhttps://github.com/simstudioai/sim/pull/6136/files#diff-43a835cab102456fe579652e852f5e1e4ce10daed46a894ba66abd182302549e
View file https://github.com/simstudioai/sim/blob/8746c4af028e4ab5247edcfcf80667dc134a3cbd/packages/db/migrations/0278_charming_imperial_guard.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/6136/{{ revealButtonHref }}
greptile-appshttps://github.com/apps/greptile-apps
Jul 31, 2026https://github.com/simstudioai/sim/pull/6136/files#r3693707342
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
https://github.com/simstudioai/sim/pull/6136/files
Database schema and migrations (packages/db)https://app.greptile.com/sim/-/custom-context/knowledge-base/simstudioai/sim/-/docs/database-schema.md
Please reload this pagehttps://github.com/simstudioai/sim/pull/6136/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/6136/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/6136/files
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.