How to Query the QAN DB

Percona Monitoring and Management (PMM) PMM 2.x
1

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.

1 Like
2

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.

1 Like
3

@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

1 Like