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