postgres queries taking too long

jihirmas
HOBBY

7 months ago

I have a Django project using PostgreSQL as the database. When I started deploying it on Railway, the query speeds were normal, but suddenly they became significantly slower, and I can't figure out why. I’m located in Chile, while the project is hosted in Virginia. Could this be causing the issue? Is there any way to test or diagnose this? The project id is: 1cf8b79c-61f3-4362-ad9c-8c1d1322b835

Solved

0 Replies

7 months ago

are you trial or pro?


jihirmas
HOBBY

7 months ago

My account is a trial one, but the project is in a pro account


7 months ago

is the database in question in the same region as your app?


jihirmas
HOBBY

7 months ago

how I can look at that?


jihirmas
HOBBY

7 months ago

Oh ok, I already find it. Not, the db is not in the same region. Actually, I cant change the region


jihirmas
HOBBY

7 months ago

1316143476965904400


jihirmas
HOBBY

7 months ago

The account is a pro plan, but i am seeing that message


7 months ago

is the database in the same project as the app?


jihirmas
HOBBY

7 months ago

yes, it is


7 months ago

then you'd want to move your project to the pro team, that can be done in the project settings


jihirmas
HOBBY

7 months ago

Thanks, I will try that


jihirmas
HOBBY

7 months ago

Can you assist me in the process please?


jihirmas
HOBBY

7 months ago

If I create a team, i have to pay extra for that team?


jihirmas
HOBBY

7 months ago

I am trying to move the project to a team, but I must pay another subscription? Is there any chance to "trasnfer" my actual subscritipon to a team?


7 months ago

you just told me you already have a pro plan?


jihirmas
HOBBY

7 months ago

yes, i have a pro plan


7 months ago

may I ask why you are talking about buying it again?


jihirmas
HOBBY

7 months ago

I am confused, a pro plan and a Team is the same thing?


7 months ago

yes


jihirmas
HOBBY

7 months ago

Oh, I am sorry


jihirmas
HOBBY

7 months ago

Oh, i just found tre setting


jihirmas
HOBBY

7 months ago

the*


jihirmas
HOBBY

7 months ago

Now i am migrating. Does the backups migrate to?


7 months ago

yes


jihirmas
HOBBY

7 months ago

One more question, what is the difference between metal beta and other region?


7 months ago

metal is our own hardware in a database, the other regions are GCP


jihirmas
HOBBY

7 months ago

which is better in your opinion?


7 months ago

metal hands down, but for your usecase you would not want to use it given you can't run databases on metal yet


jihirmas
HOBBY

7 months ago

oh ok, thanks a lot for your help!


jihirmas
HOBBY

7 months ago

have a good one


7 months ago

we aren't done yet lol


jihirmas
HOBBY

7 months ago

Oh no? why not jaja?


jihirmas
HOBBY

7 months ago

I already made the migration, now my queries are fast again


jihirmas
HOBBY

7 months ago

thanks to your help


7 months ago

are you using the private network?


jihirmas
HOBBY

7 months ago

that is a good question, i dont know for sure


jihirmas
HOBBY

7 months ago

i think i have some issues with that time ago, so I think i am not using private


jihirmas
HOBBY

7 months ago

Do you know how i can review that?


7 months ago

check your variables for the database


jihirmas
HOBBY

7 months ago

i am using public network


7 months ago

then you'd want to use the private host and port for the database, with that it's going to be even faster


jihirmas
HOBBY

7 months ago

cool, i will try now those changes


jihirmas
HOBBY

7 months ago

Awesome, now i am using the private network


jihirmas
HOBBY

7 months ago

Thanks a lot for your help 🙂


7 months ago

no problem!


7 months ago

and as long as both your app and the db are in the same region you are good to go


jihirmas
HOBBY

7 months ago

👌


7 months ago

!s


Status changed to Solved brody 7 months ago


postgres queries taking too long - Railway Help Station