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

Update Query Analytics UI to clarify estimated results on MySQL 'explain' response where we modified original query

Details

    • Improvement
    • Status: Done
    • Medium
    • Resolution: Done
    • None
    • 2.20.0
    • PMM UI
    • 1
    • Yes
    • Yes
    • [obsolete] C/S Core

    Description

      Now the MySQL explain response is a JSON with this structure:

      {
         "explain_result": []byte,
         "explained_query": string,
         "is_dml": bool
      }

      Explained query has the query that was explained.
      If it is a SELECT, it is going to be equal to the original query but if is_dml is true, we should show a message saying that the query was changed by an equivalent SELECT.

      There is a feature build that can be used for testing: https://github.com/Percona-Lab/pmm-submodules/pull/1741

      Attachments

        1. de-latest.png
          de-latest.png
          38 kB
        2. fb.png
          fb.png
          31 kB
        3. image-2021-06-04-13-42-52-462.png
          image-2021-06-04-13-42-52-462.png
          11 kB
        4. Screenshot 2021-06-18 at 11.28.29.png
          Screenshot 2021-06-18 at 11.28.29.png
          81 kB
        5. Screenshot 2021-06-18 at 11.29.50.png
          Screenshot 2021-06-18 at 11.29.50.png
          34 kB

        Issue Links

          Activity

            People

              tiago.mota Tiago Mota (Inactive)
              carlos.salguero Carlos Salguero (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 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 day, 4 hours
                  1d 4h

                  Smart Checklist