Sometimes API requests are taking a lot of time

andr91md
HOBBY

3 days ago

Hi, team!

Project id = 0ec599b3-988c-4254-af77-6ebe364074a7. There is 1 Java BE service and 1 Postgres service. Both services are in EU West region. Sometimes light requests take 10-15 seconds, but usually they take 0.3 seconds. There is very little amount of data in the DB and very light code, so I am sure it is not the root cause. Could you help me fix an issue?

I think it could be related to a Disk issue in the Postgres service. Here are some logs:

2025-07-30 08:14:13.147 UTC [27] LOG: checkpoint starting: time

2025-07-30 08:14:13.856 UTC [27] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.617 s, sync=0.022 s, total=0.709 s; sync files=6, longest=0.018 s, average=0.004 s; distance=38 kB, estimate=196 kB; lsn=0/3F08888, redo lsn=0/3F08850

2025-07-30 10:19:16.351 UTC [27] LOG: checkpoint starting: time

2025-07-30 10:19:38.447 UTC [27] LOG: checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.751 s, sync=19.044 s, total=22.096 s; sync files=17, longest=8.110 s, average=1.121 s; distance=148 kB, estimate=191 kB; lsn=0/3F2DB30, redo lsn=0/3F2DAF8

2025-07-30 14:39:21.643 UTC [27] LOG: checkpoint starting: time

2025-07-30 14:39:28.714 UTC [27] LOG: checkpoint complete: wrote 39 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.697 s, sync=0.018 s, total=7.071 s; sync files=19, longest=0.017 s, average=0.001 s; distance=206 kB, estimate=206 kB; lsn=0/3F75EC8, redo lsn=0/3F61428

2025-07-30 14:44:21.812 UTC [27] LOG: checkpoint starting: time

2025-07-30 14:44:39.183 UTC [27] LOG: checkpoint complete: wrote 37 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.494 s, sync=10.620 s, total=17.372 s; sync files=18, longest=6.336 s, average=0.590 s; distance=200 kB, estimate=205 kB; lsn=0/3F93768, redo lsn=0/3F93730

$10 Bounty

4 Replies

Railway
BOT

3 days ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!


chandrika
EMPLOYEE

15 hours ago

Hi there, could you please connect your services over the private network?

That should significantly reduce the round trip across the internet your services need to make as opposed to being able to connect via Railway's private network https://docs.railway.com/guides/private-networking#using-reference-variables

Please do so, and let us know if that resolve the issue!


Status changed to Awaiting User Response Railway about 15 hours ago


chandrika

Hi there, could you please connect your services over the private network?That should significantly reduce the round trip across the internet your services need to make as opposed to being able to connect via Railway's private network https://docs.railway.com/guides/private-networking#using-reference-variablesPlease do so, and let us know if that resolve the issue!

andr91md
HOBBY

14 hours ago

Hello there! But is seems to me that I am already using private network in my spring boot app and in my props spring.datasource.url=jdbc:postgresql://${DB_CORE_URL:localhost}:${DB_CORE_PORT:5432}/${DB_CORE_NAME:*******}


Status changed to Awaiting Railway Response Railway about 14 hours ago


9 hours ago

Yep, you are. I will go ahead and open this thread up to our community in hopes that they can help you debug your application.


Status changed to Awaiting User Response Railway about 9 hours ago


Sometimes API requests are taking a lot of time - Railway Help Station