René's URL Explorer Experiment


Title: perf(webapp,clickhouse): move runs empty-state check to ClickHouse by ericallam · Pull Request #4202 · triggerdotdev/trigger.dev · GitHub

Open Graph Title: perf(webapp,clickhouse): move runs empty-state check to ClickHouse by ericallam · Pull Request #4202 · triggerdotdev/trigger.dev

X Title: perf(webapp,clickhouse): move runs empty-state check to ClickHouse by ericallam · Pull Request #4202 · triggerdotdev/trigger.dev

Description: Summary The runs page's empty-state check (whether an environment has ever had a run, which decides between the "getting started" and "no runs match your filters" states) ran a findFirst against the Postgres TaskRun table. This moves it to ClickHouse, the same store the runs list itself reads from, so the check no longer queries TaskRun. Design Only the runs list triggers the check now (via an includeHasAnyRuns flag); the other presenters that reuse NextRunListPresenter (API, schedule detail, waitpoint detail, error group) no longer issue it. When the list is empty it runs SELECT 1 FROM task_runs_v2 ... LIMIT 1 filtered on the full (organization_id, project_id, environment_id) sort-key prefix with a configurable created_at lower bound (RUN_LIST_HAS_RUNS_LOOKBACK_DAYS, default 30), so it hits the primary index and reads minimal granules. Results are cached in a tiered memory + Redis SWR cache. Only positive ("has runs") results are cached, so an environment with no runs is always re-checked and its first run shows up immediately.

Open Graph Description: Summary The runs page's empty-state check (whether an environment has ever had a run, which decides between the "getting started" and "no runs match your filters" states) ra...

X Description: Summary The runs page's empty-state check (whether an environment has ever had a run, which decides between the "getting started" and "no runs match your filters&...

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

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:110571a2-cf5c-8c8e-ab0f-40cf52c7d95a
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idBF10:37FDA8:2E0E529:41F5A69:6AFAF012
html-safe-nonce62b9b2d0cefcfd7603d06f21c3a7d2c4f64895d24bb6c1eb8dd7166deba60820
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCRjEwOjM3RkRBODoyRTBFNTI5OjQxRjVBNjk6NkFGQUYwMTIiLCJ2aXNpdG9yX2lkIjoiNTgzMTYyNjI5NzU5NTA2NDMzOCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac48e369733f9493d531032d8fc89fa2ac574ececfb3f0adb1d7d3c6a7fc29ee55
hovercard-subject-tagpull_request:4022226016
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/4202/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 runs page's empty-state check (whether an environment has ever had a run, which decides between the "getting started" and "no runs match your filters" states) ra...
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
release12fff95459b24b0f882a66698ee6a36a5934d247
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/triggerdotdev/trigger.dev/pull/4202/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ftriggerdotdev%2Ftrigger.dev%2Fpull%2F4202%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%2F4202%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/4202/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4202/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/4202/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-11894-move-runs-list-empty-state-check-to-clickhouse-to-drophttps://github.com/triggerdotdev/trigger.dev/tree/feature/tri-11894-move-runs-list-empty-state-check-to-clickhouse-to-drop
Conversation 10 https://github.com/triggerdotdev/trigger.dev/pull/4202
Commits 2 https://github.com/triggerdotdev/trigger.dev/pull/4202/commits
Checks 50 https://github.com/triggerdotdev/trigger.dev/pull/4202/checks
Files changed https://github.com/triggerdotdev/trigger.dev/pull/4202/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4202/files
perf(webapp,clickhouse): move runs empty-state check to ClickHouse https://github.com/triggerdotdev/trigger.dev/pull/4202/files#top
Show all changes 2 commits https://github.com/triggerdotdev/trigger.dev/pull/4202/files
d314be8 perf(webapp,clickhouse): move runs empty-state check to ClickHouse ericallam Jul 9, 2026 https://github.com/triggerdotdev/trigger.dev/pull/4202/commits/d314be8d0a870a92a305e445721e7fb7a9b19491
87d2fe9 test(webapp): remove obsolete Postgres empty-state probe tests ericallam Jul 9, 2026 https://github.com/triggerdotdev/trigger.dev/pull/4202/commits/87d2fe9ba95ce5983b777200a9d49bbe390a7ca2
Clear filters https://github.com/triggerdotdev/trigger.dev/pull/4202/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4202/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4202/files
runs-empty-state-clickhouse.md https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-cc37a64122765c69d81e55c954d039a686ba84ab5b400984e29b869189673929
env.server.ts https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f8823615ef72da3494e74de9e62b2fa31315ed9360f17bc06ab943f4dc25f4fd
NextRunListPresenter.server.ts https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
route.tsx https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-cdf32f61c82a613fd3443e9058f8ac25c14e35efa92195a60d6062ed493c2f8a
clickhouseRunsRepository.server.ts https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-b3e045298340b0254d793fedcaba256747de056bcdd523bdc467b2987a394968
runsRepository.server.ts https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-fd5167ddce7f3f071edb4eda73f524d5ee109514355ac583869fa24a055f342c
nextRunListPresenter.readthrough.test.ts https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-d1ece2ee0d51f659d1d90c09ebb3812e5d2d6a6b52d610d6b129ffa6570dd88a
index.ts https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-2e6d3213fef546d9f2caf30976ed88b793b2da8ec70f079a4701db7686f00564
taskRuns.ts https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-c09c1bd6e056282ae5228dadb349995243f3fd8c07aa9f7afad5f711a0147a1b
.server-changes/runs-empty-state-clickhouse.mdhttps://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-cc37a64122765c69d81e55c954d039a686ba84ab5b400984e29b869189673929
View file https://github.com/triggerdotdev/trigger.dev/blob/87d2fe9ba95ce5983b777200a9d49bbe390a7ca2/.server-changes/runs-empty-state-clickhouse.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4202/{{ revealButtonHref }}
apps/webapp/app/env.server.tshttps://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f8823615ef72da3494e74de9e62b2fa31315ed9360f17bc06ab943f4dc25f4fd
View file https://github.com/triggerdotdev/trigger.dev/blob/87d2fe9ba95ce5983b777200a9d49bbe390a7ca2/apps/webapp/app/env.server.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4202/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f8823615ef72da3494e74de9e62b2fa31315ed9360f17bc06ab943f4dc25f4fd
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f8823615ef72da3494e74de9e62b2fa31315ed9360f17bc06ab943f4dc25f4fd
apps/webapp/app/presenters/v3/NextRunListPresenter.server.tshttps://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
View file https://github.com/triggerdotdev/trigger.dev/blob/87d2fe9ba95ce5983b777200a9d49bbe390a7ca2/apps/webapp/app/presenters/v3/NextRunListPresenter.server.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4202/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4202/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4202/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4202/files
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-f9ff65cddf5f751b128d529e2c5bc7e90d20248c15bec2599ca61634ae2e8bc3
...es/_app.orgs.$organizationSlug.projects.$projectParam.env.$envParam.runs._index/route.tsxhttps://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-cdf32f61c82a613fd3443e9058f8ac25c14e35efa92195a60d6062ed493c2f8a
View file https://github.com/triggerdotdev/trigger.dev/blob/87d2fe9ba95ce5983b777200a9d49bbe390a7ca2/apps/webapp/app/routes/_app.orgs.%24organizationSlug.projects.%24projectParam.env.%24envParam.runs._index/route.tsx
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4202/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-cdf32f61c82a613fd3443e9058f8ac25c14e35efa92195a60d6062ed493c2f8a
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-cdf32f61c82a613fd3443e9058f8ac25c14e35efa92195a60d6062ed493c2f8a
apps/webapp/app/services/runsRepository/clickhouseRunsRepository.server.tshttps://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-b3e045298340b0254d793fedcaba256747de056bcdd523bdc467b2987a394968
View file https://github.com/triggerdotdev/trigger.dev/blob/87d2fe9ba95ce5983b777200a9d49bbe390a7ca2/apps/webapp/app/services/runsRepository/clickhouseRunsRepository.server.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4202/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-b3e045298340b0254d793fedcaba256747de056bcdd523bdc467b2987a394968
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-b3e045298340b0254d793fedcaba256747de056bcdd523bdc467b2987a394968
apps/webapp/app/services/runsRepository/runsRepository.server.tshttps://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-fd5167ddce7f3f071edb4eda73f524d5ee109514355ac583869fa24a055f342c
View file https://github.com/triggerdotdev/trigger.dev/blob/87d2fe9ba95ce5983b777200a9d49bbe390a7ca2/apps/webapp/app/services/runsRepository/runsRepository.server.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/4202/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-fd5167ddce7f3f071edb4eda73f524d5ee109514355ac583869fa24a055f342c
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-fd5167ddce7f3f071edb4eda73f524d5ee109514355ac583869fa24a055f342c
https://github.com/triggerdotdev/trigger.dev/pull/4202/files#diff-fd5167ddce7f3f071edb4eda73f524d5ee109514355ac583869fa24a055f342c
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/4202/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.