Emergency

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

  • #2
    Hi Rasmus,

    Thank you!

    I stared your repo also I shared github link internally.

    Comment


    • #3
      Thank you Mykola.

      Btw, feature and pull requests are welcome.

      Comment


      • #4
        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.
        Last edited by arched; 05-16-2017, 03:07 PM.

        Comment

        Working...
        X