Django Queries

count user signups per day

from django.contrib.auth.models import User
from django.db.models import Count

qs = (User.objects.all().
    extra(select={
    	'm': "EXTRACT(month FROM date_joined)",
        'd': "EXTRACT(day FROM date_joined)",
        'y': "EXTRACT(year FROM date_joined)",
    }).
    values('d', 'm', 'y').
    annotate(count_items=Count('date_joined')))
qs = qs.order_by('date_joined')