Remove pmm-server PostgreSQL instance from Query Analytics and Dashboards default view

Description

The problem:

On PMM Query Analytics, the default view is to display query activity from all instances, including the internal PostgreSQL instance.  This is of limited value to Users who are not focused on the performance of PMM Server and are confused by what these queries represent.  Users want to see queries from their own monitored instances instead.

 

Proposed solution: 

  • Start using  Environments for Internal Services 

  • Find a way to nicely exclude ^  Env  from the default  view 

How to test

None

How to document

None

AFFECTED CS IDs

277478, CS0012771, CS0036482

Attachments

1

Activity

Matthew Boehm 
April 15, 2025 at 2:52 PM

For QAN, PMM has native capability to parse query comments. Why not simply comment/tag all PGSQL PMM queries, and filter them by default?

Tibor Korocz (Percona) 
April 8, 2025 at 10:46 AM

Hi,

I would keep collecting data from PMM instance as well but in default I would might hide it (but you could easily show them) or as PZ suggested I would have a separate menu where you would see the system metrics or the health of PMM installation which could include PG and even data from clickhouse and victoriametrics as well.. that would be even more important when we start providing PMM HA and you want to monitor the health of these databases …

Peter Zaitsev 
April 7, 2025 at 10:02 AM

Hi,

How it should be properly done is you put the PMM in its own environment -
"system" or something like that where you do not show it by default

Disabling PMM monitoring is silly as it can have performance problems on
its own... but it is different use case for the different user and should
not be mixed with "normal" traffic

Michael Coburn 
February 13, 2025 at 11:25 PM

Hi , saw your most recent note - may I suggest that we don’t actually wait for the 1st service to be added, instead disable the pmm-server from Query Analytics by default always.

An “empty” PMM Server (no services yet added), when viewing Query Analytics could instead have a note indicating that the queries will be available after they add a service. The point of this ticket is that when you go in QAN you should only ever see queries related to your application.

Regarding the PMM internal dashboards please don’t change anything there, they are available when needed to identify bottlenecks with metrics ingestion and display.

ankit.kapoor 
February 9, 2023 at 4:40 PM

This happened with my current ongoing customer and they were confused that how come PG is showing here when they don't have any PG instance. Creating a tag or at least some comments ( like this is for PMM server) can clear out these confusions.

Details

Assignee

Reporter

Priority

Components

Needs QA

Needs Doc

Planned Version/s

Story Points

Affects versions

Created September 18, 2020 at 8:11 PM
Updated May 14, 2025 at 6:42 AM