# PMM Query Analytics Unexpected Results

**URL:** <https://forums.percona.com/t/pmm-query-analytics-unexpected-results/7313>\
**Category:** PMM 1.x\
**Created:** [November 26, 2019, 6:14am UTC](https://forums.percona.com/t/pmm-query-analytics-unexpected-results/7313 "2019-11-26T06:14:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sh123](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sh123](https://forums.percona.com/u/sh123)\
**Post date:** [November 26, 2019, 6:14am UTC](https://forums.percona.com/t/pmm-query-analytics-unexpected-results/7313/1 "2019-11-26T06:14:14Z")

</div>

Currently when I view the Query Analytics page, it appears to only show me query that were ran on the MySQL console, but what I was expecting was to see all queries that the database handled. I have a site running code which then gets executed to my MySQL databases, I was hoping the Query Analytics would show me those queries that were requested from the code.

If I run pmm-admin list, this is what I get

pmm-admin list  
pmm-admin 1.17.2

PMM Server | XXXX  
Client Name | test  
Client Address | XXXX  
Service Manager | linux-systemd

* * *

SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS

* * *

mysql:queries test - YES pmm:_**@tcp(172.17.0.1:3308) query\_source=perfschema, query\_examples=true  
linux:metrics test 42000 YES -  
mysql:metrics test 42002 YES pmm:**_@tcp(172.17.0.1:3308)

---

<div class="post-metadata">

**Author:** ![sh123](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sh123](https://forums.percona.com/u/sh123)\
**Post date:** [November 27, 2019, 3:36am UTC](https://forums.percona.com/t/pmm-query-analytics-unexpected-results/7313/2 "2019-11-27T03:36:06Z")

</div>

Attached is an image of what I can see.  
Update: I just checked today and now it says MySQL Server is not configured for monitoring?

 ![Capture2.PNG](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/653cb96f3483a071db0ffd65b60888cb2f6c7f9d.png)

 ![Capture3.PNG](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/31d83e7199ffd8c9a01d2e68a0d3266c6abf6650.png)

---

<div class="post-metadata">

**Author:** ![sh123](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sh123](https://forums.percona.com/u/sh123)\
**Post date:** [November 27, 2019, 9:37am UTC](https://forums.percona.com/t/pmm-query-analytics-unexpected-results/7313/3 "2019-11-27T09:37:34Z")

</div>

For some reason when I filter it by a month, i’m seeing the expected results. And when I hover over the graph, I can still see data being recorded for today. So why can’t I view this query when I select to filter by today? Is there also a way to enlarge the chart?

 ![Capture4.PNG](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/654d6bc698cd8733cfc7f9906da70026b416f4e1.png)