What to do if slow queries?

Question

PostgreSQL

Please tell me, there is a free dedicated database on elephantsql, I noticed that there are slow queries, as I understand it, these are slow queries, this is how it looks
and there are a lot of such slow queries, what should I do? I use nestjs as server and typeorm.

Answer 1

Judging by the fact that even the creation of a table and queries with hacks take quite a long time, this is simply not a particularly fast base.
Considering that you have, in principle, few requests - if this does not lead to applied inconvenience, it is quite possible to score. When the load increases and the application becomes noticeably slower, you can think about optimizations or transferring somewhere to normal hardware.