Sometimes API requests are taking a lot of time

andr91md

HOBBYOP

4 months 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

Solved$10 Bounty

7 Replies

Railway

BOT

4 months 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

4 months 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 • 4 months 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

HOBBYOP

4 months 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:*******}