# Query Analytics showing old data

**URL:** <https://forums.percona.com/t/query-analytics-showing-old-data/15963>\
**Category:** Percona Monitoring and Management (PMM)\
**Tags:** mysql\
**Created:** [June 2, 2022, 6:19pm UTC](https://forums.percona.com/t/query-analytics-showing-old-data/15963 "2022-06-02T18:19:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bryan\_Dees](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/bryan_dees/32/7061_2.png) [@Bryan\_Dees](https://forums.percona.com/u/Bryan_Dees)\
**Post date:** [June 2, 2022, 6:19pm UTC](https://forums.percona.com/t/query-analytics-showing-old-data/15963/1 "2022-06-02T18:19:47Z")

</div>

We performed a DrupalDB update over the weekend on our MySQL 5.7 database. It’s Thursday, and I’m seeing old TRUNC, DELETE and others from the migration, that are not showing under ‘show full processlist’.

I set the time frame for last 5 minutes, then run show full processlist off the commandline, and am only seeing ‘sleeping’ processes, but in PMM2 Query Analytics, I’m seeing different data.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [June 2, 2022, 6:39pm UTC](https://forums.percona.com/t/query-analytics-showing-old-data/15963/2 "2022-06-02T18:39:05Z")

</div>

@Bryan_Dees,  
PMM is an analytics aggregator. Is is not “realtime”. The stats data from a query you ran a week ago will remain in PMM for 30 days, by default.

---

<div class="post-metadata">

**Author:** ![Bryan\_Dees](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/bryan_dees/32/7061_2.png) [@Bryan\_Dees](https://forums.percona.com/u/Bryan_Dees)\
**Post date:** [June 6, 2022, 5:02pm UTC](https://forums.percona.com/t/query-analytics-showing-old-data/15963/3 "2022-06-06T17:02:56Z")

</div>

Even if you change the time range to something like the last 12 hours? Shouldn’t it just show you those queries found during that time frame?

Thank you.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [June 6, 2022, 5:18pm UTC](https://forums.percona.com/t/query-analytics-showing-old-data/15963/4 "2022-06-06T17:18:57Z")

</div>

That is correct. If you select a specific window, QAN should only show you the stats for queries during that time period. What is your query source? Slow log or perf schema?

---

<div class="post-metadata">

**Author:** ![Bryan\_Dees](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/bryan_dees/32/7061_2.png) [@Bryan\_Dees](https://forums.percona.com/u/Bryan_Dees)\
**Post date:** [June 6, 2022, 6:21pm UTC](https://forums.percona.com/t/query-analytics-showing-old-data/15963/5 "2022-06-06T18:21:03Z")

</div>

It’s perf schema. I set the time frame to 5 minutes, but it’s showing pages and pages of old queries.

This is the pmm-admin command I used to setup  
**pmm-admin add mysql --username=pmm\_admin --password= --server-insecure-tls --query-source=perfschema --socket=/var/lib/mysql/mysql.sock --disable-tablestats-limit=10000**

Thanks!