Add db_index to Django User model?

Question

I have a custom user model that takes in the following fields:

class MyUser(AbstractBaseUser, PermissionsMixin):
    username = models.CharField(max_length=60, unique=True)
    email = models.EmailField(max_length=120, unique=True)
    full_name = models.CharField(max_length=50, blank=True)
    is_active = models.BooleanField(default=True)

I know username and email automatically adds a db_index because it is set to unique=True.

Does it make sense to add db_index=True for my full_name and is_active fields?

I have a search feature that checks if the regex matches the full_name. In my model managers, I also filter against is_active=True.

I would like to optimize querys, but don't want to add tables to my database if it isn't necessary.

Thank you!

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

Yes,just add db_index=True into your field like this

full_name = models.CharField(max_length=50, blank=True,db_index=True)

After you migrate it, your database will create a index for this filed.

Refer this: https://docs.djangoproject.com/en/1.9/ref/models/fields/#db-index

Field.db_index

If True, a database index will be created for this field.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 13, 2016 at 3:12

gkiwi

6108 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:45:05Z

0

Whether the index is used for full_name if you search using a regex is doubtable. You want to make sure of that by looking at the output of the query planner (e.g. postgres: EXPLAIN ANALYZE select * from myuser where user=...;).

If it is not used (for example because the regex lower cases everything) then you have to create a different index. For example on the lower cased value or even a GIN index (for partial matches).

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Apr 6, 2016 at 12:43

Risadinha

16.8k2 gold badges97 silver badges99 bronze badges

Collectives™ on Stack Overflow

Add db_index to Django User model?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related