PMM does not found a plan for some queries

Description

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,

How to test

None

How to document

None

Activity

Show:

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 https://github.com/percona/pg_stat_monitor/blob/7f1344e12d8b3b41be45c3b27b9fe5d43adee9cc/pg_stat_monitor.c#L711 ?

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.

Details

Assignee

Reporter

Priority

Labels

Needs QA

Yes

Needs Doc

Yes

Affects versions

Smart Checklist

Created November 21, 2024 at 4:37 PM
Updated November 28, 2024 at 7:44 AM

Flag notifications