René's URL Explorer Experiment


Title: improvement(logs): group dashboard stats by workflow id and join names once per group by waleedlatif1 · Pull Request #8973 · simstudioai/sim · GitHub

Open Graph Title: improvement(logs): group dashboard stats by workflow id and join names once per group by waleedlatif1 · Pull Request #8973 · simstudioai/sim

X Title: improvement(logs): group dashboard stats by workflow id and join names once per group by waleedlatif1 · Pull Request #8973 · simstudioai/sim

Description: Summary Dashboard stats segments now aggregate by the log's own workflow_id (plus the bucket) in a subquery instead of grouping by (COALESCE(workflow_id), COALESCE(workflow.name)), then LEFT JOIN workflow once per grouped row for COALESCE(workflow.name, 'Deleted Workflow') in the outer select. One statement, one snapshot, no batching, and the group key no longer carries name text The aggregate keeps its existing LEFT JOIN to workflow so folder/workflow/name filters keep working. Postgres 17 removes that join when no filter references workflow (it is on the PK and nothing else reads it), so no per-row workflow probe remains in the aggregate in the common case Output stays byte-identical: null workflow_id rows still collapse into deleted / Deleted Workflow, a workflow id with no row gets the same label, and the MAX_STATS_WORKFLOWS cut and its name tie-break are unchanged The main p99 gain comes together with the covering index in #8971 (which lets the aggregate stay index-only); on its own, this PR removes the name from the group key and does the name join once per group rather than once per log row readLogStatsBounds and the "All time" default are unchanged Type of Change Improvement (performance) Testing New lib/logs/stats-queries.integration.ts runs the old query verbatim as an oracle against the new read on seeded data, and compares both the raw rows and the buildDashboardStats output (capped and uncapped): 14 dashboard-route filter combinations: level, workflow ids, folder ids, workflow name, folder name, triggers, the all sentinel, date range, cost, duration, execution search, and a combined folder+trigger+level+date case 9 v2 cases: workflow ids, name, level, statuses, cost range, root scope, folder subtree, empty scope the handled-error count a hard-deleted workflow plus runs whose workflow id was never recorded MAX_STATS_WORKFLOWS + 5 workflows, most tied on error rate, so the cut falls inside a name-ordered tie Biome on changed files. Plain EXPLAIN (synthetic params): unfiltered, the aggregate scans only the log index and workflow appears once, as a workflow_pkey probe per grouped row; with a folder filter the join stays inside the aggregate as expected Type-check, audits, and the integration suite run in CI (not run locally) Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing (new tests pass the test-audit authoring gate) 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 Dashboard stats segments now aggregate by the log's own workflow_id (plus the bucket) in a subquery instead of grouping by (COALESCE(workflow_id), COALESCE(workflow.name)), then LEFT J...

X Description: Summary Dashboard stats segments now aggregate by the log's own workflow_id (plus the bucket) in a subquery instead of grouping by (COALESCE(workflow_id), COALESCE(workflow.name)), then LE...

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

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:961756c9-5bcd-9e8d-8cac-e644b35cfd5f
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idCBE2:3BD2EB:21AA3E:2F38D2:6AFB511F
html-safe-nonce3ba3d686cd4e472665d89e0492ec7f238b8c5445e1134843530a1687e6331e38
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDQkUyOjNCRDJFQjoyMUFBM0U6MkYzOEQyOjZBRkI1MTFGIiwidmlzaXRvcl9pZCI6IjM4NjEyNjkyNTY5NTU3MTE3NzUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacd333fdfa991663d8819ec080f7167a386f8c95028af0321866a2fe435e09bf87
hovercard-subject-tagpull_request:4847625666
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/8973/files
twitter:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
og:image:altSummary Dashboard stats segments now aggregate by the log's own workflow_id (plus the bucket) in a subquery instead of grouping by (COALESCE(workflow_id), COALESCE(workflow.name)), then LEFT J...
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/8973/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8973%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%2F8973%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/8973/files
Reloadhttps://github.com/simstudioai/sim/pull/8973/files
Reloadhttps://github.com/simstudioai/sim/pull/8973/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
waleedlatif1https://github.com/waleedlatif1
staginghttps://github.com/simstudioai/sim/tree/staging
perf/logs-stats-queryhttps://github.com/simstudioai/sim/tree/perf/logs-stats-query
Conversation 8 https://github.com/simstudioai/sim/pull/8973
Commits 2 https://github.com/simstudioai/sim/pull/8973/commits
Checks 52 https://github.com/simstudioai/sim/pull/8973/checks
Files changed https://github.com/simstudioai/sim/pull/8973/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8973/files
improvement(logs): group dashboard stats by workflow id and join names once per group https://github.com/simstudioai/sim/pull/8973/files#top
Show all changes 2 commits https://github.com/simstudioai/sim/pull/8973/files
36e976e improvement(logs): group dashboard stats by workflow id and resolve n… waleedlatif1 Oct 13, 2026 https://github.com/simstudioai/sim/pull/8973/commits/36e976e60139bc9ea6360f3989141b7c0822b0e9
4eb37dc improvement(logs): join workflow names once per group in the same sta… waleedlatif1 Oct 13, 2026 https://github.com/simstudioai/sim/pull/8973/commits/4eb37dc75c8518f27eb5d2c5ee8414ff92f07e3f
Clear filters https://github.com/simstudioai/sim/pull/8973/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8973/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8973/files
stats-queries.integration.ts https://github.com/simstudioai/sim/pull/8973/files#diff-95cecdaa6bdb920fe42f0b1a472bd43be1b42734c420105255179a24b4cb772b
stats-queries.ts https://github.com/simstudioai/sim/pull/8973/files#diff-5468680ab5b624c7e1b22cee5ac5026220cb589fbc4ea14df8f28c3cc0165182
apps/sim/lib/logs/stats-queries.integration.tshttps://github.com/simstudioai/sim/pull/8973/files#diff-95cecdaa6bdb920fe42f0b1a472bd43be1b42734c420105255179a24b4cb772b
View file https://github.com/simstudioai/sim/blob/4eb37dc75c8518f27eb5d2c5ee8414ff92f07e3f/apps/sim/lib/logs/stats-queries.integration.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8973/{{ revealButtonHref }}
apps/sim/lib/logs/stats-queries.tshttps://github.com/simstudioai/sim/pull/8973/files#diff-5468680ab5b624c7e1b22cee5ac5026220cb589fbc4ea14df8f28c3cc0165182
View file https://github.com/simstudioai/sim/blob/4eb37dc75c8518f27eb5d2c5ee8414ff92f07e3f/apps/sim/lib/logs/stats-queries.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8973/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8973/files#diff-5468680ab5b624c7e1b22cee5ac5026220cb589fbc4ea14df8f28c3cc0165182
https://github.com/simstudioai/sim/pull/8973/files#diff-5468680ab5b624c7e1b22cee5ac5026220cb589fbc4ea14df8f28c3cc0165182
https://github.com/simstudioai/sim/pull/8973/files#diff-5468680ab5b624c7e1b22cee5ac5026220cb589fbc4ea14df8f28c3cc0165182
https://github.com/simstudioai/sim/pull/8973/files#diff-5468680ab5b624c7e1b22cee5ac5026220cb589fbc4ea14df8f28c3cc0165182
https://github.com/simstudioai/sim/pull/8973/files#diff-5468680ab5b624c7e1b22cee5ac5026220cb589fbc4ea14df8f28c3cc0165182
Please reload this pagehttps://github.com/simstudioai/sim/pull/8973/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.