Explanation of Database Queries Window Weight (%) column

[jodom]

i'm having trouble understanding the definition of the Weight % column in Database Queries Window. The documentation states, "

• Weight (%): The percentage of the total time consumed by the query." Where is the total time coming from? Thanks!

[Saradhi.Potharaju · Accepted solution]

Hi,

It is calculated based on the selected time frame in the UI. (for example "last 15 minutes", "last 30 minutes")

For example, refer to the attached screenshots. For 15 min weight was 66.7% but for 30 min it is 50% as there are other queries too.

The formula is ( (Time elapsed by query of the same type )/ (total time elapsed by queries of all types))*100

PS: If this answer helped you or solved your issue, please click Accept Solution below.

Regards,
Saradhi