pmm_rep - A script to generate a weekly query analytics email report

[arched]

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:

https://arch-ed.dk/pmm_query_analytics_reporting
https://github.com/RasmusEdgar/pmm_rep

Perhaps, some of you might find it useful.

Br,
Rasmus Edgar

[Mykola]

Hi Rasmus,

Thank you!

I stared your repo also I shared github link internally.

[arched]

Thank you Mykola.

Btw, feature and pull requests are welcome.

[arched]

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.