# Feedback on PMM QAN

**URL:** https://forums.percona.com/t/feedback-on-pmm-qan/7621
**Category:** PMM 2.x
**Created:** [May 14, 2020, 12:06am UTC](https://forums.percona.com/t/feedback-on-pmm-qan/7621 "2020-05-14T00:06:18Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Venkat](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/venkat/32/5328_2.png) [@Venkat](https://forums.percona.com/u/Venkat)
#### Post date: [May 14, 2020, 12:06am UTC](https://forums.percona.com/t/feedback-on-pmm-qan/7621/1 "2020-05-14T00:06:18Z")

</div>

PMM is a great tool. One of few things that are not intuitive are the QAN labels. For&nbsp;example I fixed my range to last one hour. The description for “load” reads:“The&nbsp;_load_&nbsp;is the amount of time that the database server spent during the selected time or date range running all queries.”  
  
The data for “load” for example shows:Total: 2.28Top three for load: 0.55 load, 0.17, 0.17  
  
What do these numbers mean? 2.28 minutes of the 1 hour, or 2.28% of one hour time?It shows 2.28 load as 100% in the Total line. So not really very intuitive what does this 2.28 number represent (unit). The numbers for individual queries do make sense. As I figured these are % of the total. For example the top most query shows 0.55 load as 24%.  
Secondly, even though I added several hosts, the QAN only shows handful even after expanding the list. I do see data on other charts for those but not in QAN. What could I be missing?

---

<div class="post-metadata">

### Author: ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)
#### Post date: [May 14, 2020, 8:56am UTC](https://forums.percona.com/t/feedback-on-pmm-qan/7621/2 "2020-05-14T08:56:48Z")

</div>

Hi @Venkat   
I agree the load description is confusing.&nbsp; The other term used by some for this is Average Active Sessions.&nbsp; &nbsp; &nbsp; If you have load of 2.28 this means in average you have seen on the hosts&nbsp; in the list 2.28 queries running concurrently.&nbsp; &nbsp; It is&nbsp; not hour or minute but rather unitless number.  
  
The % of the total is&nbsp; what the given load is compared to the total so if total load is 100 and given query&nbsp; load is 20&nbsp; it will be 20% of total.  
  
For your second question I’m not sure what you’re referring to - consider including a picture

---

<div class="post-metadata">

### Author: ![Venkat](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/venkat/32/5328_2.png) [@Venkat](https://forums.percona.com/u/Venkat)
#### Post date: [May 18, 2020, 5:19pm UTC](https://forums.percona.com/t/feedback-on-pmm-qan/7621/3 "2020-05-18T17:19:34Z")

</div>

Hi Peter,Thank you for the excellent explanation! Please find the screenshots attached.As you can see, there are 15 databases monitored but the QAN shows only 8 of them.Regards.-Venkat

 ![Screen Shot 2020-05-16 at 9.21.24 AM.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/2423be84fb68367ec53395e16b08706321cab176.png)

 ![Screen Shot 2020-05-16 at 9.30.28 AM.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c159542347e51cc0ef1b43f27c28d4bdcacbe4f4.png)

---

<div class="post-metadata">

### Author: ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)
#### Post date: [May 18, 2020, 5:28pm UTC](https://forums.percona.com/t/feedback-on-pmm-qan/7621/4 "2020-05-18T17:28:47Z")

</div>

The query Analytics only shows databases if there are queries&nbsp; running on them.&nbsp; &nbsp;If other nodes have query traffic it means they are possibly not configured to send query data to PMM correctly  
  
Check out “MySQL&nbsp; Instances Overview” dashboard - do you have all 15 instances listed out there ?

---

<div class="post-metadata">

### Author: ![eugeneb](https://avatars.discourse-cdn.com/v4/letter/e/d07c76/32.png) [@eugeneb](https://forums.percona.com/u/eugeneb)
#### Post date: [June 2, 2020, 7:53am UTC](https://forums.percona.com/t/feedback-on-pmm-qan/7621/5 "2020-06-02T07:53:38Z")

</div>

Hey Peter,  
Which nodes should be configured to send query data to PMM in Sharded MongoDB setup, the _mongos_ nodes or the nodes running _mongod_ which constitute a replica set?  
Thanks,  
Eugene
