Hi, I am troubleshooting slow data collection from an QuestDB 6.6.1 instance. The issue relates to relatively simple queries, but the time to collect data from can take 15s and sometimes they even timeout. The distribution of such events over the course of last 7days is in the attached image.
Interestingly, I looked at server performance when it happened last time, and I dont see any resource shortages (the server has 16cores). Do you have any suggestion where to look? I am also enclosing overview of disks related metrics from the time when was the highest incidence of timeouts on 6/3/2023.