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
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
are you refering to this the filter of select queries in order to save the plan ?
Nurlan Moldomurov November 21, 2024 at 10:32 PM
Hello , I need to confirm it with PGSM team, but seems like query plan is available only for SELECT queries.
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,