Try disabling proxy mode and switching to DNS only on cloudflare

Ok, I'll try it

I disabled it, but now it is trying to issue the TLS certificate, and it seems that it's not issuing it

Could you share a screenshot?

I forgot to mention that I'm using a custom domain, and this is the configuration on Cloudflare and Railway

Do I need to configure something else in Cloudflare or Railway?

try deleting the custom domain and the dns entry then recreating

After deleting, the TLS certificate was issued. It seems that Cloudflare was not the problem. I'm still experiencing high latency. My application has pagination and indexes. I'm also fetching only necessary data. However, the issue persists. Is there any other configuration that I should look at?

My server and database are located in the same region. US EAST (Virginia, USA). I have another application with the same configuration, and that application works seamlessly.

does this happen just on the custom domain or also happen on a railway domain?

It happens in both, custom domain and railway default domain

try using edge caching

I think I found the issue. I had configured in my server application the public variables of the database. However, after updating the variables to use the postgres internal host and related internal variables, rather than the public ones, the latency decreased, and now responses take less than 50ms.

Was having the public variables configured a probable cause of the increasing latency?

Yup, sounds exactly why