Fixed #200 -- Fixed performance regression in RequestQuerySet.month().

felixxm · web-flow · commit 2842886e1ce1 · 2020-05-03T19:57:43.000+02:00
Regression in 0adc76d.
diff --git a/CHANGELOG.md b/CHANGELOG.md
@@ -16,6 +16,10 @@
 
 * Confirms support for Django 2.2.
 
+### Bug Fixes
+
+* Fixes a performance regression in the admin's requests overview (#200).
+
 ## 1.5.5.
 
 ### Breaking
diff --git a/request/managers.py b/request/managers.py
@@ -2,6 +2,7 @@
 import datetime
 import time
 
+from dateutil.relativedelta import relativedelta
 from django.db import models
 from django.db.models import Q
 from django.utils import timezone
@@ -39,7 +40,11 @@ def month(self, year=None, month=None, month_format='%b', date=None):
         # Truncate to date.
         if isinstance(date, datetime.datetime):
             date = date.date()
-        return self.filter(time__year=date.year, time__month=date.month)
+        # Calculate first and last day of month, for use in a date-range
+        # lookup.
+        first_day = date.replace(day=1)
+        last_day = first_day + relativedelta(months=1)
+        return self.filter(time__gte=first_day, time__lt=last_day)
 
     def week(self, year, week):
         try:
