Administrators can configure the global query timeout (queryTimeout parameter) to stop SQL queries from running longer than the limit. It prevents queries that take too long to impact other users.
The Limit query time is configured as below.
The administrator sets the default value on the SQL for Confluence configuration page. To set the 'Maximum number of seconds for query to run' in Global Configuration, refer to Global Configuration.
An administrator can override the global queryTimeout setting for specific data source profiles in Global Configuration. The global setting takes effect if this is not overridden. For more information, refer to Data Source Profiles - Limit query time.
Users can change the default queryTimeout parameter value for the SQL and SQL-Query macros. Selecting a value from the list for Maximum number of seconds for query to run overrides the default.
...