From 453aec00ef9d17260fbd21e8a933520a0721b278 Mon Sep 17 00:00:00 2001 From: Stephen Finucane Date: Fri, 2 Nov 2018 17:45:20 +0000 Subject: [PATCH] admin: Further optimize queries To count the amount of received patches for a series, we only need the patch's series field. Signed-off-by: Stephen Finucane --- patchwork/admin.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/patchwork/admin.py b/patchwork/admin.py index 546e516d..f9a94c6f 100644 --- a/patchwork/admin.py +++ b/patchwork/admin.py @@ -6,6 +6,7 @@ from django.contrib import admin from django.contrib.auth.admin import UserAdmin as BaseUserAdmin from django.contrib.auth.models import User +from django.db.models import Prefetch from patchwork.models import Bundle from patchwork.models import Check @@ -134,7 +135,8 @@ class SeriesAdmin(admin.ModelAdmin): def get_queryset(self, request): qs = super(SeriesAdmin, self).get_queryset(request) - return qs.prefetch_related('patches',) + return qs.prefetch_related(Prefetch( + 'patches', Patch.objects.only('series',))) admin.site.register(Series, SeriesAdmin) -- 2.47.3