# How to Query the QAN DB

**URL:** <https://forums.percona.com/t/how-to-query-the-qan-db/18225>\
**Category:** PMM 2.x\
**Created:** [October 28, 2022, 8:27am UTC](https://forums.percona.com/t/how-to-query-the-qan-db/18225 "2022-10-28T08:27:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![donovanvangraan](https://avatars.discourse-cdn.com/v4/letter/d/9de0a6/32.png) [@donovanvangraan](https://forums.percona.com/u/donovanvangraan)\
**Post date:** [October 28, 2022, 8:27am UTC](https://forums.percona.com/t/how-to-query-the-qan-db/18225/1 "2022-10-28T08:27:45Z")

</div>

Good Morning all,

This question might be answered before so I’m sorry if it has been duplicated.

I’d like to know where the QAN data is stored and how to access it directly, and if this is indeed possible.

I’d like to export the data and use it in event correlation on other monitoring services we currently have in place.

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)\
**Post date:** [October 31, 2022, 8:40am UTC](https://forums.percona.com/t/how-to-query-the-qan-db/18225/2 "2022-10-31T08:40:08Z")

</div>

Hey @donovanvangraan,

analytics data is stored in ClickHouse.  
It is already added as a data source in PMM.  
You can explore this data through “Explore” feature in PMM.

You can configure Clickhouse in `/etc/clickhouse-server/config.xml`. Clickhouse itself supports various topologies, where you can replicate the data to external Clickhouse instance.

Please let me know if it helps.

---

<div class="post-metadata">

**Author:** ![donovanvangraan](https://avatars.discourse-cdn.com/v4/letter/d/9de0a6/32.png) [@donovanvangraan](https://forums.percona.com/u/donovanvangraan)\
**Post date:** [November 1, 2022, 1:27pm UTC](https://forums.percona.com/t/how-to-query-the-qan-db/18225/3 "2022-11-01T13:27:44Z")

</div>

@Sergey_Pronin

That worked like a charm! Thank you so much for the info. I have created a connection and we are able to extract the data we need.

Thank you so much for the help  
Donovan