Query on PMM-QAN

Hi @igroene ,

Hope you are doing good.

I have a query regarding PMM-QAN for MongoDB.
How can we correlate the data collected by QAN with the data captured under system.profile collection?

Say for example, I want to capture a long running query from PMM and kill it, how can I search for that query in system.profile collection? I don’t see operation ID being captured by PMM-QAN under explain section.

Request you to help me out.

Kiran Gelli

1 Like

Hello Kiran, I am not sure that can be done. Did you check on the “Examples” tab of PMM query analytics? there is some additional info that might be useful.

1 Like

Thanks for your response @igroene

However, I’m unable to view any operation ID being captured under QAN examples section.

Also, what is the min server configuration required for PMM server to monitor around 40 MongoDB Instances?

Our PMM server has 4 cores CPU/32 GB RAM

The reason for this ask - I see failed to establish 2 way communication errors on the PMM-agent service logs and I had to restart the agent to fix.