[closed] How create a filter of reputes for some period?

I want to create a filter of reputes for some period. A query is:

User.objects.exclude(date_joined__gt=end_period).filter( Q(reputes__date__gte=start_period) & Q(reputes__date__lte=end_period)).annotate(period_rep=Sum('reputes__value')).order_by('-is_active', '-period_rep').distinct()

After that i ran syncdb and migrate

python manage.py syncdb --all
python manage.py migrate forum

But this solution is very slow. Нow can I optimize the query?

Maybe there are other ways (without using reputes table)? General task is to get users who have been reputed from one date to another.

I've changed an ActionRepute class.

class ActionRepute(models.Model):
    action = models.ForeignKey(Action, related_name='reputes')
    date = models.DateTimeField(datetime.datetime.now, db_index=True)
    user = models.ForeignKey('User', db_index=True, related_name='reputes')
    value = models.IntegerField(db_index=True, default=0)
    by_canceled = models.BooleanField(default=False)

But the query has not working faster. Where the mistake?

I've tried this one. I've run

python manage.py sqlindexes forum

For getting indexes. After I've run

python manage.py dbshell

I've put

CREATE INDEX "forum_actionrepute_user_id" ON "forum_actionrepute" ("user_id");

into dbshell, but got an error

ERROR: relation "forum_actionrepute_user_id" already exists

I also tried

BEGIN; CREATE INDEX "forum_actionrepute_date" ON "forum_actionrepute" ("date"); COMMIT;
BEGIN; CREATE INDEX "forum_actionrepute_value" ON "forum_actionrepute" ("value"); COMMIT;

How I understood the trouble in annotate(period_rep=Sum('reputes__value')).

I've tried to create an other query

 User.objects.select_related('reputes__value', 'reputes').filter(reputes__in=ActionRepute.objects.filter(Q(date__gte=start_period) & Q(date__lte=end_period))).annotate(period_rep=Sum('reputes__value')).order_by('-is_active', '-period_rep').distinct()

But I had the same result. How can I optimizing the query (a calculation of sum of the reputes values)?

OK. I've gotten a generated query. In the query the Django platform has pasted GROUP BY by all columns in the query (there are about 15 columns). I think the problem in GROUP BY statement. What must I do for fix this trouble?