René's URL Explorer Experiment


Title: perf(run-ops-database): index BatchTaskRun for the batches list on the dedicated schema by ericallam · Pull Request #4396 · triggerdotdev/trigger.dev · GitHub

Open Graph Title: perf(run-ops-database): index BatchTaskRun for the batches list on the dedicated schema by ericallam · Pull Request #4396 · triggerdotdev/trigger.dev

X Title: perf(run-ops-database): index BatchTaskRun for the batches list on the dedicated schema by ericallam · Pull Request #4396 · triggerdotdev/trigger.dev

Description: Summary The batches list page orders by (createdAt DESC, id DESC), which is why #4361 added a matching index on BatchTaskRun. That index only landed in @trigger.dev/database. The dedicated run-ops database has its own migration history, so it never received the index. BatchListPresenter reads both databases and merges, so for environments whose batches live in the dedicated database the page kept falling back to a scan and in-memory sort, which is the exact behaviour #4361 set out to fix. Fix Adds the index to the run-ops schema with its own migration. CREATE INDEX CONCURRENTLY IF NOT EXISTS, so it is a no-op where the index already exists and still records its ledger row. The second half is the interesting part. Because the two packages own separate migration histories, a run-graph schema change has to be authored twice, and nothing made the miss visible: the run-ops status check truthfully reports "up to date" against its own history, so the apply step just skips. schemaParity.test.ts compares the physical shape of every model the run-ops schema declares against its counterpart in @trigger.dev/database: scalar fields with their attributes, plus @@index, @@unique, @@id and @@map. Relation navigation fields are excluded, since the run-ops schema deliberately drops relations that would cross a database boundary while keeping the scalar FK column. A field counts as a relation when its type resolves to a model name, which keeps enum-typed columns in scope. Two models are listed as run-ops-only: CompletedWaitpoint and WaitpointRunConnection, both explicit FK-free replacements for a control-plane implicit many-to-many, since an implicit m2m carries a foreign key that cannot resolve across databases. The test also asserts that exception list is exhaustive, so a new unpaired model fails rather than being silently skipped. Confirmed the guard actually fails: reverting the index turns BatchTaskRun red with the missing @@index named in the diff.

Open Graph Description: Summary The batches list page orders by (createdAt DESC, id DESC), which is why #4361 added a matching index on BatchTaskRun. That index only landed in @trigger.dev/database. The dedicated run-ops ...

X Description: Summary The batches list page orders by (createdAt DESC, id DESC), which is why #4361 added a matching index on BatchTaskRun. That index only landed in @trigger.dev/database. The dedicated run-ops ...

