René's URL Explorer Experiment


Title: fix(logs-page): optimize logs retrieval queries, consolidate useEffects to prevent dup calls by icecrasher321 · Pull Request #845 · simstudioai/sim · GitHub

Open Graph Title: fix(logs-page): optimize logs retrieval queries, consolidate useEffects to prevent dup calls by icecrasher321 · Pull Request #845 · simstudioai/sim

X Title: fix(logs-page): optimize logs retrieval queries, consolidate useEffects to prevent dup calls by icecrasher321 · Pull Request #845 · simstudioai/sim

Description: Summary Permissions join was taking a while. Rearranged query to not have where class but filter as part of join to actually use index. Also removed two unused indices. Consolidated useEffects to make one less fetch logs call Remove artificial minLoadingTime timeout Type of Change Other: Performance Improvement Testing Tested loading logs 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 Permissions join was taking a while. Rearranged query to not have where class but filter as part of join to actually use index. Also removed two unused indices. Consolidated useEffects to ...

X Description: Summary Permissions join was taking a while. Rearranged query to not have where class but filter as part of join to actually use index. Also removed two unused indices. Consolidated useEffects to ...

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

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:ae2a62eb-ccdc-154b-6434-c16a7fbfbe43
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idC6CE:3D9003:3D1ED:594AA:6AFB274C
html-safe-nonce3dd984a089519b431427159e50d836cfd392a1c28c3d7a030b0b3eccc23621b2
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDNkNFOjNEOTAwMzozRDFFRDo1OTRBQTo2QUZCMjc0QyIsInZpc2l0b3JfaWQiOiI2Nzk0MzIzMDA5MTcyMzUwNzk2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmacb913c0761ce6afa3f9bf3a83c7f63ebf914a016fa11d1605035b26b35c87fa82
hovercard-subject-tagpull_request:2714501873
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/845/files
twitter:imagehttps://avatars.githubusercontent.com/u/17950982?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/17950982?s=400&v=4
og:image:altSummary Permissions join was taking a while. Rearranged query to not have where class but filter as part of join to actually use index. Also removed two unused indices. Consolidated useEffects to ...
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/845/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F845%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%2F845%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/845/files
Reloadhttps://github.com/simstudioai/sim/pull/845/files
Reloadhttps://github.com/simstudioai/sim/pull/845/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
icecrasher321https://github.com/icecrasher321
staginghttps://github.com/simstudioai/sim/tree/staging
fix/logs-loading-timeshttps://github.com/simstudioai/sim/tree/fix/logs-loading-times
Conversation 2 https://github.com/simstudioai/sim/pull/845
Commits 3 https://github.com/simstudioai/sim/pull/845/commits
Checks 0 https://github.com/simstudioai/sim/pull/845/checks
Files changed https://github.com/simstudioai/sim/pull/845/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/845/files
fix(logs-page): optimize logs retrieval queries, consolidate useEffects to prevent dup calls https://github.com/simstudioai/sim/pull/845/files#top
Show all changes 3 commits https://github.com/simstudioai/sim/pull/845/files
4b204c9 fix(logs-page): optimize loading times by improving query, removing u… Aug 1, 2025 https://github.com/simstudioai/sim/pull/845/commits/4b204c962260c54034aef0f3bb96ad10390e0fdb
6ef4066 add migration files Aug 1, 2025 https://github.com/simstudioai/sim/pull/845/commits/6ef406616efb1ed075d48314f7d8e7503b2dd222
0906c6d remove fake min loading time Aug 1, 2025 https://github.com/simstudioai/sim/pull/845/commits/0906c6db22700effbee14a8073981acea65f5bb4
Clear filters https://github.com/simstudioai/sim/pull/845/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/845/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/845/files
route.ts https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
logs.tsx https://github.com/simstudioai/sim/pull/845/files#diff-7e8687c87d3458a17d7dab33773b35cfe0c15b0efe5078d511cc6ea3f0d01bb9
0064_elite_hedge_knight.sql https://github.com/simstudioai/sim/pull/845/files#diff-452de898418d7f29847ba9ff6d2cac2d5f7d534dd093d37bb67fcf35bb21e9be
0064_snapshot.json https://github.com/simstudioai/sim/pull/845/files#diff-c1e7739b27cbdadb2bc6edf0f770382673c281eb97dcdd80bd6405b68ff19760
_journal.json https://github.com/simstudioai/sim/pull/845/files#diff-3db387af585d1ac1092f726b1198a35b2f7509e7918b6e98039f94f17c2122fb
schema.ts https://github.com/simstudioai/sim/pull/845/files#diff-a24f4945794057bad5b5a292c9217d0177dd4f7f653853e047475f89e27fd9d1
apps/sim/app/api/logs/route.tshttps://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
View file https://github.com/simstudioai/sim/blob/0906c6db22700effbee14a8073981acea65f5bb4/apps/sim/app/api/logs/route.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/845/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
https://github.com/simstudioai/sim/pull/845/files#diff-f1e250123eea5affd0809c1f56bb9710101863ae293e780f627ef2f79c20de10
Please reload this pagehttps://github.com/simstudioai/sim/pull/845/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.