My code is
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',)
i only want parameter name in my list display but underlying query fetching all the fields. I am using postgres as my database. I have little idea about how to override the get_queryset method
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
how can i optimize it so it only fetch the field i want.