postgres queries taking too long
jihirmas
HOBBYOP

a year 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

brody
EMPLOYEE

a year ago

are you trial or pro?


jihirmas
HOBBYOP

a year ago

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


brody
EMPLOYEE

a year ago

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


jihirmas
HOBBYOP

a year ago

how I can look at that?


jihirmas
HOBBYOP

a year ago

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


jihirmas
HOBBYOP

a year ago

1316143476965904400


jihirmas
HOBBYOP

a year ago

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


brody
EMPLOYEE

a year ago

is the database in the same project as the app?


jihirmas
HOBBYOP

a year ago

yes, it is


brody
EMPLOYEE

a year ago

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


jihirmas
HOBBYOP

a year ago

Thanks, I will try that


jihirmas
HOBBYOP

a year ago

Can you assist me in the process please?


jihirmas
HOBBYOP

a year ago

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


jihirmas
HOBBYOP

a year 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?


brody
EMPLOYEE

a year ago

you just told me you already have a pro plan?


jihirmas
HOBBYOP

a year ago

yes, i have a pro plan


brody
EMPLOYEE

a year ago

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


jihirmas
HOBBYOP

a year ago

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


brody
EMPLOYEE

a year ago

yes


jihirmas
HOBBYOP

a year ago

Oh, I am sorry


jihirmas
HOBBYOP

a year ago

Oh, i just found tre setting


jihirmas
HOBBYOP

a year ago

the*


jihirmas
HOBBYOP

a year ago

Now i am migrating. Does the backups migrate to?


brody
EMPLOYEE

a year ago

yes


jihirmas
HOBBYOP

a year ago

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


brody
EMPLOYEE

a year ago

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


jihirmas
HOBBYOP

a year ago

which is better in your opinion?


brody
EMPLOYEE

a year 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
HOBBYOP

a year ago

oh ok, thanks a lot for your help!


jihirmas
HOBBYOP

a year ago

have a good one


brody
EMPLOYEE

a year ago

we aren't done yet lol


jihirmas
HOBBYOP

a year ago

Oh no? why not jaja?


jihirmas
HOBBYOP

a year ago

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


jihirmas
HOBBYOP

a year ago

thanks to your help


brody
EMPLOYEE

a year ago

are you using the private network?


jihirmas
HOBBYOP

a year ago

that is a good question, i dont know for sure


jihirmas
HOBBYOP

a year ago

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


jihirmas
HOBBYOP

a year ago

Do you know how i can review that?


brody
EMPLOYEE

a year ago

check your variables for the database


jihirmas
HOBBYOP

a year ago

i am using public network


brody
EMPLOYEE

a year 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
HOBBYOP

a year ago

cool, i will try now those changes


jihirmas
HOBBYOP

a year ago

Awesome, now i am using the private network


jihirmas
HOBBYOP

a year ago

Thanks a lot for your help 🙂


brody
EMPLOYEE

a year ago

no problem!


brody
EMPLOYEE

a year ago

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


jihirmas
HOBBYOP

a year ago

👌


brody
EMPLOYEE

a year ago

!s


Status changed to Solved brody about 1 year ago


Loading...