pg_gather icon indicating copy to clipboard operation
pg_gather copied to clipboard

DB level Net/Delay calcuation could a valuable improvement

Open jobinau opened this issue 11 months ago • 2 comments

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.

jobinau avatar Mar 08 '24 14:03 jobinau

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"

jobinau avatar Mar 08 '24 14:03 jobinau

Improvements are commited in Dev https://github.com/jobinau/pg_gather/commit/014228820dbccf95e2e5beccd0504b8d1ae78414 Planned to push to main soon

jobinau avatar Mar 12 '24 17:03 jobinau

Closing as this feature is already in release and widely used. I assume that it is stable as no issue are reported.

jobinau avatar Jun 07 '24 05:06 jobinau