Как оптимизировать sql-запрос поля в отображении списка в админке django

Мой код такой

class MetricAdmin(admin.ModelAdmin):
    list_filter = ('customer',)
    exclude = ('unavailable_clients','metric_group')
    form = MetricForm
    action_form = TriggerBackfillMetricForm
    actions = ["trigger_backfill_metric"]
    list_display = ('parameter_name',)

Я хочу, чтобы в моем списке отображалось только имя параметра, но основной запрос получал все поля. В качестве базы данных я использую postgres. Я слабо представляю, как переопределить метод get_queryset

Executed SQL
SELECT "devices_physicalparameter"."id",
       "devices_physicalparameter"."parameter_name",
       "devices_physicalparameter"."parameter_type",
       "devices_physicalparameter"."query_name",
       "devices_physicalparameter"."display_name",
       "devices_physicalparameter"."display_unit_id",
       "devices_physicalparameter"."multiplier",
       "devices_physicalparameter"."operator_choice",
       "devices_physicalparameter"."filter_operator_id",
       "devices_physicalparameter"."parameter_properties",
       "retail_metric_basemetric"."physicalparameter_ptr_id",
       "retail_metric_basemetric"."customer_id",
       "retail_metric_basemetric"."enabled",
       "retail_metric_basemetric"."display_name_filter",
       "retail_metric_basemetric"."all_sites_required",
       "retail_metric_basemetric"."rate",
       "retail_metric_basemetric"."include_pseudometers",
       "retail_metric_basemetric"."batch_size",
       "retail_metric_basemetric"."time_shift_start",
       "retail_metric_basemetric"."time_shift_stop",
       "retail_metric_basemetric"."publish_when_all_controllers_available",
       "retail_metric_basemetric"."metric_group",
       "retail_metric_basemetric"."level",
       "retail_metric_basemetric"."type",
       "retail_metric_dcmeterenergymetric"."basemetric_ptr_id",
       "retail_metric_dcmeterenergymetric"."day_start_time",
       "retail_metric_dcmeterenergymetric"."day_end_time",
       "retail_metric_dcmeterenergymetric"."calculation_mode"
  FROM "retail_metric_dcmeterenergymetric"
 INNER JOIN "retail_metric_basemetric"
    ON ("retail_metric_dcmeterenergymetric"."basemetric_ptr_id" = "retail_metric_basemetric"."physicalparameter_ptr_id")
 INNER JOIN "devices_physicalparameter"
    ON ("retail_metric_basemetric"."physicalparameter_ptr_id" = "devices_physicalparameter"."id")
 ORDER BY "devices_physicalparameter"."parameter_name" ASC

Как я могу оптимизировать его, чтобы он получал только нужное мне поле.

Вернуться на верх