I have started having a similar issue in the last few weeks with one specific query. Running against PostgreSQL DB .. locally runs in less than 1.1s... on retool this query fails. I tried to change the timeout but it still fails after 10s.
Hmm could you share a screenshot of the query?
Could you also share a screenshot of the query time breakdown like this (hover over the time to see the tooltip):
Do other queries to this resource work as expected?