# Unhide QAN queries instead of ? expecting actual query column values

**URL:** <https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926>\
**Category:** Percona Monitoring and Management (PMM)\
**Created:** [March 24, 2023, 2:08pm UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926 "2023-03-24T14:08:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [March 24, 2023, 2:08pm UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926/1 "2023-03-24T14:08:21Z")

</div>

Is there way that we can unhide the queries’ values running from application. we want to store the queries’ values in the QAN database instead of the question mark.

How can I unhide the queries column values?

EX: select \* from table\_test where col1=?; → select \* from table\_test where col1=100;

---

<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:** [March 24, 2023, 2:48pm UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926/2 "2023-03-24T14:48:01Z")

</div>

Hello @Naresh9999,  
Are you using prepared statements in your application? Are you using slowlog or perfschema as the source for queries in PMM?

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [March 24, 2023, 3:26pm UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926/3 "2023-03-24T15:26:36Z")

</div>

Hi @matthewb

Few app’s are using prepared statements and my query source is perfschema.

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [March 27, 2023, 6:26pm UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926/4 "2023-03-27T18:26:48Z")

</div>

Hi @matthewb

any update ?

---

<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:** [March 27, 2023, 6:58pm UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926/5 "2023-03-27T18:58:41Z")

</div>

If you’re using performance\_schema, then the data pulled will contain the digested version of the queries. This is MySQL’s behavior, not something PMM is doing.

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [March 27, 2023, 7:16pm UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926/6 "2023-03-27T19:16:56Z")

</div>

okay got it @matthewb

If in this case slow log file is more informative than perfschema right?  
Actually, we are using MariaDB 10.4 version.

---

<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:** [March 27, 2023, 8:39pm UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926/7 "2023-03-27T20:39:41Z")

</div>

Yes, slowlog will have the exact query, not the digest version.

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [March 28, 2023, 3:33am UTC](https://forums.percona.com/t/unhide-qan-queries-instead-of-expecting-actual-query-column-values/20926/8 "2023-03-28T03:33:46Z")

</div>

Thanks @matthewb for the help. We will try use slowlog as source and check on that.