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

PostgreSQL Histograms added to QAN when using pg_stat_monitor extension

Details

    Description

      User story:
      As a DBA and PMM user I want to be able to see Histograms in QAN when I'm using pg-stat_monitor from Percona to monitor my PG server performance.

      Histograms provide much more explicit information about the number of queries for this Fingerprint or set of them executed in different time buckets

      UI/UX:
      TBD
      ali.ndlovu PTAL

      Acceptance criteria

      • User able to see Histogram distribution when looking at Details of Query collected with pg_stat_monitor

      Out of scope:

      • histograms of several Query fingerprints (because of complex UX in this case )

      Suggested implementation:
      TBD

      How to test:
      TBD

      Details:

      Looks like we can't  get the pg_stat_monitor.pgsm_respose_time_step setting for every Bucket we preparing in pg_stat_monitor (!!!)

      TBD

      https://github.com/percona/pg_stat_monitor/blob/master/docs/USER_GUIDE.md#call-timings-histogram

      Attachments

        Issue Links

          Activity

            People

              jiri.ctvrtka Jiří Čtvrtka
              roma.novikov Roma Novikov
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist