# Pg\_stat\_monitor 2.2 - Collapsing similar queries

**URL:** <https://forums.percona.com/t/pg-stat-monitor-2-2-collapsing-similar-queries/39763>\
**Category:** PMM 3.x\
**Created:** [November 20, 2025, 1:53pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-2-collapsing-similar-queries/39763 "2025-11-20T13:53:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ANDiv1976](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/andiv1976/32/20170_2.png) [@ANDiv1976](https://forums.percona.com/u/ANDiv1976)\
**Post date:** [November 20, 2025, 1:53pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-2-collapsing-similar-queries/39763/1 "2025-11-20T13:53:28Z")

</div>

Why doesn’t pg\_stat\_monitor 2.2 collapse such similar queries? Under high TPS, all buckets get filled with identical queries. As a result, it starts consuming more shared memory. It can collapse similar queries. In pg\_stat\_monitor, during just a few seconds of testing, there are 47,000 rows, with a limit of 20 buckets and pgsm\_max of 192MB.

 ![изображение](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/9/3/93a9b108cc8615c09e311f6b423d7afb7526c2eb.jpeg)

Is there a way to collapse similar queries? Which parameter in pg\_stat\_monitor is needed for this? I couldn’t find it in the documentation.

---

<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:** [November 21, 2025, 12:38pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-2-collapsing-similar-queries/39763/2 "2025-11-21T12:38:42Z")

</div>

Hi @ANDiv1976 , it seems that there is some difference between these queries. Could you please check `queryid`, `planid`, `userid`, `dbid`, `toplevel`, and `top_queryid`fields in `pg_stat_monitor` view for this queries ? Which of them hold different values?

---

<div class="post-metadata">

**Author:** ![ANDiv1976](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/andiv1976/32/20170_2.png) [@ANDiv1976](https://forums.percona.com/u/ANDiv1976)\
**Post date:** [November 22, 2025, 9:34am UTC](https://forums.percona.com/t/pg-stat-monitor-2-2-collapsing-similar-queries/39763/3 "2025-11-22T09:34:24Z")

</div>

![изображение](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/7/0/70f75d85217ef2b98fb4a34b11cdab5217b725a6.png)

---

<div class="post-metadata">

**Author:** ![ANDiv1976](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/andiv1976/32/20170_2.png) [@ANDiv1976](https://forums.percona.com/u/ANDiv1976)\
**Post date:** [November 24, 2025, 5:06am UTC](https://forums.percona.com/t/pg-stat-monitor-2-2-collapsing-similar-queries/39763/4 "2025-11-24T05:06:31Z")

</div>

Hi @artem_gavrilov I hope the screenshot has all the necessary information.

---

<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:** [November 25, 2025, 2:38pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-2-collapsing-similar-queries/39763/5 "2025-11-25T14:38:29Z")

</div>

I think you was hit by this bug: [Jira](https://perconadev.atlassian.net/browse/PG-1305)

Try to disable `pg_stat_monitor.pgsm_enable_query_plan = off`

---

<div class="post-metadata">

**Author:** ![ANDiv1976](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/andiv1976/32/20170_2.png) [@ANDiv1976](https://forums.percona.com/u/ANDiv1976)\
**Post date:** [November 25, 2025, 3:24pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-2-collapsing-similar-queries/39763/6 "2025-11-25T15:24:14Z")

</div>

**Looking forward to the bug fix. Thanks!**