René's URL Explorer Experiment


Title: fix(insights): reduce activity aggregation overhead by waleedlatif1 · Pull Request #7908 · simstudioai/sim · GitHub

Open Graph Title: fix(insights): reduce activity aggregation overhead by waleedlatif1 · Pull Request #7908 · simstudioai/sim

X Title: fix(insights): reduce activity aggregation overhead by waleedlatif1 · Pull Request #7908 · simstudioai/sim

Description: Summary Aggregate workflow and chat activity separately before combining results, preserving exact member counts and duration averages. Add a concurrent covering index for activity queries and log when analytics fall back to the primary database. Format usage timestamps after aggregation and correct timezone bucketing for UTC ledger timestamps. Type of Change Bug fix Testing 82 focused tests passed, including PostgreSQL aggregation, timezone, scope, and pagination regressions. Verified the local app and benchmarked reads and writes with synthetic data. Type checks, lint, API validation, migration safety, and repository audits passed. Tested migration application and replay locally. Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing 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 Aggregate workflow and chat activity separately before combining results, preserving exact member counts and duration averages. Add a concurrent covering index for activity queries and log...

X Description: Summary Aggregate workflow and chat activity separately before combining results, preserving exact member counts and duration averages. Add a concurrent covering index for activity queries and log...

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

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:7489104d-1ab9-1d02-1132-3c29dbaebbea
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idCE94:24E4B4:170477:1FEA2F:6AFB2E7F
html-safe-noncef878f0d3c234f03ed3b5ca468f186d7d1d60335d7507d1d67f70f07d1e2dd4d3
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDRTk0OjI0RTRCNDoxNzA0Nzc6MUZFQTJGOjZBRkIyRTdGIiwidmlzaXRvcl9pZCI6IjMwMDE5NTcwNTg2MTY0Nzk5OSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac281b4e53023bb4b6eba92aec92a6eb0db88c3349a6916d9b71be758125e0e1a8
hovercard-subject-tagpull_request:4553903817
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/7908/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 Aggregate workflow and chat activity separately before combining results, preserving exact member counts and duration averages. Add a concurrent covering index for activity queries and log...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None40c7ffe00e8bbb3ca8403c83d7ef110379c9eba2cbc7a7c333b037ffd940d4e4
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
releasef494d77c37809e03e18d49c6e9945c57e0b64070
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/7908/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F7908%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%2F7908%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/7908/files
Reloadhttps://github.com/simstudioai/sim/pull/7908/files
Reloadhttps://github.com/simstudioai/sim/pull/7908/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests198 (198)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
codex/insights-query-performancehttps://github.com/simstudioai/sim/tree/codex/insights-query-performance
Conversation 8 https://github.com/simstudioai/sim/pull/7908
Commits 2 https://github.com/simstudioai/sim/pull/7908/commits
Checks 33 https://github.com/simstudioai/sim/pull/7908/checks
Files changed https://github.com/simstudioai/sim/pull/7908/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7908/files
fix(insights): reduce activity aggregation overhead https://github.com/simstudioai/sim/pull/7908/files#top
Show all changes 2 commits https://github.com/simstudioai/sim/pull/7908/files
fea9e21 fix(insights): reduce activity aggregation overhead waleedlatif1 Sep 17, 2026 https://github.com/simstudioai/sim/pull/7908/commits/fea9e213f60abefdfbb07b9b7a5d7b6d034d54ef
0a08f33 fix(db): declare activity index as concurrent waleedlatif1 Sep 17, 2026 https://github.com/simstudioai/sim/pull/7908/commits/0a08f33e60f374acc5f8507ee59ca7c250e44083
Clear filters https://github.com/simstudioai/sim/pull/7908/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7908/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7908/files
test-build.yml https://github.com/simstudioai/sim/pull/7908/files#diff-a583f7935a5f3192471a2999cbf059eadc857228b5be2c7247f481b799949f8d
organization-activity-queries.ts https://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
organization-activity.postgres.test.ts https://github.com/simstudioai/sim/pull/7908/files#diff-6fd4ad8d3125694655436fee9768d08133243ce1f8d5e658b36bde345180c1b7
usage-analytics-queries.postgres.test.ts https://github.com/simstudioai/sim/pull/7908/files#diff-41cab5b8ab87938298e253a9b414e2cde130ed8e9cdfee96d5cb2809f26050b3
usage-analytics-queries.ts https://github.com/simstudioai/sim/pull/7908/files#diff-f90252e5f8de4f9b5e54cd6275f81709b2cc720d95bf0f49421fef8fa36968c5
db.ts https://github.com/simstudioai/sim/pull/7908/files#diff-65562ec2df68f3735a9b4690adb4f844a74783c9f5c2d7a213a5124a6cd4900a
0355_workflow_activity_covering_index.sql https://github.com/simstudioai/sim/pull/7908/files#diff-00274c19dbe3d80d6af8fd50bd062059944bf472c7b41284ab3c7f1d028d6c96
0355_snapshot.json https://github.com/simstudioai/sim/pull/7908/files#diff-d6686381252cba6a0b42d88e32f552f8d9d6eb9fdd520136e25c5d143d0e2f95
_journal.json https://github.com/simstudioai/sim/pull/7908/files#diff-37150cc65ad16ee6fbc5fa318fc096be7730e16d63eaf863e3df5521b7030649
schema.ts https://github.com/simstudioai/sim/pull/7908/files#diff-9a959e2ce3cb4c86957bbae021d06eae364f7b0cb18964f5873bab53220af928
.github/workflows/test-build.ymlhttps://github.com/simstudioai/sim/pull/7908/files#diff-a583f7935a5f3192471a2999cbf059eadc857228b5be2c7247f481b799949f8d
View file https://github.com/simstudioai/sim/blob/0a08f33e60f374acc5f8507ee59ca7c250e44083/.github/workflows/test-build.yml
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7908/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7908/files#diff-a583f7935a5f3192471a2999cbf059eadc857228b5be2c7247f481b799949f8d
https://github.com/simstudioai/sim/pull/7908/files#diff-a583f7935a5f3192471a2999cbf059eadc857228b5be2c7247f481b799949f8d
apps/sim/lib/billing/core/organization-activity-queries.tshttps://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
View file https://github.com/simstudioai/sim/blob/0a08f33e60f374acc5f8507ee59ca7c250e44083/apps/sim/lib/billing/core/organization-activity-queries.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7908/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
https://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
https://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
https://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
https://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
https://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
https://github.com/simstudioai/sim/pull/7908/files#diff-96530f14dc4b2f486e1244f54694bee1a9c6351185f5052c7192d8b5b0a256c9
apps/sim/lib/billing/core/organization-activity.postgres.test.tshttps://github.com/simstudioai/sim/pull/7908/files#diff-6fd4ad8d3125694655436fee9768d08133243ce1f8d5e658b36bde345180c1b7
View file https://github.com/simstudioai/sim/blob/0a08f33e60f374acc5f8507ee59ca7c250e44083/apps/sim/lib/billing/core/organization-activity.postgres.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7908/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7908/files#diff-6fd4ad8d3125694655436fee9768d08133243ce1f8d5e658b36bde345180c1b7
https://github.com/simstudioai/sim/pull/7908/files#diff-6fd4ad8d3125694655436fee9768d08133243ce1f8d5e658b36bde345180c1b7
https://github.com/simstudioai/sim/pull/7908/files#diff-6fd4ad8d3125694655436fee9768d08133243ce1f8d5e658b36bde345180c1b7
apps/sim/lib/billing/core/usage-analytics-queries.postgres.test.tshttps://github.com/simstudioai/sim/pull/7908/files#diff-41cab5b8ab87938298e253a9b414e2cde130ed8e9cdfee96d5cb2809f26050b3
View file https://github.com/simstudioai/sim/blob/0a08f33e60f374acc5f8507ee59ca7c250e44083/apps/sim/lib/billing/core/usage-analytics-queries.postgres.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7908/{{ revealButtonHref }}
apps/sim/lib/billing/core/usage-analytics-queries.tshttps://github.com/simstudioai/sim/pull/7908/files#diff-f90252e5f8de4f9b5e54cd6275f81709b2cc720d95bf0f49421fef8fa36968c5
View file https://github.com/simstudioai/sim/blob/0a08f33e60f374acc5f8507ee59ca7c250e44083/apps/sim/lib/billing/core/usage-analytics-queries.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7908/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7908/files#diff-f90252e5f8de4f9b5e54cd6275f81709b2cc720d95bf0f49421fef8fa36968c5
https://github.com/simstudioai/sim/pull/7908/files#diff-f90252e5f8de4f9b5e54cd6275f81709b2cc720d95bf0f49421fef8fa36968c5
packages/db/db.tshttps://github.com/simstudioai/sim/pull/7908/files#diff-65562ec2df68f3735a9b4690adb4f844a74783c9f5c2d7a213a5124a6cd4900a
View file https://github.com/simstudioai/sim/blob/0a08f33e60f374acc5f8507ee59ca7c250e44083/packages/db/db.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7908/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7908/files#diff-65562ec2df68f3735a9b4690adb4f844a74783c9f5c2d7a213a5124a6cd4900a
https://github.com/simstudioai/sim/pull/7908/files#diff-65562ec2df68f3735a9b4690adb4f844a74783c9f5c2d7a213a5124a6cd4900a
packages/db/migrations/0355_workflow_activity_covering_index.sqlhttps://github.com/simstudioai/sim/pull/7908/files#diff-00274c19dbe3d80d6af8fd50bd062059944bf472c7b41284ab3c7f1d028d6c96
View file https://github.com/simstudioai/sim/blob/0a08f33e60f374acc5f8507ee59ca7c250e44083/packages/db/migrations/0355_workflow_activity_covering_index.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7908/{{ revealButtonHref }}
Please reload this pagehttps://github.com/simstudioai/sim/pull/7908/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7908/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.