How to optimize query to Postgresql?

Question

PostgreSQL

There is a site with django+uwsgi+nginx+posgresql. There is one big request that takes a decent amount of time. Apparently django aggregates all view and template display into one request.
The query result is almost always the same (it changes when a comment appears - once a day). How can you optimize query processing time? Is there any caching by means of posgresql?
Plannin time: 1.011 ms
Execution time: 785.911 ms

Answer 1

Do you have no caching at all or what? Throw in any cache the result of a request for a day, business.