pg_gather
pg_gather copied to clipboard
DB level Net/Delay calcuation could a valuable improvement
Filing this improvement request on behalf of @ylacancellera expects net/delay in that table to show up at db level which will be easy for users to understand.
Counter argument :
"The net/Delay is something outside the transaction block.. It's the time spent between statements outside transactions.. So the database doesn't spend its time on that. It just does a context switch."
Possible Value :
"A bigger Net/Delay means the connections are underutilised. Connections are just waiting for some response from the client which is a waste, and clients may be experiencing poor response from the server as well"
Improvements are commited in Dev https://github.com/jobinau/pg_gather/commit/014228820dbccf95e2e5beccd0504b8d1ae78414 Planned to push to main soon
Closing as this feature is already in release and widely used. I assume that it is stable as no issue are reported.