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

No query Examples on PostgreSQL 12 with pg_stat_monitor

Details

    Description

      Impact on the user: 

      Users are not getting all information  from pg_stat_monitor and not consuming all features

       

      STR

      1. Install Pecrona distribution  and PG12 
      2. setup pg_stat_monitor usage 

      Expected results: 
      Query examples + new metrics in qAN 

       

      Given results: 

      No Examples,  new metrics only .

       

      Used PMM demo install  https://pmmdemo.percona.com/graph/d/pmm-qan/pmm-query-analytics?var-environment=All&var-cluster=All&var-replication_set=All&var-database=All&var-schema=All&var-node_name=All&var-service_name=All&var-service_name=pg12-postgresql&var-username=All&var-service_type=All&var-node_type=All&var-interval=$__auto_interval_interval&columns=%5B%22load%22,%22num_queries%22,%22query_time%22%5D&group_by=queryid&filter_by=223BF0CC88C5679&order_by=-load&from=now-12h&to=now&totals=false&query_selected&details_tab=examples  

       

      by  aleksandar.yanakiev

       

      Also tried AWS Stage  (PG distribution 12 ), but it looks like no pg_stat_monitor, only pg_stat_statement for it 

       

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              roma.novikov Roma Novikov
              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 - 6 hours, 40 minutes
                  6h 40m

                  Smart Checklist