> I'd love to know what fraction of the time is spent in processing, transit, querying the db, etc.
We experimented with SELECT 1, so most of the latency is transit
We experimented with SELECT 1, so most of the latency is transit
I'm assuming the most likely difference is in Pg processing an HTTP request over processing raw bytes, but there are other explanations, too. (Older/slower code pathway for HTTP in proxy, different intermediate node behavior for HTTP vs TCP from proxy to db, etc. Much less likely, but not impossible.)