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

General

Escalation

General

Escalation

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:

How to test

None

How to document

None

FB test

None

Attachments

image-2020-10-09-14-42-39-564.png

09 Oct, 2020

image-2020-10-09-14-42-24-412.png

09 Oct, 2020

image-2020-10-06-13-21-27-674.png

06 Oct, 2020

image-2020-10-06-13-20-59-435.png

06 Oct, 2020

Linked work items

created

PMM-6761

Proceeding with non default settings in PG monitoring with pg_stat_monitor

Activity

Jira Bot

December 11, 2020 at 3:58 PM

Former user

October 12, 2020 at 6:13 PM

Nurlan Moldomurov

October 12, 2020 at 3:20 PM

Jiří Čtvrtka

October 12, 2020 at 2:01 PM

Former user

October 12, 2020 at 10:43 AM

Resize work item view side panel

Done

Details

Assignee

Nurlan Moldomurov

Reporter

Former user(Deactivated)

Priority

Medium

Components

PMM UI

Labels

defecttech/PostgreSQL

Needs QA

Yes

Fix versions

2.11.0

Story Points

Sprint

Add sprint

Regression Issue

Yes

Affects versions

2.11.0

Created October 6, 2020 at 11:23 AM

Updated March 6, 2024 at 3:49 AM

Resolved October 13, 2020 at 7:48 AM