# Query in "\_pmm-query-analytics" does not show full text

**URL:** <https://forums.percona.com/t/query-in-pmm-query-analytics-does-not-show-full-text/7501>\
**Category:** PMM 2.x\
**Created:** [April 2, 2020, 8:44am UTC](https://forums.percona.com/t/query-in-pmm-query-analytics-does-not-show-full-text/7501 "2020-04-02T08:44:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gilg](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gilg/32/1301_2.png) [@gilg](https://forums.percona.com/u/gilg)\
**Post date:** [April 2, 2020, 8:44am UTC](https://forums.percona.com/t/query-in-pmm-query-analytics-does-not-show-full-text/7501/1 "2020-04-02T08:44:08Z")

</div>

Hi,&nbsp; I have a query I see in the top queries in the dashboard&nbsp;\_pmm-query-analytics, I can only see part of the query, looks like its cut after around 1000 characters. How can I view full query? Is there some setting I need to change?

---

<div class="post-metadata">

**Author:** ![andrii.skomorokov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/andrii.skomorokov/32/1236_2.png) [@andrii.skomorokov](https://forums.percona.com/u/andrii.skomorokov)\
**Post date:** [April 15, 2020, 1:19pm UTC](https://forums.percona.com/t/query-in-pmm-query-analytics-does-not-show-full-text/7501/2 "2020-04-15T13:19:27Z")

</div>

Thanks for your question!&nbsp;  
I assume you are using MySQL.  
  
If you are using a slow log as a query source, the limit is 2_1024_10 = 20,480 - do not slow down the performance of parsing.  
  
And for query source &nbsp;- perf schema - the limit is defined by MySQL variable [sysvar\_performance\_schema\_max\_sql\_text\_length](https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html#sysvar_performance_schema_max_sql_text_length "Link: https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html#sysvar\_performance\_schema\_max\_sql\_text\_length") by default, it is 1024.&nbsp;So you can try to increase sysvar\_performance\_schema\_max\_sql\_text\_length to see full query.