# PMM2 - Query Analytics - Long Queries cut off with "...". EXPLAIN Not working as a result

**URL:** <https://forums.percona.com/t/pmm2-query-analytics-long-queries-cut-off-with-explain-not-working-as-a-result/8326>\
**Category:** PMM 2.x\
**Tags:** pmm\
**Created:** [November 30, 2020, 7:45am UTC](https://forums.percona.com/t/pmm2-query-analytics-long-queries-cut-off-with-explain-not-working-as-a-result/8326 "2020-11-30T07:45:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![joshfifty](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joshfifty/32/224_2.png) [@joshfifty](https://forums.percona.com/u/joshfifty)\
**Post date:** [November 30, 2020, 7:45am UTC](https://forums.percona.com/t/pmm2-query-analytics-long-queries-cut-off-with-explain-not-working-as-a-result/8326/1 "2020-11-30T07:45:56Z")

</div>

Hi Guys,

First off thanks for this great tool.

In our project we have some rather long SQL queries that aren’t properly displayed in the Query Analytics Tab.

They are cut off at some point with … which causes the EXPLAIN tab to not work as well.

How can i fix this?

Cheers

---

<div class="post-metadata">

**Author:** ![palash](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/palash/32/1344_2.png) [@palash](https://forums.percona.com/u/palash)\
**Post date:** [December 1, 2020, 1:59am UTC](https://forums.percona.com/t/pmm2-query-analytics-long-queries-cut-off-with-explain-not-working-as-a-result/8326/2 "2020-12-01T01:59:01Z")

</div>

Hi @joshfiftyglad you liked PMM

does your db instance have event\_statements\_current and event\_statements\_history enabled, because in MySQL 5.6 these are disabled by default.

If you enable it using this it should solve the problem

```auto
UPDATE performance_schema.setup_consumers
SET ENABLED = 'YES'
WHERE NAME LIKE 'events_statements_history';

```

we have this marked as a documentation bug [https://jira.percona.com/browse/PMM-6733](https://jira.percona.com/browse/PMM-6733) in case you want more details or want to keep a track of it.

---

<div class="post-metadata">

**Author:** ![joshfifty](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joshfifty/32/224_2.png) [@joshfifty](https://forums.percona.com/u/joshfifty)\
**Post date:** [December 1, 2020, 2:05am UTC](https://forums.percona.com/t/pmm2-query-analytics-long-queries-cut-off-with-explain-not-working-as-a-result/8326/3 "2020-12-01T02:05:32Z")

</div>

thanks a lot for this. I’m on percona cluster 8.0

---

<div class="post-metadata">

**Author:** ![joshfifty](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joshfifty/32/224_2.png) [@joshfifty](https://forums.percona.com/u/joshfifty)\
**Post date:** [December 1, 2020, 2:35am UTC](https://forums.percona.com/t/pmm2-query-analytics-long-queries-cut-off-with-explain-not-working-as-a-result/8326/4 "2020-12-01T02:35:00Z")

</div>

Very good this worked. Maybe this should be added to the PMM2 Mysql Service documentation?

[Percona Monitoring and Management](https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/client/mysql.html)