The current PMM client is a Virtual Appliance on vSphere running 2.21.0 of PMM. [root@localhost access]# /usr/sbin/percona-qan-api2 --data-retention=30 --debug --trace stdlog: qan-api2 v2.21.0. INFO[2021-09-20T14:01:17.038+00:00]qan-api2/main.go:284 main.main Log level: trace. stdlog: dsn: cli…

Hi @Davud_Can We couldn’t reproduce this behavior, but we have workaround for you. could you do these manual steps in your clickhouse? log in into clickhouse. go to pmm db using use pmm; execute ALTER TABLE metrics ADD COLUMN `m_plans_calls_cnt` Float32, ADD COLUMN `m_plans_calls_sum` Float32 …

Pmm upgrade from 2.16 to 2.21 query analytics not starting QAN doesn't display any data

Percona Monitoring and Management (PMM) PMM 2.x

Davud_Can September 22, 2021, 11:34am 7

Hi @nurlan

I am attaching the output you requested as an attachment.

Regards,desc_pmm_metrics.txt (12.4 KB)

1 Like

Topic		Replies	Views
Percona PMM query analytics is broken Percona Monitoring and Management (PMM) grafana , pmm , postgresql	9	207	August 26, 2025
QAN API is Down after upgrade the PMM server from 2.44.0 to 3.2.0 version Percona Monitoring and Management (PMM)	6	163	June 29, 2025
QAN empty after upgrade PMM 2.x pmm	4	261	January 24, 2025
Query analytics not working PMM 1.x	12	3882	September 14, 2017
Problems with qan in 1.8.0 PMM 1.x	16	1412	April 27, 2018

Pmm upgrade from 2.16 to 2.21 query analytics not starting QAN doesn't display any data

Related topics