# PMM2 - realtime 'full processlist' dashboard

**URL:** <https://forums.percona.com/t/pmm2-realtime-full-processlist-dashboard/8073>\
**Category:** PMM 2.x\
**Created:** [September 23, 2020, 11:44am UTC](https://forums.percona.com/t/pmm2-realtime-full-processlist-dashboard/8073 "2020-09-23T11:44:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tcrowley](https://avatars.discourse-cdn.com/v4/letter/t/b5e925/32.png) [@tcrowley](https://forums.percona.com/u/tcrowley)\
**Post date:** [September 23, 2020, 11:44am UTC](https://forums.percona.com/t/pmm2-realtime-full-processlist-dashboard/8073/1 "2020-09-23T11:44:46Z")

</div>

In PMM2, I am trying to find a dashboard that is equivalent or similar to the Monyog ‘threads’ dashboard, which essentially shows the `show fullprocesslist;` output in near realtime.

Is there a similar dashboard in PMM2? If not, is it possible to create a custom dashboard that can display the full processlist with a quick refresh?

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [September 24, 2020, 3:51am UTC](https://forums.percona.com/t/pmm2-realtime-full-processlist-dashboard/8073/2 "2020-09-24T03:51:29Z")

</div>

Hi,

mysqld\_exporter collects only cumulative data from information\_schema.processlist table.

e.g.

 ![Screenshot_20200924_122006.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/2ccb4def9276225988953355b11c037f4fcd73bf.png)

---

<div class="post-metadata">

**Author:** ![tcrowley](https://avatars.discourse-cdn.com/v4/letter/t/b5e925/32.png) [@tcrowley](https://forums.percona.com/u/tcrowley)\
**Post date:** [September 24, 2020, 11:01am UTC](https://forums.percona.com/t/pmm2-realtime-full-processlist-dashboard/8073/3 "2020-09-24T11:01:49Z")

</div>

Thanks, that makes sense. Is there a way to replicate the Threads functionality with a custom query?

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [September 25, 2020, 3:54am UTC](https://forums.percona.com/t/pmm2-realtime-full-processlist-dashboard/8073/4 "2020-09-25T03:54:43Z")

</div>

[cq-processes.yml.txt](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/7be403ead1ecdfcecd7cbdf3c78f412bf9556cce.txt)

Here is an example of such query.

The file has to be renamed to cq-processes.yml and placed into the folder /usr/local/percona/pmm2/collectors/custom-queries/mysql/high-resolution

Also it’s required to restart pmm-agent

 ![Screenshot_20200925_122409.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/7d7d405a97f0224af8799b02fb8814237acb57eb.png)

---

<div class="post-metadata">

**Author:** ![Asuwini\_P](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/asuwini_p/32/9824_2.png) [@Asuwini\_P](https://forums.percona.com/u/Asuwini_P)\
**Post date:** [May 6, 2024, 5:40pm UTC](https://forums.percona.com/t/pmm2-realtime-full-processlist-dashboard/8073/5 "2024-05-06T17:40:17Z")

</div>

@Vadim_Yalovets

I need to replicate the **show full processlist** output in PMM custom dashboard? Is that possible, or I should face any issue in db production server?