Search code examples
pythondjangodjango-admindjango-select-related

Django admin performance issue


I'm getting thousands of these queries when I try to open up a model in the Django admin interface and it's leading to a serious performance issue.

[sql] SELECT ... FROM `auth_user` WHERE `auth_user`.`id` = 9535
[sql] (21ms) Found 1 matching rows
[sql] SELECT ... FROM `auth_user` WHERE `auth_user`.`id` = 9536
[sql] (20ms) Found 1 matching rows

Any ideas why Django admin isn't using select_related()?

Here are (I think) the relevant parts of the model (I'm looking at an instance of the Student model in the admin):

from django.contrib.auth.models import User

class Student(models.Model):
    user = models.OneToOneField(User, unique=True)
    mhtl_user = models.OneToOneField(MHTLUser, unique=True)
    def __str__(self):
        return u"%s %s" % (self.user.first_name, self.user.last_name)

class MHTLUser(models.Model):
    user = models.OneToOneField(User, unique=True)
    def __str__(self):
        return str(self.user)

Solution

  • Or just enable list_select_related.

    class MyModelAdmin(admin.ModelAdmin):
        list_select_related = True
        # ....