René's URL Explorer Experiment


Title: fix(webapp): drop unused OrgMember _count aggregate from org-list presenter by ericallam · Pull Request #4587 · triggerdotdev/trigger.dev · GitHub

Open Graph Title: fix(webapp): drop unused OrgMember _count aggregate from org-list presenter by ericallam · Pull Request #4587 · triggerdotdev/trigger.dev

X Title: fix(webapp): drop unused OrgMember _count aggregate from org-list presenter by ericallam · Pull Request #4587 · triggerdotdev/trigger.dev

Description: What OrganizationsPresenter.#getOrganizations selected a Prisma _count.members relation on every org-list load (hit on nearly every dashboard navigation). Prisma lowers that relation _count to a whole-OrgMember-table GROUP BY organizationId aggregate joined onto Organization. The computed membersCount field is read by nothing in the webapp, so the entire aggregate scan is wasted work. This removes the _count select and the membersCount field. The query keeps only the indexed EXISTS membership filter and the org/project selects. Why it's safe membersCount has zero consumers (whole-webapp grep finds the name only at the point of assignment). It was added in #1796 (2023) and has been unused since. The member count shown on the org settings/team page comes from a separate presenter query, not this one. No user-visible change. Evidence (generated SQL, before/after, seeded isolated stack) Before (with _count.members): SELECT ..., COALESCE(aggr._aggr_count_members, 0) FROM "Organization" LEFT JOIN (SELECT "organizationId", COUNT(*) AS _aggr_count_members FROM "OrgMember" GROUP BY "organizationId") aggr ON ... WHERE EXISTS (... "userId" = $1 ...) AND "deletedAt" IS NULL ORDER BY "createdAt" DESC After: SELECT id, slug, title, avatar, "featureFlags" FROM "Organization" WHERE EXISTS (... "userId" = $1 ...) AND "deletedAt" IS NULL ORDER BY "createdAt" DESC The whole-table GROUP BY aggregate is gone. The only remaining OrgMember access is the EXISTS on the caller's own membership (indexed by userId, a handful of rows). This is the single largest read-amplification query on the control-plane database (~1.39B rows read/day, ~719s DB CPU/day per Insights); removing it takes that portion to zero. Webapp typecheck passes. Rollout Straight deploy, zero blast radius. Rollback is a plain revert, no data migration. refs TRI-13170

Open Graph Description: What OrganizationsPresenter.#getOrganizations selected a Prisma _count.members relation on every org-list load (hit on nearly every dashboard navigation). Prisma lowers that relation _count to a wh...

X Description: What OrganizationsPresenter.#getOrganizations selected a Prisma _count.members relation on every org-list load (hit on nearly every dashboard navigation). Prisma lowers that relation _count to a wh...

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

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:5510a0db-c2a4-9a84-2064-bf21e6a60de0
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD654:18F46D:7363A:A2755:6AFAF3DD
html-safe-nonce9e5e3c319c926b924947b3ca805bbfb482f8e4665f3950b7ca64c7d28426959a
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJENjU0OjE4RjQ2RDo3MzYzQTpBMjc1NTo2QUZBRjNERCIsInZpc2l0b3JfaWQiOiIzODg3NjgzNTg5MjkzOTI5NDM4IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac36934abfb810bf6e85b8ef89ff468b5e94c6754a53c940fa40ec63c01fb1101e
hovercard-subject-tagpull_request:4262291317
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/4587/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:altWhat OrganizationsPresenter.#getOrganizations selected a Prisma _count.members relation on every org-list load (hit on nearly every dashboard navigation). Prisma lowers that relation _count to a wh...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None0178036d8230524a18422872393ab7e708443ae4c2047f758560a2db870c1913
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
releasea85e96a83bed7871993e6b1ffda24105928eee17
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/triggerdotdev/trigger.dev/pull/4587/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ftriggerdotdev%2Ftrigger.dev%2Fpull%2F4587%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%2F4587%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/4587/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4587/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4587/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-13170-org-list-member-count-aggregate-reads-139b-rowsday-719s-dbhttps://github.com/triggerdotdev/trigger.dev/tree/feature/tri-13170-org-list-member-count-aggregate-reads-139b-rowsday-719s-db
Conversation 5 https://github.com/triggerdotdev/trigger.dev/pull/4587
Commits 1 https://github.com/triggerdotdev/trigger.dev/pull/4587/commits
Checks 49 https://github.com/triggerdotdev/trigger.dev/pull/4587/checks
Files changed https://github.com/triggerdotdev/trigger.dev/pull/4587/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4587/files
fix(webapp): drop unused OrgMember _count aggregate from org-list presenter https://github.com/triggerdotdev/trigger.dev/pull/4587/files#top
Show all changes 1 commit https://github.com/triggerdotdev/trigger.dev/pull/4587/files
43e9ff6 fix(webapp): drop unused OrgMember _count aggregate from org-list pre… ericallam Aug 12, 2026 https://github.com/triggerdotdev/trigger.dev/pull/4587/commits/43e9ff6d3b8309a28688b134716a7d47a80a23cf
Clear filters https://github.com/triggerdotdev/trigger.dev/pull/4587/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4587/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4587/files
org-list-member-count.md https://github.com/triggerdotdev/trigger.dev/pull/4587/files#diff-e73d3e7d5a229275295c0435ab79de4fd5f9a5acfef3c95f2720867eeea2246c
OrganizationsPresenter.server.ts https://github.com/triggerdotdev/trigger.dev/pull/4587/files#diff-d97a8bf2ae4a284bf48caec0a72c5fb1f2986f12584554be07e9e7a7ddab25f8
.server-changes/org-list-member-count.mdhttps://github.com/triggerdotdev/trigger.dev/pull/4587/files#diff-e73d3e7d5a229275295c0435ab79de4fd5f9a5acfef3c95f2720867eeea2246c
View file https://github.com/triggerdotdev/trigger.dev/blob/43e9ff6d3b8309a28688b134716a7d47a80a23cf/.server-changes/org-list-member-count.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4587/{{ revealButtonHref }}
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4587/files
apps/webapp/app/presenters/OrganizationsPresenter.server.tshttps://github.com/triggerdotdev/trigger.dev/pull/4587/files#diff-d97a8bf2ae4a284bf48caec0a72c5fb1f2986f12584554be07e9e7a7ddab25f8
View file https://github.com/triggerdotdev/trigger.dev/blob/43e9ff6d3b8309a28688b134716a7d47a80a23cf/apps/webapp/app/presenters/OrganizationsPresenter.server.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4587/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/4587/files#diff-d97a8bf2ae4a284bf48caec0a72c5fb1f2986f12584554be07e9e7a7ddab25f8
https://github.com/triggerdotdev/trigger.dev/pull/4587/files#diff-d97a8bf2ae4a284bf48caec0a72c5fb1f2986f12584554be07e9e7a7ddab25f8
https://github.com/triggerdotdev/trigger.dev/pull/4587/files#diff-d97a8bf2ae4a284bf48caec0a72c5fb1f2986f12584554be07e9e7a7ddab25f8
https://github.com/triggerdotdev/trigger.dev/pull/4587/files#diff-d97a8bf2ae4a284bf48caec0a72c5fb1f2986f12584554be07e9e7a7ddab25f8
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4587/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.