Retool DB query extremely slow

I'm making a query to the retool db, that looks as fast as I'd expect to actually run the query, but the performance information shows that data transfer is extremely slow: almost 500ms for 1 row. This is on retool cloud, connecting to retool db, so I'm surprised it would take this long.

Thanks for reaching out, @Milo_Watanabe1.

This is a little on the slow side, but roughly in line with the 300-400ms of inherent latency that I typically tell folks to expect when executing app queries. All requests from the client are routed through Retool's backend servers, meaning there's a fair bit of transit involved depending on where you're located.

If you are comfortable giving me the name of the query, I can look up the relevant requests in our logs to see a more thorough breakdown of how that time is spent. :+1: