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.
High CPU usage for the whole time.
Periodical high CPU usage.