topic Re: How is 'total time' of database query being calculated? in Open Q&A

How is 'total time' of database query being calculated?

waikeat_chan — Tue, 30 Mar 2021 07:34:05 GMT

In this screenshot below, I can understand what each figure means or how they're calculated.

Except total time, I don't know how to get the 18.2 min/min no matter how I multiply and/or divide the other numbers seen in this screenshot.

Anybody has any idea?

Best Regards,

Wai Keat

Re: How is 'total time' of database query being calculated?

Babar_Qayyum — Mon, 29 Mar 2021 08:29:01 GMT

Hello @waikeat_chan

It seems the Total time is calculating for the Response time media and Response time slowest 10% of executions. Therefore, we are unable to divide and get the exact total time showing in the screenshots.

Moreover, the document is also guiding that to reveal which statements have the highest overall response time, select Sort by total time from the Sort drop list.

Regards,

Babar