René's URL Explorer Experiment


Title: perf(database): index BatchTaskRun on (runtimeEnvironmentId, createdAt, id) for the batches list by ericallam · Pull Request #4361 · triggerdotdev/trigger.dev · GitHub

Open Graph Title: perf(database): index BatchTaskRun on (runtimeEnvironmentId, createdAt, id) for the batches list by ericallam · Pull Request #4361 · triggerdotdev/trigger.dev

X Title: perf(database): index BatchTaskRun on (runtimeEnvironmentId, createdAt, id) for the batches list by ericallam · Pull Request #4361 · triggerdotdev/trigger.dev

Description: Summary The batches list page orders by createdAt DESC, id DESC filtered by environment and a created-at window, but the only supporting index on BatchTaskRun was (runtimeEnvironmentId, id). That index can't satisfy the createdAt ordering, so on environments with a large number of batches the query fell back to a full table scan and in-memory sort, which could run long enough to hit the statement timeout. Fix Adds (runtimeEnvironmentId, createdAt DESC, id DESC) on BatchTaskRun. The query now reads straight from the index in order with no sort step, returning a page with only a handful of heap fetches instead of scanning the whole environment slice. The migration uses CREATE INDEX CONCURRENTLY IF NOT EXISTS, so it takes no table lock and is a no-op if the index already exists.

Open Graph Description: Summary The batches list page orders by createdAt DESC, id DESC filtered by environment and a created-at window, but the only supporting index on BatchTaskRun was (runtimeEnvironmentId, id). That i...

X Description: Summary The batches list page orders by createdAt DESC, id DESC filtered by environment and a created-at window, but the only supporting index on BatchTaskRun was (runtimeEnvironmentId, id). That i...

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

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:e2179f16-6ef8-c1e5-6807-107eae6c9467
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD688:352BFA:6786DC:99F185:6AFAF8FE
html-safe-nonce67b586b9432ec384e2456277f4015fc6940bef16c6fa3d99b5c5379f853a32cf
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJENjg4OjM1MkJGQTo2Nzg2REM6OTlGMTg1OjZBRkFGOEZFIiwidmlzaXRvcl9pZCI6IjI0NDY2NzM3NTU5ODg3NTI2MzgiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac32c5e82bb407941611401e0e5dd58fcc3e838f909e620247305c8c6b32d8a2f3
hovercard-subject-tagpull_request:4123932744
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/4361/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 filtered by environment and a created-at window, but the only supporting index on BatchTaskRun was (runtimeEnvironmentId, id). That i...
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/4361/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ftriggerdotdev%2Ftrigger.dev%2Fpull%2F4361%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%2F4361%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/4361/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4361/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4361/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
perf/batch-list-created-at-indexhttps://github.com/triggerdotdev/trigger.dev/tree/perf/batch-list-created-at-index
Conversation 4 https://github.com/triggerdotdev/trigger.dev/pull/4361
Commits 1 https://github.com/triggerdotdev/trigger.dev/pull/4361/commits
Checks 44 https://github.com/triggerdotdev/trigger.dev/pull/4361/checks
Files changed https://github.com/triggerdotdev/trigger.dev/pull/4361/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4361/files
perf(database): index BatchTaskRun on (runtimeEnvironmentId, createdAt, id) for the batches list https://github.com/triggerdotdev/trigger.dev/pull/4361/files#top
Show all changes 1 commit https://github.com/triggerdotdev/trigger.dev/pull/4361/files
afe280c perf(database): index BatchTaskRun on (runtimeEnvironmentId, createdA… ericallam Jul 24, 2026 https://github.com/triggerdotdev/trigger.dev/pull/4361/commits/afe280cfc86096f447c9ace92d69e4fa31aad0cd
Clear filters https://github.com/triggerdotdev/trigger.dev/pull/4361/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4361/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4361/files
batch-list-created-at-index.md https://github.com/triggerdotdev/trigger.dev/pull/4361/files#diff-797e83fa648fea3d01f428faf0fc3e15d795dead2a493fbad72d3dabeeb448fe
migration.sql https://github.com/triggerdotdev/trigger.dev/pull/4361/files#diff-8b3a8edf1012e092fa37547526cf07aa134dbcef17aab4a123edf03ee00d379f
schema.prisma https://github.com/triggerdotdev/trigger.dev/pull/4361/files#diff-6b8eefc1da429865c9493bbac9d2c4d00d1cfe2f2231f6474b9692f13b88e419
.server-changes/batch-list-created-at-index.mdhttps://github.com/triggerdotdev/trigger.dev/pull/4361/files#diff-797e83fa648fea3d01f428faf0fc3e15d795dead2a493fbad72d3dabeeb448fe
View file https://github.com/triggerdotdev/trigger.dev/blob/afe280cfc86096f447c9ace92d69e4fa31aad0cd/.server-changes/batch-list-created-at-index.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4361/{{ revealButtonHref }}
...sma/migrations/20260724120000_add_batch_task_run_created_at_dashboard_index/migration.sqlhttps://github.com/triggerdotdev/trigger.dev/pull/4361/files#diff-8b3a8edf1012e092fa37547526cf07aa134dbcef17aab4a123edf03ee00d379f
View file https://github.com/triggerdotdev/trigger.dev/blob/afe280cfc86096f447c9ace92d69e4fa31aad0cd/internal-packages/database/prisma/migrations/20260724120000_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/4361/{{ revealButtonHref }}
internal-packages/database/prisma/schema.prismahttps://github.com/triggerdotdev/trigger.dev/pull/4361/files#diff-6b8eefc1da429865c9493bbac9d2c4d00d1cfe2f2231f6474b9692f13b88e419
View file https://github.com/triggerdotdev/trigger.dev/blob/afe280cfc86096f447c9ace92d69e4fa31aad0cd/internal-packages/database/prisma/schema.prisma
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4361/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/4361/files#diff-6b8eefc1da429865c9493bbac9d2c4d00d1cfe2f2231f6474b9692f13b88e419
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4361/files
https://github.com/triggerdotdev/trigger.dev/pull/4361/files#diff-6b8eefc1da429865c9493bbac9d2c4d00d1cfe2f2231f6474b9692f13b88e419
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.