# Understanding Percona Cloud tools metrics and Query Analysis Output

**URL:** https://forums.percona.com/t/understanding-percona-cloud-tools-metrics-and-query-analysis-output/4182
**Category:** Percona Cloud Tools
**Created:** [April 24, 2015, 8:40pm UTC](https://forums.percona.com/t/understanding-percona-cloud-tools-metrics-and-query-analysis-output/4182 "2015-04-24T20:40:46Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![yudhvir12](https://avatars.discourse-cdn.com/v4/letter/y/85f322/32.png) [@yudhvir12](https://forums.percona.com/u/yudhvir12)
#### Post date: [April 24, 2015, 8:40pm UTC](https://forums.percona.com/t/understanding-percona-cloud-tools-metrics-and-query-analysis-output/4182/1 "2015-04-24T20:40:46Z")

</div>

Hi All,

I recently started using Percona monitoring tool and I felt some difficult in understanding the metrics and Query Analysis Output like

1. MySQL Throughput
2. MySQL SelectTypes
3. MySQL Command

Also, I need some help in understanding the AvgMYSQL/Queries, AvgMySQL/Select\_Scan, 5/95, Min/Max etc.,

Along with the above, when I am monitoring what are the expensive queries under “Queries” tab, I can see different terms like Load, Load%, 95%.

Also, when I execute any query for 1 time on my MYSQL DB server , but percona query monitoring is showing the query execution as 2 …Can any one explain what is the reason for that.

Last but not least, I can understand the File sort, Full Join, Full Scan under the query plan, but I could not able to understand the pecentage values for each operation (filesort,full join, and full scan) for a particular query.

Can any one please help me out in understanding the above items.

---

<div class="post-metadata">

### Author: ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)
#### Post date: [April 30, 2015, 7:12am UTC](https://forums.percona.com/t/understanding-percona-cloud-tools-metrics-and-query-analysis-output/4182/2 "2015-04-30T07:12:42Z")

</div>

For most part of your questions I would like to redirect you to Percona Cloud Tools documentation here [http://cloud-docs.percona.com/](http://cloud-docs.percona.com/)

> > Also, when I execute any query for 1 time on my MYSQL DB server , but percona query monitoring is showing the query execution as 2 …Can any one explain what is the reason for that.

I will check this with PCT development team and will check If it’s bug.