# pmm\_rep - A script to generate a weekly query analytics email report

**URL:** <https://forums.percona.com/t/pmm-rep-a-script-to-generate-a-weekly-query-analytics-email-report/5499>\
**Category:** PMM 1.x\
**Created:** [March 21, 2017, 6:55am UTC](https://forums.percona.com/t/pmm-rep-a-script-to-generate-a-weekly-query-analytics-email-report/5499 "2017-03-21T06:55:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![arched](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@arched](https://forums.percona.com/u/arched)\
**Post date:** [March 21, 2017, 6:55am UTC](https://forums.percona.com/t/pmm-rep-a-script-to-generate-a-weekly-query-analytics-email-report/5499/1 "2017-03-21T06:55:27Z")

</div>

Hi,

I couldn’t find a tool to generate a weekly query analytics email report, when using an on-premises PMM installation.

I then wrote pmm\_rep, which fetches data from PMMs qan-api and generates a multipart email report containing last weeks top 10:

[url][arch-ed.dk](https://arch-ed.dk/pmm_query_analytics_reporting%5B/url%5D)  
[url][https://github.com/RasmusEdgar/pmm\_rep[/url]](https://github.com/RasmusEdgar/pmm_rep%5B/url%5D)

Perhaps, some of you might find it useful.

Br,  
Rasmus Edgar

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [March 21, 2017, 7:25am UTC](https://forums.percona.com/t/pmm-rep-a-script-to-generate-a-weekly-query-analytics-email-report/5499/2 "2017-03-21T07:25:03Z")

</div>

Hi Rasmus,

Thank you!

I stared your repo 🙂 also I shared github link internally.

---

<div class="post-metadata">

**Author:** ![arched](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@arched](https://forums.percona.com/u/arched)\
**Post date:** [March 21, 2017, 2:46pm UTC](https://forums.percona.com/t/pmm-rep-a-script-to-generate-a-weekly-query-analytics-email-report/5499/3 "2017-03-21T14:46:36Z")

</div>

Thank you Mykola.

Btw, feature and pull requests are welcome. 🙂

---

<div class="post-metadata">

**Author:** ![arched](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@arched](https://forums.percona.com/u/arched)\
**Post date:** [May 16, 2017, 2:17pm UTC](https://forums.percona.com/t/pmm-rep-a-script-to-generate-a-weekly-query-analytics-email-report/5499/4 "2017-05-16T14:17:39Z")

</div>

I just wanted to add that the weekly top 10 report is very helpful for spotting tables which need indexing and long queries which need to be investigated. We have optimized several very long running queries the last couple of months because of this. Shameless self bump, I guess, but I genuinely believe that pmm\_rep is a helpful addon to PMM for sysadms/dbas.