# Pmm2 Query Analytics do not show all sql in mysql 5.7 **URL:** \ **Category:** PMM 2.x\ **Created:** [January 8, 2021, 9:43am UTC](https://forums.percona.com/t/pmm2-query-analytics-do-not-show-all-sql-in-mysql-5-7/8686 "2021-01-08T09:43:53Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![tmhouton](https://avatars.discourse-cdn.com/v4/letter/t/9f8e36/32.png) [@tmhouton](https://forums.percona.com/u/tmhouton)\ **Post date:** [January 8, 2021, 9:43am UTC](https://forums.percona.com/t/pmm2-query-analytics-do-not-show-all-sql-in-mysql-5-7/8686/1 "2021-01-08T09:43:53Z")
Hi Guys, I run the pmm2 with 2.3.0. When I use query Analytics, I can not found all sql from the output. Especially long running sql (over 10 mins). Any idea about this ? consumers table output like this. ```auto mysql > SELECT * FROM performance_schema.setup_consumers; +--------------------------------+---------+ | NAME | ENABLED | +--------------------------------+---------+ | events_stages_current | NO | | events_stages_history | NO | | events_stages_history_long | NO | | events_statements_current | YES | | events_statements_history | YES | | events_statements_history_long | NO | | events_waits_current | NO | | events_waits_history | NO | | events_waits_history_long | NO | | global_instrumentation | YES | | thread_instrumentation | YES | | statements_digest | YES | +--------------------------------+---------+ 12 rows in set (0.00 sec) ``` Thanks a lot~ ---
**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:** [January 8, 2021, 10:15am UTC](https://forums.percona.com/t/pmm2-query-analytics-do-not-show-all-sql-in-mysql-5-7/8686/2 "2021-01-08T10:15:47Z")
Hi James, As I can see the `statements_digest` consumer is enabled. Could you check if the mentioned long running sql is present in the table events\_statements\_summary\_by\_digest? ---
**Author:** ![tmhouton](https://avatars.discourse-cdn.com/v4/letter/t/9f8e36/32.png) [@tmhouton](https://forums.percona.com/u/tmhouton)\ **Post date:** [January 8, 2021, 12:59pm UTC](https://forums.percona.com/t/pmm2-query-analytics-do-not-show-all-sql-in-mysql-5-7/8686/3 "2021-01-08T12:59:41Z")
> [@Vadim\_Yalovets](#): > > events\_statements\_summary\_by\_digest Hi Adivinho, I can not find the sql in this table. Any idea about this? Regards, James ---
**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:** [January 8, 2021, 2:55pm UTC](https://forums.percona.com/t/pmm2-query-analytics-do-not-show-all-sql-in-mysql-5-7/8686/4 "2021-01-08T14:55:25Z")
Maybe this sql is shown in the table performance\_schema.prepared\_statements\_instances 🤔