For a simple request im getting 700ms - 1000ms return times on a fetch of objects where uuid is "some string"..
I am on the free plan tried upgrading resources and replicating the db closer to me didn't help at all...
I tried a materialised table and indexes for the lookup still doesn't help...
Im using a singleton for the client across both FE and BE so tried to rule that out by using a CURL request and got this...
time_namelookup: 0.027504s
time_connect: 0.034262s
time_appconnect: 0.048657s
time_pretransfer: 0.048756s
time_starttransfer: 1.046698s
time_total: 1.047239s
There is no RLS rules atm it just resolves to true...
The table has 10 rows...
Why..