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

New Filter: "Command Type" allows filtering queries based on type (SELECT, INSERT, UPDATE, DELETE, n/a) when pg_stat_monitor extension enabled

Details

    Description

      User story: As a PMM user, I need to be able to see and filter QAN data for PG based on Command Type (SELECT, DELETE... ) so I can simplify my problem's investigation 

        

      UI/UX:

      TBD

       

      Acceptance criteria:

      • Users are able to see a new section in the Left menu - "Command type" with values like "SELECT, INSERT, UPDATE, DELETE, n/a."
      • User able to filter by the Command type as by usual label 

       

      Out of scope:

      • Adding this to "group By " as this is just an additional label for the query 

       

      Suggested implementation:

       

      How to test:

       

      Details:

      This will be added later to MySQL. 

       

      more details: https://github.com/percona/pg_stat_monitor/blob/master/docs/USER_GUIDE.md#query-command-type-select-insert-update-or-delete

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              roma.novikov Roma Novikov
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist