postgres queries taking too long
jihirmas
FREEOP

2 years 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

48 Replies

2 years ago

are you trial or pro?


jihirmas
FREEOP

2 years ago

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


2 years ago

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


jihirmas
FREEOP

2 years ago

how I can look at that?


jihirmas
FREEOP

2 years ago

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


jihirmas
FREEOP

2 years ago

1316143476965904466


jihirmas
FREEOP

2 years ago

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


2 years ago

is the database in the same project as the app?


jihirmas
FREEOP

2 years ago

yes, it is


2 years ago

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


jihirmas
FREEOP

2 years ago

Thanks, I will try that


jihirmas
FREEOP

2 years ago

Can you assist me in the process please?


jihirmas
FREEOP

2 years ago

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


jihirmas
FREEOP

2 years 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?


2 years ago

you just told me you already have a pro plan?


jihirmas
FREEOP

2 years ago

yes, i have a pro plan


2 years ago

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


jihirmas
FREEOP

2 years ago

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


2 years ago

yes


jihirmas
FREEOP

2 years ago

Oh, I am sorry


jihirmas
FREEOP

2 years ago

Oh, i just found tre setting


jihirmas
FREEOP

2 years ago

the*


jihirmas
FREEOP

2 years ago

Now i am migrating. Does the backups migrate to?


2 years ago

yes


jihirmas
FREEOP

2 years ago

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


2 years ago

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


jihirmas
FREEOP

2 years ago

which is better in your opinion?


2 years 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
FREEOP

2 years ago

oh ok, thanks a lot for your help!


jihirmas
FREEOP

2 years ago

have a good one


2 years ago

we aren't done yet lol


jihirmas
FREEOP

2 years ago

Oh no? why not jaja?


jihirmas
FREEOP

2 years ago

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


jihirmas
FREEOP

2 years ago

thanks to your help


2 years ago

are you using the private network?


jihirmas
FREEOP

2 years ago

that is a good question, i dont know for sure


jihirmas
FREEOP

2 years ago

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


jihirmas
FREEOP

2 years ago

Do you know how i can review that?


2 years ago

check your variables for the database


jihirmas
FREEOP

2 years ago

i am using public network


2 years 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
FREEOP

2 years ago

cool, i will try now those changes


jihirmas
FREEOP

2 years ago

Awesome, now i am using the private network


jihirmas
FREEOP

2 years ago

Thanks a lot for your help 🙂


2 years ago

no problem!


2 years ago

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


jihirmas
FREEOP

2 years ago

👌


2 years ago

!s


Status changed to Solved brody over 1 year ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...