PMM does not found a plan for some queries
Description
How to test
How to document
Activity
Diego Fronza November 27, 2024 at 2:37 PM
Currently pgsm only collects plans for SELECT type queries, I’ll bring the discussion about collecting plans for other query types with the team. The initial implementation was done by Ibrar so not sure why he decided to collect plans only for SELECT, my best guess is that SELECT queries can usually be much complex than the other query types, thus requiring more detailed analysis.
Nurlan Moldomurov November 22, 2024 at 10:30 AM
@Jaime Soler I was refering to pg_stat_monitor examples in documentation and in this ticket, there are only plans for select queries, but thank to your finding it seems like I was right.
Jaime Soler November 22, 2024 at 9:49 AM
@Nurlan Moldomurov are you refering to this the filter of select queries in order to save the plan https://github.com/percona/pg_stat_monitor/blob/7f1344e12d8b3b41be45c3b27b9fe5d43adee9cc/pg_stat_monitor.c#L711 ?
Nurlan Moldomurov November 21, 2024 at 10:32 PM
Hello @Ana Galan , I need to confirm it with PGSM team, but seems like query plan is available only for SELECT queries.
Details
Details
Assignee
Reporter
Priority
MediumComponents
Labels
Needs QA
Needs Doc
Affects versions
Smart Checklist
Open Smart Checklist
Smart Checklist
Hi,
I have deployed PMM Server version 2.43.2 and PMM Client version 2.43.2, monitoring a PostgreSQL 15 with the pg_stat_monitor extension.
In some queries, I see the plan, but in other queries, I don't. I attached screenshots with examples so you can see that in some, I can see the plan, but in others, I can't.
Regards,