what's your current disk usage?

3.42GB out of the 50GB

how much space does your local database have available to it?

Where is that set? the local database is just a local pg server

if its a local database then how much drive space do you have free

Sorry bit confused. The issue is when the database is hosted on railway, not locally. The local database is just on my machine which is 1TB macbook

No confusion needed, 1TB is quite a lot more than 50GB

Correct, the query runs fine locally, but when i run it connected to my railway pg instance, it fails with this error

So it seems like you are running into a resource limitation on railway

Yes, but im not hitting any memory limits as far as i can tell. Is there anything you can see on my end about my project? 98f66160-ce86-4b15-a73b-cab912256208/service/30c393cd-fc3a-4ed3-a433-9017f7032947

I dont work for railway, so unfortunately those ids dont do anything for me

Ah I assumed conductor meant you did oops lol

i have an idea of a possible solution, it would require custom instance sizing from railway, and thats only available on the business class, would that be something you are interested in?

We are on the pro plan rn. Would be open to hearing!

okay cool, i get you in touch with sales

Hey @themkrage - can you email the team on team@, I have one last meeting and I will jump on to unblock you

Just emailed @angelo Thank you!

I have also realized that this query seems to be trigerring it:
const ssFacilitiesWithRent = await PropRisePrismaClient.property.count({
where: {
state: {
equals: state,
mode: "insensitive",
},
landUseCodes: {
has: LandUseCode.SELF_STORAGE,
},
selfStorageRents: {
some: {
id: {
gte: 0,
}
}
},
},
});

but this doesn't seem too complex the tables its running on are 200k entries max

Okay, got lunch, finally addressing this.

@angelo was there a resolution to this?