No query examples in the Examples tab

Percona Monitoring and Management (PMM)
1

Description:

I just set up PMM.

I’m seeing queries in QAN, but the Examples tab (and the Plan tab as well) are empty:

image
image1920×959 141 KB

When I go to Explore and run select example from pmm.metrics limit 10; on ClickHouse, I get a list if 10 empty strings.

Is this normal for Postgres?

Version:

PMM 3.5.0
Postgres 12.22
pg_stat_monitor 2.1.0

2

Can you please check whether the PMM client service was added with the Disable Query Examples option enabled?

  1. (Optional) If using pgstatmonitor, check Disable query examples under Additional options to prevent collection of actual query values. This protects sensitive data while preserving all query metrics and performance statistics in QAN.
3

I don’t see any way to double check the settings of a service after it has been created, but I left all the settings on their defaults, which look like this:

image
image365×198 10.7 KB

4

We don’t support PostgreSQL 12. You will need to upgrade to a modern, supported version of PG.