# Identifying Blocked Queries from ClickHouse PMM Data

**URL:** <https://forums.percona.com/t/identifying-blocked-queries-from-clickhouse-pmm-data/35133>\
**Category:** PMM 2.x\
**Tags:** mysql, percona\
**Created:** [November 20, 2024, 6:12am UTC](https://forums.percona.com/t/identifying-blocked-queries-from-clickhouse-pmm-data/35133 "2024-11-20T06:12:59Z")\
**Posts on this page:** 2\
**Page:** 1

<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:** [November 20, 2024, 6:12am UTC](https://forums.percona.com/t/identifying-blocked-queries-from-clickhouse-pmm-data/35133/1 "2024-11-20T06:12:59Z")

</div>

Hi Team,

Using the ClickHouse PMM data, we can observe the lock wait time for each query. Is it possible to identify which queries were blocked during this time, either through ClickHouse data or PMM’s default graphs?

Thank you

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [November 20, 2024, 3:36pm UTC](https://forums.percona.com/t/identifying-blocked-queries-from-clickhouse-pmm-data/35133/2 "2024-11-20T15:36:42Z")

</div>

Hello @Asuwini_P,  
When a query is in lock\_wait state, that means it is waiting for locks to be released so it can execute. By your question, you have this info already because these are queries being blocked.

Next you will probably ask “how can I see which queries are blocking these?” and unfortunately PMM does not have that data available. You can query `SELECT * FROM sys.innodb_lock_waits` and observe during your testing which queries are blocking/being blocked.