Query Timeout
Sometimes your query takes too much time and resource. With this setting, you can set up a timeout limit to abort any query that runs for more than a specified number of milliseconds.
Open the data source setting and enter the limit time in milliseconds:
How It Works
When your query reaches the timeout limit, an error will be raised:
- In PostgreSQL:
ERROR: canceling statement due to statement timeout
- In RedShift:
ERROR: Query canceled on user's request
- In MySQL:
ERROR: Query execution was interrupted, maximum statement execution time exceeded
- In Microsoft SQL Server:
Adaptive Server connection timed out
Notes:
- Other timeout settings on your database server and database user may also raise the above errors. Thus, if you are debugging these errors, make sure to check the settings on both Holistics and on your database.
Currently, this feature is only available for
- PostgreSQL
- RedShift
- MySQL 5.7.8 and above
- Microsoft SQL Server