René's URL Explorer Experiment


Title: improvement(db): drop unusable date slot and redundant prefix indexes by waleedlatif1 · Pull Request #8332 · simstudioai/sim · GitHub

Open Graph Title: improvement(db): drop unusable date slot and redundant prefix indexes by waleedlatif1 · Pull Request #8332 · simstudioai/sim

X Title: improvement(db): drop unusable date slot and redundant prefix indexes by waleedlatif1 · Pull Request #8332 · simstudioai/sim

Description: Summary Drops 8 indexes on hot write tables in one DROP INDEX CONCURRENTLY migration (0386), following the 0239 pattern: COMMIT breakpoint, lock_timeout 0, idempotent replay {emb,doc}_date1_idx / date2_idx: tag filters compare col::date, which a plain timestamp btree can never match, so these are written on every chunk insert and document update and never serve a query Four left-prefix duplicates of an existing non-partial superset, which keeps serving equality lookups and FK cascades on the leading column: emb_kb_id_idx: covered by emb_kb_enabled_idx / emb_kb_model_idx emb_doc_id_idx: covered by emb_doc_chunk_idx / emb_doc_enabled_idx usage_log_workspace_id_idx: covered by usage_log_workspace_created_at_idx copilot_runs_execution_id_idx: covered by copilot_runs_execution_started_at_idx Kept on purpose: Every number and boolean tag-slot index. The vector leg's short-result rescue probe checks tag filters with an EXISTS over embedding that relies on them, and without them a selective number/boolean filter turns that probe into a table-wide scan The small copilot_runs chat/workspace indexes Type of Change Improvement Testing Knowledge search A/B (real retrieveKnowledgeSearch, 58 shapes, 732k-chunk multi-tenant fixture, EXPLAIN ANALYZE BUFFERS per statement): with the prefix and date drops, every shape keeps its plan and latency within noise, and results are identical. Plans move to the covering composites. The same run showed that dropping the number/boolean slot indexes regresses filtered vector search, so those are kept Every app query and FK cascade that used a dropped prefix index (including the live document → embedding cascade and batched document_id = ANY(...)) stays an index scan on the covering composite with the same leading column as Index Cond Fresh DB: migrate plus replay succeed, the 8 indexes are gone, and the kept slot indexes remain. drizzle-kit generate reports no drift, and check:migrations origin/staging passes Knowledge search suites (kb-block-search, filtered-search, workspace-kb-document-access, search-index-policy) pass identically before and after 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 Drops 8 indexes on hot write tables in one DROP INDEX CONCURRENTLY migration (0386), following the 0239 pattern: COMMIT breakpoint, lock_timeout 0, idempotent replay {emb,doc}_date1_idx / ...

X Description: Summary Drops 8 indexes on hot write tables in one DROP INDEX CONCURRENTLY migration (0386), following the 0239 pattern: COMMIT breakpoint, lock_timeout 0, idempotent replay {emb,doc}_date1_idx / ...

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

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:d45f68d9-273f-70b0-45c8-df3bbe61d930
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idAEF4:1FFEE4:8E54D9:CA1FB3:6AFB5085
html-safe-nonce7c9d6474890649618dc32a398677e51d673cde866af5c986706c8ae7c867c179
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBRUY0OjFGRkVFNDo4RTU0RDk6Q0ExRkIzOjZBRkI1MDg1IiwidmlzaXRvcl9pZCI6IjYxNzczNzk1MjI5Mjk0NDcwNDYiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac297f52cb24509b131f02d9f714444277ac652ae90c521971d6e426405a0530c9
hovercard-subject-tagpull_request:4648631198
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/8332/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 Drops 8 indexes on hot write tables in one DROP INDEX CONCURRENTLY migration (0386), following the 0239 pattern: COMMIT breakpoint, lock_timeout 0, idempotent replay {emb,doc}_date1_idx / ...
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/8332/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8332%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%2F8332%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/8332/files
Reloadhttps://github.com/simstudioai/sim/pull/8332/files
Reloadhttps://github.com/simstudioai/sim/pull/8332/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
improvement/drop-unused-slot-indexeshttps://github.com/simstudioai/sim/tree/improvement/drop-unused-slot-indexes
Conversation 18 https://github.com/simstudioai/sim/pull/8332
Commits 1 https://github.com/simstudioai/sim/pull/8332/commits
Checks 32 https://github.com/simstudioai/sim/pull/8332/checks
Files changed https://github.com/simstudioai/sim/pull/8332/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8332/files
improvement(db): drop unusable date slot and redundant prefix indexes https://github.com/simstudioai/sim/pull/8332/files#top
Show all changes 1 commit https://github.com/simstudioai/sim/pull/8332/files
a5815cb improvement(db): drop unusable date slot and redundant prefix indexes waleedlatif1 Sep 26, 2026 https://github.com/simstudioai/sim/pull/8332/commits/a5815cb30a454d80bc62a5078dca980fa9d28b7b
Clear filters https://github.com/simstudioai/sim/pull/8332/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8332/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8332/files
0386_drop_redundant_and_unusable_indexes.sql https://github.com/simstudioai/sim/pull/8332/files#diff-0e34341e0a2c5510d9685de8f89d5042682c14b547c82025404276d5444924cf
0386_snapshot.json https://github.com/simstudioai/sim/pull/8332/files#diff-2ef674361e35515590f17ecd32b89ed8f2c7f30e11575282c5d8ab6c515bef80
_journal.json https://github.com/simstudioai/sim/pull/8332/files#diff-37150cc65ad16ee6fbc5fa318fc096be7730e16d63eaf863e3df5521b7030649
schema.ts https://github.com/simstudioai/sim/pull/8332/files#diff-9a959e2ce3cb4c86957bbae021d06eae364f7b0cb18964f5873bab53220af928
packages/db/migrations/0386_drop_redundant_and_unusable_indexes.sqlhttps://github.com/simstudioai/sim/pull/8332/files#diff-0e34341e0a2c5510d9685de8f89d5042682c14b547c82025404276d5444924cf
View file https://github.com/simstudioai/sim/blob/a5815cb30a454d80bc62a5078dca980fa9d28b7b/packages/db/migrations/0386_drop_redundant_and_unusable_indexes.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8332/{{ revealButtonHref }}
Please reload this pagehttps://github.com/simstudioai/sim/pull/8332/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8332/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.