Connection Settings

Query Timeout

Sometimes your query takes a very long time to run and consumes too much resource. With this setting, you can set up time out limit to abort any query that takes more than specificed number of milliseconds.

Just open the data source setting and enter the limit time in milliseconds:

Set timout

How It Works

  • When your query reach the number of milliseconds, an error will be raised, and depend on your database the message will be

    • In PostgreSQL: ERROR: canceling statement due to statement timeout
    • In RedShift: ERROR: Query cancelled on user's request
  • Currently, Holistics only supports this feature for PostgreSQL and RedShift.