Feedback on PMM QAN
PMM is a great tool. One of few things that are not intuitive are the QAN labels. For example I fixed my range to last one hour. The description for "load" reads:
"The load 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:
Top 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?