René's URL Explorer Experiment


Title: chore(db): drop the job log schedule index the occurrence unique index covers by waleedlatif1 · Pull Request #9398 · simstudioai/sim · GitHub

Open Graph Title: chore(db): drop the job log schedule index the occurrence unique index covers by waleedlatif1 · Pull Request #9398 · simstudioai/sim

X Title: chore(db): drop the job log schedule index the occurrence unique index covers by waleedlatif1 · Pull Request #9398 · simstudioai/sim

Description: Summary Drop job_execution_logs_schedule_id_idx: the (schedule_id, occurrence_at) unique index added for scheduled-job occurrences leads with schedule_id, so it serves every lookup and the workflow_schedule FK check the single-column index did One fewer index to maintain on every job log write Migration 0438 commits out of the batch transaction and runs DROP INDEX CONCURRENTLY IF EXISTS, so it takes no table lock and replays safely Type of Change Other: schema cleanup Testing bun run check:migrations (backward-compatible), drizzle-kit generate reports no schema changes bun run lint, bun run check:audits (61 audits) CI applies and replays the migrations on a fresh database 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 Drop job_execution_logs_schedule_id_idx: the (schedule_id, occurrence_at) unique index added for scheduled-job occurrences leads with schedule_id, so it serves every lookup and the workflo...

X Description: Summary Drop job_execution_logs_schedule_id_idx: the (schedule_id, occurrence_at) unique index added for scheduled-job occurrences leads with schedule_id, so it serves every lookup and the workflo...

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

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:39b47ff8-c5fe-96e4-8ecd-59f4a6467187
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idEC76:5C03E:A21BB:D82B3:6AED0160
html-safe-nonce0a608afbef1ece3a343672ca1a3338cded56e2d78325eb869fb6a0404b3bc632
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFQzc2OjVDMDNFOkEyMUJCOkQ4MkIzOjZBRUQwMTYwIiwidmlzaXRvcl9pZCI6Ijg4ODc4NjA0OTM1NDQxMjg4NjQiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac766658d7a7b73447fe591596df094a4c540b9b8dd3be13496b428a7dda43457c
hovercard-subject-tagpull_request:5030155445
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/9398/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 Drop job_execution_logs_schedule_id_idx: the (schedule_id, occurrence_at) unique index added for scheduled-job occurrences leads with schedule_id, so it serves every lookup and the workflo...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None21e10c535436b2122cfb44c76dfb4af296e371850fb60de16776f8a64e5c3ed8
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
release302a6d707c3288a5f951258a2fa3e926b8c8f8cf
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/9398/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F9398%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%2F9398%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/9398/files
Reloadhttps://github.com/simstudioai/sim/pull/9398/files
Reloadhttps://github.com/simstudioai/sim/pull/9398/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues128 (128)https://github.com/simstudioai/sim/issues
Pull requests227 (227)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
chore/drop-redundant-job-log-indexhttps://github.com/simstudioai/sim/tree/chore/drop-redundant-job-log-index
Conversation 2 https://github.com/simstudioai/sim/pull/9398
Commits 1 https://github.com/simstudioai/sim/pull/9398/commits
Checks 67 https://github.com/simstudioai/sim/pull/9398/checks
Files changed https://github.com/simstudioai/sim/pull/9398/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9398/files
chore(db): drop the job log schedule index the occurrence unique index covers https://github.com/simstudioai/sim/pull/9398/files#top
Show all changes 1 commit https://github.com/simstudioai/sim/pull/9398/files
3be8c49 chore(db): drop the job log schedule index the occurrence unique inde… waleedlatif1 Oct 27, 2026 https://github.com/simstudioai/sim/pull/9398/commits/3be8c49a5b4d9079d8caf1984f4cd0b2352a564c
Clear filters https://github.com/simstudioai/sim/pull/9398/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9398/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9398/files
0438_drop_redundant_job_log_schedule_index.sql https://github.com/simstudioai/sim/pull/9398/files#diff-3dc3559c6443877b562a36d0aad65958692ba0d3bd248a39ce90517676116e55
0438_snapshot.json https://github.com/simstudioai/sim/pull/9398/files#diff-e19114b861c83e3cb1a19bd459bfd9940fea2dd445ad0216ec9183b74a281957
_journal.json https://github.com/simstudioai/sim/pull/9398/files#diff-37150cc65ad16ee6fbc5fa318fc096be7730e16d63eaf863e3df5521b7030649
schema.ts https://github.com/simstudioai/sim/pull/9398/files#diff-9a959e2ce3cb4c86957bbae021d06eae364f7b0cb18964f5873bab53220af928
packages/db/migrations/0438_drop_redundant_job_log_schedule_index.sqlhttps://github.com/simstudioai/sim/pull/9398/files#diff-3dc3559c6443877b562a36d0aad65958692ba0d3bd248a39ce90517676116e55
View file https://github.com/simstudioai/sim/blob/3be8c49a5b4d9079d8caf1984f4cd0b2352a564c/packages/db/migrations/0438_drop_redundant_job_log_schedule_index.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9398/{{ revealButtonHref }}
Please reload this pagehttps://github.com/simstudioai/sim/pull/9398/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9398/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.