{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/4309","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/4309/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/4309/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/4309/events","html_url":"https://github.com/influxdb/influxdb/issues/4309","id":109594841,"number":4309,"title":"[0.9.4.1] query leading to crash","user":{"login":"abolinhas","id":3245485,"avatar_url":"https://avatars.githubusercontent.com/u/3245485?v=3","gravatar_id":"","url":"https://api.github.com/users/abolinhas","html_url":"https://github.com/abolinhas","followers_url":"https://api.github.com/users/abolinhas/followers","following_url":"https://api.github.com/users/abolinhas/following{/other_user}","gists_url":"https://api.github.com/users/abolinhas/gists{/gist_id}","starred_url":"https://api.github.com/users/abolinhas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abolinhas/subscriptions","organizations_url":"https://api.github.com/users/abolinhas/orgs","repos_url":"https://api.github.com/users/abolinhas/repos","events_url":"https://api.github.com/users/abolinhas/events{/privacy}","received_events_url":"https://api.github.com/users/abolinhas/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":24,"created_at":"2015-10-03T00:58:11Z","updated_at":"2015-10-10T01:02:22Z","closed_at":"2015-10-09T19:39:49Z","body":"Hi,\r\nI'm collecting all my users internet activity into my Influx database,I have already stored thousands / millions of points. Now I want query through Web Admin Interface all users activity on specific month, I use this query\r\nSELECT USER,SIZE FROM access_log WHERE (time >'2015-08-01 00:00:00' and time < '2015-08-31 23:59:00') but when I execute the query the Influx crash and the server load increases a lot.\r\nMy question is, this query is correct? Is there any way to optimize the query in order to reduce the load but returning the same data?\r\n\r\nI use influx 0.9.4.1\r\nServer spec: 8 CPU, 8 GB Ram"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/147019152","html_url":"https://github.com/influxdb/influxdb/issues/4309#issuecomment-147019152","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/4309","id":147019152,"user":{"login":"beckettsean","id":6537329,"avatar_url":"https://avatars.githubusercontent.com/u/6537329?v=3","gravatar_id":"","url":"https://api.github.com/users/beckettsean","html_url":"https://github.com/beckettsean","followers_url":"https://api.github.com/users/beckettsean/followers","following_url":"https://api.github.com/users/beckettsean/following{/other_user}","gists_url":"https://api.github.com/users/beckettsean/gists{/gist_id}","starred_url":"https://api.github.com/users/beckettsean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beckettsean/subscriptions","organizations_url":"https://api.github.com/users/beckettsean/orgs","repos_url":"https://api.github.com/users/beckettsean/repos","events_url":"https://api.github.com/users/beckettsean/events{/privacy}","received_events_url":"https://api.github.com/users/beckettsean/received_events","type":"User","site_admin":false},"created_at":"2015-10-10T01:02:22Z","updated_at":"2015-10-10T01:02:22Z","body":"@abolinhas I gave that syntax in my previous comment:\r\n\r\n`SELECT SUM(SIZE) as SIZE FROM access_log WHERE (time >'2015-08-01 00:00:00' and time < '2015-08-31 23:59:00') GROUP BY time(1h), USER`"}}