Custom queries for postgres are being collected in high resolution

User Impact:

Custom queries are not working in expected resolutions and this causes High CPU usage.

 

How to test:
Add custom query to custom queries low resolution folder

Restart postgres_exporter or pmm-agent.

Check CPU usage, it should look more like waves.

Steps to Reproduce:

• Add instance with ~1000 tables.
• Add custom query to custom queries low resolution folder.
• Restart postgres_exporter or pmm-agent.
• Check CPU usage of postgres_exporter.

Actual Result:

High CPU usage for the whole time.

Expected Result:
Periodical high CPU usage.