{"action":"created","issue":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/5197","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/5197/labels{/name}","comments_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/5197/comments","events_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/5197/events","html_url":"https://github.com/rethinkdb/rethinkdb/issues/5197","id":121714113,"number":5197,"title":"Impossible to stop/kill slow query","user":{"login":"let4be","id":4147061,"avatar_url":"https://avatars.githubusercontent.com/u/4147061?v=3","gravatar_id":"","url":"https://api.github.com/users/let4be","html_url":"https://github.com/let4be","followers_url":"https://api.github.com/users/let4be/followers","following_url":"https://api.github.com/users/let4be/following{/other_user}","gists_url":"https://api.github.com/users/let4be/gists{/gist_id}","starred_url":"https://api.github.com/users/let4be/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/let4be/subscriptions","organizations_url":"https://api.github.com/users/let4be/orgs","repos_url":"https://api.github.com/users/let4be/repos","events_url":"https://api.github.com/users/let4be/events{/privacy}","received_events_url":"https://api.github.com/users/let4be/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-11T14:08:15Z","updated_at":"2015-12-11T20:10:20Z","closed_at":null,"body":"Let's say I do\r\n\r\n`r.db(\"local\").table(\"domains\").filter({domain: \"odesk.com\"}).limit(1)`\r\n\r\nthough table has primary key on domain field it runs insanely slow\r\nI can't even kill this query it effectively locks up the whole db\r\nI tried to run the query from rethinkdb data explorer(8080) and from recli https://github.com/stiang/recli\r\n\r\nRethinkDB 2.2.1, data set contains ~140 mil records in domains table"},"comment":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/comments/164036868","html_url":"https://github.com/rethinkdb/rethinkdb/issues/5197#issuecomment-164036868","issue_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/5197","id":164036868,"user":{"login":"let4be","id":4147061,"avatar_url":"https://avatars.githubusercontent.com/u/4147061?v=3","gravatar_id":"","url":"https://api.github.com/users/let4be","html_url":"https://github.com/let4be","followers_url":"https://api.github.com/users/let4be/followers","following_url":"https://api.github.com/users/let4be/following{/other_user}","gists_url":"https://api.github.com/users/let4be/gists{/gist_id}","starred_url":"https://api.github.com/users/let4be/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/let4be/subscriptions","organizations_url":"https://api.github.com/users/let4be/orgs","repos_url":"https://api.github.com/users/let4be/repos","events_url":"https://api.github.com/users/let4be/events{/privacy}","received_events_url":"https://api.github.com/users/let4be/received_events","type":"User","site_admin":false},"created_at":"2015-12-11T20:10:20Z","updated_at":"2015-12-11T20:10:20Z","body":"The whole database becomes unresponsive and other queries execute a lot slower,\r\nAnd because of the data size(140 mil records) first query is literally taking hours, is there any way to forcefully stop such queries?"}}