starred/netbox
1
0
Fork 0
mirror of https://github.com/netbox-community/netbox.git synced 2026-01-11 13:00:30 +01:00
Code Issues 273 Packages Projects Releases 10 Wiki Activity

Restore missing SQL indexes for MPTT fields #11938

New Issue
Open
opened 2025-12-29 21:51:44 +01:00 by adam · 0 comments
adam commented 2025-12-29 21:51:44 +01:00
Owner
Copy Link

Originally created by @jeremystretch on GitHub (Dec 18, 2025).

Proposed Changes

All models which employ MPTT (from django-mptt) should have SQL indexes for ('tree_id', 'left'), however these are not created by the database migrations. This seems to have been partially solved by django-mptt/django-mptt#845 in v0.18.0, however the indexes are not automatically created for most models.

This was originally tracked under #20954 but has been split into a separate issue for investigation.

Justification

Adding these indexes should improve overall query performance for MPTT-enabled models.

Originally created by @jeremystretch on GitHub (Dec 18, 2025). ### Proposed Changes All models which employ MPTT (from `django-mptt`) should have SQL indexes for `('tree_id', 'left')`, however these are not created by the database migrations. This seems to have been partially solved by django-mptt/django-mptt#845 in v0.18.0, however the indexes are not automatically created for most models. This was originally tracked under #20954 but has been split into a separate issue for investigation. ### Justification Adding these indexes should improve overall query performance for MPTT-enabled models.
adam added the type: housekeepingnetbox labels 2025-12-29 21:51:44 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
beta
breaking change
complexity: high
complexity: low
complexity: medium
needs milestone
netbox
pending closure
plugin candidate
pull-request
Mirrored from GitHub Pull Request
 severity: high
severity: low
severity: medium
status: accepted
status: backlog
status: blocked
status: duplicate
status: needs owner
status: needs triage
status: revisions needed
status: under review
topic: GraphQL
topic: Internationalization
topic: OpenAPI
topic: UI/UX
topic: cabling
topic: event rules
topic: htmx navigation
topic: industrialization
topic: migrations
topic: plugins
topic: scripts
topic: templating
topic: testing
type: bug
type: deprecation
type: documentation
type: feature
type: housekeeping
type: translation
No Label netbox type: housekeeping
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#11938
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?