Changes date filtering performance

[nijel]

Describe the issue

Changes browsing when filtering by date is slow. This is because PostgreSQL doesn't use database index on timestamp once it is coverted to date by using timestamp__date lookup.

I already tried

• I've read and searched the documentation.
• I've searched for similar filed issues in this repository.

Steps to reproduce the behavior

1. Have many changes
2. See what happens on the database upon filtering for changes by date

Expected behavior

No response

Screenshots

No response

Exception traceback

No response

How do you run Weblate?

Git checkout

Weblate versions

No response

Weblate deploy checks

No response

Additional context

606b60e made the similar change for search.

A similar approach should be used in weblate/trans/views/changes.py. I am not sure if the same issue affects weblate/metrics/models.py where date lookup is used, but it is there actually to look for date, but it should be investigated as well.