Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-8301

Add collecting and presenting new dimensions of pg_stat_monitor such as Application Name,Top Query, Plan in Query Analytics

Details

    Description

      User story:
      As a PMM user, I need to be able to collect properly data exposed by pg_stat_monitor plugin based on the next dimension plugin exposed in PG-196

      UI/UX:
      N/A

      Acceptance criteria

      • Data from PG collected and stored in PMM(QAN) with respect to newly added dimensions
      • Fileds from pg_stat-monitor converted to dimensions are: application_name, top_queryid, planid  
      • QAN working as previously, but grouping data from different new dimensions if here several records for one Fingerprint
      • API supports new dimensions 

      Out of scope:

      • UI presentation of dimensions

      Suggested implementation:
      TBD

      How to test:
      TBD

      Details:
      TBD

       

      More details can be found here:

      https://confluence.percona.com/display/PMM/QAN+PostgreSQL+pg_stat_monitor+data+mapping

      Attachments

        Issue Links

          Activity

            People

              jiri.ctvrtka Jiří Čtvrtka
              taras.kozub Taras Kozub
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 week, 1 day, 1 hour
                  1w 1d 1h

                  Smart Checklist