From c7f9a7b692303dea0fbfbc579080e447e4736d2f Mon Sep 17 00:00:00 2001
From: stuppie
Date: Mon, 26 Oct 2026 12:29:59 -0600
Subject: add composite product last seen index

---
 generalresearch/thl_django/common/models.py | 1 +
 1 file changed, 1 insertion(+)

diff --git a/generalresearch/thl_django/common/models.py b/generalresearch/thl_django/common/models.py
index 6f8f813..968171f 100644
--- a/generalresearch/thl_django/common/models.py
+++ b/generalresearch/thl_django/common/models.py
@@ -363,6 +363,7 @@ class THLUser(models.Model):
             # models.Index(fields=["product_id", "product_user_id"]),
             models.Index(fields=["created"]),
             models.Index(fields=["last_seen"]),
+            models.Index(fields=["product_id", "-last_seen"]),
             models.Index(
                 fields=["last_task_completed_at"],
                 name="thl_user_last_task_comp_nn",
-- 
cgit v1.2.3