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

Improve QAN with PostgreSQL EXPLAIN visualization

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: PMM UI, UX
    • Labels:

      Description

      What about improving PMM's QAN for PostgreSQL to include EXPLAIN plans visualization?

      We can find much of the required work already done and contributed by Alex Tatiyants in the PostgreSQL Explain Visualizer (PEV), which is illustrated in more details in his post PostgreSQL Query Plan Visualization. His work has been in turn inspired by the "classic" Despez's  PostgreSQL's explain analyze made readable.

      Recently, pganalyze also included a similar feature in their product, which relies on PostgreSQL's auto_explain module.

      PS: there's PMM-45-28 as well.

       

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            fernando.laudares@percona.com Fernando Laudares
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Smart Checklist