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

PostgreSQL examples shown despite '--disable-queryexamples' option

    XMLWordPrintable

    Details

    • Story Points:
      2
    • Sprint:
      Platform Sprint 27
    • Needs Review:
      Yes
    • Needs QA:
      Yes

      Description

      User impact:
      User can see query examples even if --disable-queryexamples is passed

      STR:
      Install PMM:

      server docker - perconalab/pmm-server-fb:PR-1150-c62df66
      client docker - perconalab/pmm-client-fb:PR-1150-c62df66
      client - https://s3.us-east-2.amazonaws.com/pmm-build-cache/PR-BUILDS/pmm2-client/pmm2-client-PR-1150-c62df66.tar.gz

      Add to postgresql config file:

      shared_preload_libraries=pg_stat_monitor,pg_stat_statements
      track_activity_query_size=2048
      pg_stat_statements.max=10000
      pg_stat_statements.track=all
      pg_stat_statements.save=off
      track_io_timing=on

      Enable extension:

      create extension pg_stat_monitor;

      Add Percona distribution for PG 11 or 12 to monitoring with disable-queryexamples flag:

      pmm-admin add postgresql --query-source=pgstatmonitor --password=pass pgstatmonitor_without_examples --disable-queryexamples

      Run some queries and check in QAN / Examples tab

       

      Result:

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nurlan.moldomurov Nurlan Moldomurov
              Reporter:
              beata.handzelova Beata Handzelova
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Smart Checklist