Opengraph URL: https://github.com/triggerdotdev/trigger.dev/pull/4396

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:97a0a33d-b4b4-81f7-f027-7ddc5ad31c3d
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD090:137618:1646C0:1F7FCD:6AFAFB10
html-safe-nonce05d87cbbcef7813f50cca1ef9c11cb8a98245924c8518dfa3c541a6862c569f1
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEMDkwOjEzNzYxODoxNjQ2QzA6MUY3RkNEOjZBRkFGQjEwIiwidmlzaXRvcl9pZCI6Ijg1NzUwMjA5OTQxNjkzMzg2NDAiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacf8ebe1a1aa62df42ecb447927cd1b670d0ba91ff9630c598d92214f48f5dd75e
hovercard-subject-tagpull_request:4143155414
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/triggerdotdev/trigger.dev/pull/4396/files
twitter:imagehttps://avatars.githubusercontent.com/u/534?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/534?s=400&v=4
og:image:altSummary The batches list page orders by (createdAt DESC, id DESC), which is why #4361 added a matching index on BatchTaskRun. That index only landed in @trigger.dev/database. The dedicated run-ops ...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None54f7a6886649661c85eee945cca0773566bfb4065370e0429b7c8f7204184650
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/triggerdotdev/trigger.dev git https://github.com/triggerdotdev/trigger.dev.git
octolytics-dimension-user_id95297378
octolytics-dimension-user_logintriggerdotdev
octolytics-dimension-repository_id572570113
octolytics-dimension-repository_nwotriggerdotdev/trigger.dev
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id572570113
octolytics-dimension-repository_network_root_nwotriggerdotdev/trigger.dev
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
releasecf8450eb633ec589502c42ff6f4072e40db65da3
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/triggerdotdev/trigger.dev/pull/4396/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ftriggerdotdev%2Ftrigger.dev%2Fpull%2F4396%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%2Ftriggerdotdev%2Ftrigger.dev%2Fpull%2F4396%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=triggerdotdev%2Ftrigger.dev
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4396/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4396/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4396/files
triggerdotdevhttps://github.com/triggerdotdev
trigger.devhttps://github.com/triggerdotdev/trigger.dev
Codehttps://github.com/triggerdotdev/trigger.dev
Issues203 (203)https://github.com/triggerdotdev/trigger.dev/issues
Pull requests67 (67)https://github.com/triggerdotdev/trigger.dev/pulls
Discussionshttps://github.com/triggerdotdev/trigger.dev/discussions
Actionshttps://github.com/triggerdotdev/trigger.dev/actions
Projectshttps://github.com/triggerdotdev/trigger.dev/projects
Security and quality39 (39)https://github.com/triggerdotdev/trigger.dev/security
Insightshttps://github.com/triggerdotdev/trigger.dev/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Ftriggerdotdev%2Ftrigger.dev%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Ftriggerdotdev%2Ftrigger.dev%2Fissues%2Fnew%2Fchoose
ericallamhttps://github.com/ericallam
mainhttps://github.com/triggerdotdev/trigger.dev/tree/main
feature/tri-12596-apply-the-shared-prisma-history-to-all-three-databaseshttps://github.com/triggerdotdev/trigger.dev/tree/feature/tri-12596-apply-the-shared-prisma-history-to-all-three-databases
Conversation 7 https://github.com/triggerdotdev/trigger.dev/pull/4396
Commits 1 https://github.com/triggerdotdev/trigger.dev/pull/4396/commits
Checks 58 https://github.com/triggerdotdev/trigger.dev/pull/4396/checks
Files changed https://github.com/triggerdotdev/trigger.dev/pull/4396/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4396/files
perf(run-ops-database): index BatchTaskRun for the batches list on the dedicated schema https://github.com/triggerdotdev/trigger.dev/pull/4396/files#top
Show all changes 1 commit https://github.com/triggerdotdev/trigger.dev/pull/4396/files
7e82082 perf(run-ops-database): index BatchTaskRun for the batches list on th… ericallam Jul 27, 2026 https://github.com/triggerdotdev/trigger.dev/pull/4396/commits/7e82082ab8b7c2725a5ebcb72418296e6c2b7da3
Clear filters https://github.com/triggerdotdev/trigger.dev/pull/4396/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4396/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4396/files
migration.sql https://github.com/triggerdotdev/trigger.dev/pull/4396/files#diff-dfdf9a50fb88c7f99043016218061d1cc1dd5aca98a2ecaa876eafdc65042f00
schema.prisma https://github.com/triggerdotdev/trigger.dev/pull/4396/files#diff-1d971cc50c6329cf20d05d734fdfd6ecdbf3562d51c49243197274334b912317
schemaParity.test.ts https://github.com/triggerdotdev/trigger.dev/pull/4396/files#diff-1e781e794cc3f31316dbe26f16f68419c85c0551a9815269349324075b0f1f72
...sma/migrations/20260727120000_add_batch_task_run_created_at_dashboard_index/migration.sqlhttps://github.com/triggerdotdev/trigger.dev/pull/4396/files#diff-dfdf9a50fb88c7f99043016218061d1cc1dd5aca98a2ecaa876eafdc65042f00
View file https://github.com/triggerdotdev/trigger.dev/blob/7e82082ab8b7c2725a5ebcb72418296e6c2b7da3/internal-packages/run-ops-database/prisma/migrations/20260727120000_add_batch_task_run_created_at_dashboard_index/migration.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4396/{{ revealButtonHref }}
internal-packages/run-ops-database/prisma/schema.prismahttps://github.com/triggerdotdev/trigger.dev/pull/4396/files#diff-1d971cc50c6329cf20d05d734fdfd6ecdbf3562d51c49243197274334b912317
View file https://github.com/triggerdotdev/trigger.dev/blob/7e82082ab8b7c2725a5ebcb72418296e6c2b7da3/internal-packages/run-ops-database/prisma/schema.prisma
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4396/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/4396/files#diff-1d971cc50c6329cf20d05d734fdfd6ecdbf3562d51c49243197274334b912317
https://github.com/triggerdotdev/trigger.dev/pull/4396/files#diff-1d971cc50c6329cf20d05d734fdfd6ecdbf3562d51c49243197274334b912317
internal-packages/run-ops-database/src/schemaParity.test.tshttps://github.com/triggerdotdev/trigger.dev/pull/4396/files#diff-1e781e794cc3f31316dbe26f16f68419c85c0551a9815269349324075b0f1f72
View file https://github.com/triggerdotdev/trigger.dev/blob/7e82082ab8b7c2725a5ebcb72418296e6c2b7da3/internal-packages/run-ops-database/src/schemaParity.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4396/{{ revealButtonHref }}
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4396/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.