{"action":"created","issue":{"url":"https://api.github.com/repos/timescale/timescaledb/issues/503","repository_url":"https://api.github.com/repos/timescale/timescaledb","labels_url":"https://api.github.com/repos/timescale/timescaledb/issues/503/labels{/name}","comments_url":"https://api.github.com/repos/timescale/timescaledb/issues/503/comments","events_url":"https://api.github.com/repos/timescale/timescaledb/issues/503/events","html_url":"https://github.com/timescale/timescaledb/issues/503","id":315458887,"number":503,"title":"Querying partition on a hypertable","user":{"login":"arriqaaq","id":5154136,"avatar_url":"https://avatars0.githubusercontent.com/u/5154136?v=4","gravatar_id":"","url":"https://api.github.com/users/arriqaaq","html_url":"https://github.com/arriqaaq","followers_url":"https://api.github.com/users/arriqaaq/followers","following_url":"https://api.github.com/users/arriqaaq/following{/other_user}","gists_url":"https://api.github.com/users/arriqaaq/gists{/gist_id}","starred_url":"https://api.github.com/users/arriqaaq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arriqaaq/subscriptions","organizations_url":"https://api.github.com/users/arriqaaq/orgs","repos_url":"https://api.github.com/users/arriqaaq/repos","events_url":"https://api.github.com/users/arriqaaq/events{/privacy}","received_events_url":"https://api.github.com/users/arriqaaq/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-18T12:30:20Z","updated_at":"2018-04-19T12:42:55Z","closed_at":null,"author_association":"NONE","body":"I have created a simple table in postgres, and have added a timestamptz field, my configuration being 2CPU with 8GB  RAM, and have inserted nearly 400 million records into the table. I have given a chunk size of 1 hour, which I assume acts like a partition. Could I know how to query for a particular hour partition and not scan through all the rows?\r\n\r\nAlso documentation on the setup would help for new postgres users. All my queries which have group by clauses are taking more than 10 mins, and I hardly see the CPU being utilized. Could you guys suggest what I am doing wrong?\r\n\r\nP.S I am planning to use Timescaledb instead of druid with a load of 100 million records in a day"},"comment":{"url":"https://api.github.com/repos/timescale/timescaledb/issues/comments/382719599","html_url":"https://github.com/timescale/timescaledb/issues/503#issuecomment-382719599","issue_url":"https://api.github.com/repos/timescale/timescaledb/issues/503","id":382719599,"user":{"login":"arriqaaq","id":5154136,"avatar_url":"https://avatars0.githubusercontent.com/u/5154136?v=4","gravatar_id":"","url":"https://api.github.com/users/arriqaaq","html_url":"https://github.com/arriqaaq","followers_url":"https://api.github.com/users/arriqaaq/followers","following_url":"https://api.github.com/users/arriqaaq/following{/other_user}","gists_url":"https://api.github.com/users/arriqaaq/gists{/gist_id}","starred_url":"https://api.github.com/users/arriqaaq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arriqaaq/subscriptions","organizations_url":"https://api.github.com/users/arriqaaq/orgs","repos_url":"https://api.github.com/users/arriqaaq/repos","events_url":"https://api.github.com/users/arriqaaq/events{/privacy}","received_events_url":"https://api.github.com/users/arriqaaq/received_events","type":"User","site_admin":false},"created_at":"2018-04-19T12:42:55Z","updated_at":"2018-04-19T12:42:55Z","author_association":"NONE","body":"Any ideas anyone? Near a billion records chunked day wise and still can't query data for a day, trying with a 52G RAM, 16 core CPU machine, with postgres tuned using pgtune. Guys need help understanding this\r\n\r\n@kev009 @cevian "}}
{"actor":{"display_login":"arriqaaq"}}