#20327: Device queries now faster when including ConfigContexts #1255

New Issue

MrUnknownDE · 2026-04-05T22:38:19+02:00

MrUnknownDE commented

2026-04-05 22:38:19 +02:00

Originally created by @jnovinger on 9/12/2025

Fixes: #20327

Move .distinct() from main queryset to tag subquery to eliminate performance bottleneck when querying devices with config contexts.

The .distinct() call on the main device queryset was causing PostgreSQL to sort all devices before pagination, resulting in 15x slower API responses for large installations (10k+ devices, 100+ config contexts).

Moving .distinct() to the tag subquery eliminates duplicates at their source (GenericForeignKey tag relationships) while preserving the fix for issues #5314 and #5387 without impacting overall query performance.

This is also likely to have positive impacts in other places that make use of these queryset methods, including:

/api/virtualization/virtual-machines
/dcim/devices/
/virtualization/virtual-machines/

*Originally created by @jnovinger on 9/12/2025* ### Fixes: #20327 Move `.distinct()` from main queryset to tag subquery to eliminate performance bottleneck when querying devices with config contexts. The `.distinct()` call on the main device queryset was causing PostgreSQL to sort all devices before pagination, resulting in 15x slower API responses for large installations (10k+ devices, 100+ config contexts). Moving `.distinct()` to the tag subquery eliminates duplicates at their source (`GenericForeignKey` tag relationships) while preserving the fix for issues #5314 and #5387 without impacting overall query performance. This is also likely to have positive impacts in other places that make use of these queryset methods, including: - /api/virtualization/virtual-machines - /dcim/devices/ - /virtualization/virtual-machines/

MrUnknownDE closed this issue

2026-04-05 22:38:19 +02:00

Sign in to join this conversation.

Branches Tags

main

21455-sql-indexes-audit

21357-register-model-actions

feature

20924-plugin-ui-components

21766-improve-test-coverage-for-sortable-table-columns

21157-export-template-public-models

21025-pre-render-config-contexts

21364-swagger

feature-ip-prefix-link

20911-dropdown-3

fix_module_substitution

21160-filterset

20911-dropdown-2

20044-elevation-stuck-lightmode

7604-filter-modifiers-v3

20660-script-load

19724-graphql

14884-script

19720-macaddress-interface-generic-relation

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

No Label

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/netbox#1255