[Django]-COUNT(id) instead of COUNT(*) in Django

Try using:

MyModel.objects.filter('some filter').values_list("id).count()

This will do this query:

select count(id) from MyModel

Try using an aggregate query:

from django.db import models
MyObject.objects.all().aggregate(models.Count('id'))['id__count']

COUNT(id) is roughly the equivalent of:

MyModel.objects.exclude(id=None).count()

this will add extra step to count the table fields, which is not the case for COUNT(*)