Hi,
I am currently running a PMM server on the latest version 2.42 on docker and I am trying to activate the execution plan to test and measure what is the impact of activating such a feature.
I am monitoring a PostgreSQL 16.1 instance with pg_stats_monitor but the execution plan are not displaying :
Here are the logs I found in PostgreSQL, apparently PMM is not compatible with this PG16 ?
2024-08-26 17:07:45.873 CEST - 2 - 48363 - 10.0.0.5 - pmm@postgres - 0STATEMENT: SELECT t2.rolname, t3.datname, SUBSTRING(query FROM 1 FOR 40) AS query, total_plan_time, max_plan_time, mean_time_plan, calls, total_exec_time, max_exec_time, mean_exec_time, rows, shared_blks_hit FROM pg_stat_statements t1 JOIN pg_roles t2 ON (t1.userid=t2.oid) JOIN pg_database t3 ON (t1.dbid=t3.oid) WHERE t2.rolname != ‘rdsadmin’
2024-08-26 17:07:55.882 CEST - 1 - 48401 - 10.0.0.5 - pmm@postgres - 0ERROR: column “mean_time_plan” does not exist at character 105
2024-08-26 17:07:55.882 CEST - 2 - 48401 - 10.0.0.5 - pmm@postgres - 0STATEMENT: SELECT t2.rolname, t3.datname, SUBSTRING(query FROM 1 FOR 40) AS query, total_plan_time, max_plan_time, mean_time_plan, calls, total_exec_time, max_exec_time, mean_exec_time, rows, shared_blks_hit FROM pg_stat_statements t1 JOIN pg_roles t2 ON (t1.userid=t2.oid) JOIN pg_database t3 ON (t1.dbid=t3.oid) WHERE t2.rolname != ‘rdsadmin’