# Hiding example queries in qan

**URL:** <https://forums.percona.com/t/hiding-example-queries-in-qan/5379>\
**Category:** PMM 1.x\
**Created:** [January 27, 2017, 2:27pm UTC](https://forums.percona.com/t/hiding-example-queries-in-qan/5379 "2017-01-27T14:27:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tyler/32/1153_2.png) [@Tyler](https://forums.percona.com/u/Tyler)\
**Post date:** [January 27, 2017, 2:27pm UTC](https://forums.percona.com/t/hiding-example-queries-in-qan/5379/1 "2017-01-27T14:27:37Z")

</div>

I’m trying to figure out how to hide example queries in qan for all hosts. I unchecked the "Send real query examples" option in the management gui but qan is still showing them.

Ideally I’d like to do this on a client-by-client basis in the config.yml file…is this possible?

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 27, 2017, 2:35pm UTC](https://forums.percona.com/t/hiding-example-queries-in-qan/5379/2 "2017-01-27T14:35:50Z")

</div>

Hi Tyler,

as quick solution you can disable QAN for some hosts by the following command

```auto
pmm-admin remove mysql:queries

```

---

<div class="post-metadata">

**Author:** ![Tyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tyler/32/1153_2.png) [@Tyler](https://forums.percona.com/u/Tyler)\
**Post date:** [January 27, 2017, 4:12pm UTC](https://forums.percona.com/t/hiding-example-queries-in-qan/5379/3 "2017-01-27T16:12:41Z")

</div>

oh noes! I need QAN, just wanted to open it up to some developers who shouldn’t be able to see production data.

Maybe a feature request for next release.

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 28, 2017, 6:10am UTC](https://forums.percona.com/t/hiding-example-queries-in-qan/5379/4 "2017-01-28T06:10:30Z")

</div>

Hi Tyler,

I need to consult with QAN developers, I will answer on Monday.

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 30, 2017, 6:22am UTC](https://forums.percona.com/t/hiding-example-queries-in-qan/5379/5 "2017-01-30T06:22:28Z")

</div>

Hi,

I created ticket for this issue: [URL][Log in - Percona JIRA](https://jira.percona.com/browse/PMM-546%5B/URL%5D)

Anyway workaround exists:

1. you can disable “Send real query examples” for required instance
2. wait 1-2 minutes for reconfiguration.
3. run the following commands on docker server

```auto

docker exec -it pmm-server /usr/bin/mysqldump pmm query_examples > /tmp/backup-query_examples.sql
docker exec -it pmm-server /usr/bin/mysql -e '
DELETE
FROM pmm.query_examples
WHERE instance_id IN (
SELECT i.instance_id
FROM pmm.instances i
WHERE i.subsystem_id=3
AND i.name=" ___INSTANCE_NAME___"
)
;
'

```