issue with query performance vs query duration
hey there. i'm running into issues where queries are taking ~1ms to execute+plan but instead of returning within ~5ms they sometimes take up to 6 seconds.
4 Replies
absent-sapphireOP•5mo ago
my max_connections is 4k, with 531 connections out of them 490 idle. i've set session_timeout to 15s for both
anonymous and authenticated roles, yet some queries are taking >60s via monitoring->active queries
and then there's this error when opening the monitoring (and in the vercel logs themselves)
Server error (HTTP status 500): {"message":"Failed to acquire permit to connect to the database. Too many database connection attempts are currently ongoing.","code":"","detail":null,"hint":null,"position":null,"internalPosition":null,"internalQuery":null,"severity":"","where":null,"table":null,"column":null,"schema":null,"dataType":null,"constraint":null,"file":null,"line":null,"routine":null}
the project ID is fragrant-wave-93328962conscious-sapphire•5mo ago
Hi, this could be due to different issues, possibly rate limiting at our proxy. For a proper assessment, I recommend contacting Neon Support for this one: https://console.neon.tech/app/projects?modal=support
absent-sapphireOP•5mo ago
alright, thanks!
hey @Daniel sorry but is there any estimate on when support might get back? we're pretty much blocked on everything right now
conscious-sapphire•5mo ago
I'll ping them. Do you have a support ticket number?