# QAN and query plan

**URL:** <https://forums.percona.com/t/qan-and-query-plan/29281>\
**Category:** pg\_stat\_monitor\
**Created:** [March 21, 2024, 3:00pm UTC](https://forums.percona.com/t/qan-and-query-plan/29281 "2024-03-21T15:00:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lanselot](https://avatars.discourse-cdn.com/v4/letter/l/5daacb/32.png) [@lanselot](https://forums.percona.com/u/lanselot)\
**Post date:** [March 21, 2024, 3:00pm UTC](https://forums.percona.com/t/qan-and-query-plan/29281/1 "2024-03-21T15:00:02Z")

</div>

Hi. Please help. Cant understand where I’ve mistaken. Enabled plan analytics for pg stat monitor:  
pg\_stat\_monitor.pgsm\_enable\_query\_plan = on  
It’s even shown in pg\_settings (checked by query). But in grafana shows “No plan found” in “Plan” tab of QAN section. May be some other settings should to be done? Latest Percona, Postgres ver - 16.1.  
UPD Checked by “SELECT substr(query,0,50), query\_plan from pg\_stat\_monitor limit 10;” query… Looks like plans are collecting. Why pmm shows “No plan found” then…

---

<div class="post-metadata">

**Author:** ![artem\_gavrilov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/artem_gavrilov/32/1453_2.png) [@artem\_gavrilov](https://forums.percona.com/u/artem_gavrilov)\
**Post date:** [March 27, 2024, 12:25pm UTC](https://forums.percona.com/t/qan-and-query-plan/29281/2 "2024-03-27T12:25:56Z")

</div>

Hello @lanselot , what are the versions of your PMM Server and PMM agent?

---

<div class="post-metadata">

**Author:** ![lanselot](https://avatars.discourse-cdn.com/v4/letter/l/5daacb/32.png) [@lanselot](https://forums.percona.com/u/lanselot)\
**Post date:** [March 29, 2024, 10:15am UTC](https://forums.percona.com/t/qan-and-query-plan/29281/3 "2024-03-29T10:15:51Z")

</div>

Hi, Artem. Agent - 2.41.1, Server - 2.41.2

---

<div class="post-metadata">

**Author:** ![Agustin\_G](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/agustin_g/32/14111_2.png) [@Agustin\_G](https://forums.percona.com/u/Agustin_G)\
**Post date:** [April 10, 2024, 12:39am UTC](https://forums.percona.com/t/qan-and-query-plan/29281/4 "2024-04-10T00:39:01Z")

</div>

Hi,

Have you checked that the query that returned the plan from your manual SELECT query is the same you are checking in the PMM QAN dashboard?

Do you see query plans empty for all of your Postgres queries in the QAN dashboard?

If you run the following in the client side, you’ll be able to get a .zip file with the logs. Check the QAN exporter logs just in case:

```auto
pmm-admin summary

```

---

<div class="post-metadata">

**Author:** ![lanselot](https://avatars.discourse-cdn.com/v4/letter/l/5daacb/32.png) [@lanselot](https://forums.percona.com/u/lanselot)\
**Post date:** [April 10, 2024, 8:31am UTC](https://forums.percona.com/t/qan-and-query-plan/29281/5 "2024-04-10T08:31:31Z")

</div>

Hi,  
as I wrote in UPD plans are collecting. Checked plans in dash… in 1 case of approximately 20 plans are shown. That’s strange.