{"action":"created","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/1749","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/1749/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/1749/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/1749/events","html_url":"https://github.com/metabase/metabase/issues/1749","id":127545152,"number":1749,"title":"Make default query timeout of 60 seconds configurable","user":{"login":"hopsoft","id":32920,"avatar_url":"https://avatars.githubusercontent.com/u/32920?v=3","gravatar_id":"","url":"https://api.github.com/users/hopsoft","html_url":"https://github.com/hopsoft","followers_url":"https://api.github.com/users/hopsoft/followers","following_url":"https://api.github.com/users/hopsoft/following{/other_user}","gists_url":"https://api.github.com/users/hopsoft/gists{/gist_id}","starred_url":"https://api.github.com/users/hopsoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hopsoft/subscriptions","organizations_url":"https://api.github.com/users/hopsoft/orgs","repos_url":"https://api.github.com/users/hopsoft/repos","events_url":"https://api.github.com/users/hopsoft/events{/privacy}","received_events_url":"https://api.github.com/users/hopsoft/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/metabase/metabase/labels/Feature/Scoped","name":"Feature/Scoped","color":"bfd4f2"},{"url":"https://api.github.com/repos/metabase/metabase/labels/Priority/P1","name":"Priority/P1","color":"e11d21"},{"url":"https://api.github.com/repos/metabase/metabase/labels/Query%20Builder","name":"Query Builder","color":"0DD5FC"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/metabase/metabase/milestones/18","html_url":"https://github.com/metabase/metabase/milestones/0.18.0","labels_url":"https://api.github.com/repos/metabase/metabase/milestones/18/labels","id":1736953,"number":18,"title":"0.18.0","description":"Code Complete: May TBD","creator":{"login":"salsakran","id":107439,"avatar_url":"https://avatars.githubusercontent.com/u/107439?v=3","gravatar_id":"","url":"https://api.github.com/users/salsakran","html_url":"https://github.com/salsakran","followers_url":"https://api.github.com/users/salsakran/followers","following_url":"https://api.github.com/users/salsakran/following{/other_user}","gists_url":"https://api.github.com/users/salsakran/gists{/gist_id}","starred_url":"https://api.github.com/users/salsakran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/salsakran/subscriptions","organizations_url":"https://api.github.com/users/salsakran/orgs","repos_url":"https://api.github.com/users/salsakran/repos","events_url":"https://api.github.com/users/salsakran/events{/privacy}","received_events_url":"https://api.github.com/users/salsakran/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":0,"state":"open","created_at":"2016-04-28T17:19:48Z","updated_at":"2016-04-28T20:47:52Z","due_on":null,"closed_at":null},"comments":15,"created_at":"2016-01-19T21:40:46Z","updated_at":"2016-04-29T00:56:43Z","closed_at":null,"body":"I'm using Metabase to query a read replica of our production db, but some queries take longer than 60 seconds. The default hard coded 60 second timeout kills these queries. It would be useful to configure this timeout value to suit our needs... ideally with an environment variable (AWS Environment Property). \r\n\r\nI'm certain there are other scenarios where reducing/increasing the timeout might prove helpful.\r\n\r\nSee also issue: #576"},"comment":{"url":"https://api.github.com/repos/metabase/metabase/issues/comments/215604361","html_url":"https://github.com/metabase/metabase/issues/1749#issuecomment-215604361","issue_url":"https://api.github.com/repos/metabase/metabase/issues/1749","id":215604361,"user":{"login":"derekchan","id":1776133,"avatar_url":"https://avatars.githubusercontent.com/u/1776133?v=3","gravatar_id":"","url":"https://api.github.com/users/derekchan","html_url":"https://github.com/derekchan","followers_url":"https://api.github.com/users/derekchan/followers","following_url":"https://api.github.com/users/derekchan/following{/other_user}","gists_url":"https://api.github.com/users/derekchan/gists{/gist_id}","starred_url":"https://api.github.com/users/derekchan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/derekchan/subscriptions","organizations_url":"https://api.github.com/users/derekchan/orgs","repos_url":"https://api.github.com/users/derekchan/repos","events_url":"https://api.github.com/users/derekchan/events{/privacy}","received_events_url":"https://api.github.com/users/derekchan/received_events","type":"User","site_admin":false},"created_at":"2016-04-29T00:56:43Z","updated_at":"2016-04-29T00:56:43Z","body":"+1 on this request.\r\n\r\nWe are using a Redshift backend too. We run adhoc queries which may join several tables for exploratory analysis. These queries can complete within 5 min usually. Another case is when we have occasional big queries aggregating rows from across a rather long time. \r\n\r\nIn both cases it is okay to be slow (to up 15 minutes I would say), as long as the query eventually complete."}}