I have a very simple setup with this app. I have a postgres instance, a backend (nodejs express) instance, and a vite react frontend. I have done as much as I can to optimize some of these things within reason, to no avail. And my region is correct (us east) on all three.

I have some functions that are not necessarily easy, and I don't need it to be lightning fast, but these speeds I am currently getting are making my app entirely unusable. Here are the logs:

[API] POST /schedule/assigned-schedules-for-week -> 200 took 20241ms

[API] POST /schedule/assigned-schedules-for-week -> 200 took 20548ms

[API] POST /schedule/assigned-schedules-for-week -> 200 took 20551ms

[API] POST /schedule/assigned-schedules-for-week -> 200 took 38780ms

[API] POST /schedule/assigned-schedules-for-week -> 200 took 39276ms

[API] POST /schedule/assigned-schedules-for-week -> 200 took 39423ms

[API] POST /schedule/assigned-schedules-for-week -> 200 took 38868ms

[API] POST /schedule/assigned-schedules-for-week -> 200 took 38869ms

[API] POST /schedule/assigned-schedules-for-week -> 200 took 38868ms

It is taking upward of 30 seconds to complete this request. The table I am accessing from only has about 15 rows right now, as I only have 3 test users. And in no way is the code I am running on the backend taking that long.

I know that the hobby plan uses shared storage. But requests like this should not take 30 seconds to complete. I am no professional, so I could be simply doing something wrong, or missing something obvious.

I would truly appreciate any sort of insight with this. :)

EDIT: I would also like to point out that I have ensured that I am not establishing a new connection to the database with each call, I am maintaining a stable connection the entire time.