{"action":"created","issue":{"url":"https://api.github.com/repos/dgraph-io/dgraph/issues/2111","repository_url":"https://api.github.com/repos/dgraph-io/dgraph","labels_url":"https://api.github.com/repos/dgraph-io/dgraph/issues/2111/labels{/name}","comments_url":"https://api.github.com/repos/dgraph-io/dgraph/issues/2111/comments","events_url":"https://api.github.com/repos/dgraph-io/dgraph/issues/2111/events","html_url":"https://github.com/dgraph-io/dgraph/issues/2111","id":296211495,"number":2111,"title":"High CPU Load and Slow Query When Do Filtering","user":{"login":"essapermana","id":23373803,"avatar_url":"https://avatars0.githubusercontent.com/u/23373803?v=4","gravatar_id":"","url":"https://api.github.com/users/essapermana","html_url":"https://github.com/essapermana","followers_url":"https://api.github.com/users/essapermana/followers","following_url":"https://api.github.com/users/essapermana/following{/other_user}","gists_url":"https://api.github.com/users/essapermana/gists{/gist_id}","starred_url":"https://api.github.com/users/essapermana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/essapermana/subscriptions","organizations_url":"https://api.github.com/users/essapermana/orgs","repos_url":"https://api.github.com/users/essapermana/repos","events_url":"https://api.github.com/users/essapermana/events{/privacy}","received_events_url":"https://api.github.com/users/essapermana/received_events","type":"User","site_admin":false},"labels":[{"id":633145183,"url":"https://api.github.com/repos/dgraph-io/dgraph/labels/investigate","name":"investigate","color":"e99695","default":false}],"state":"open","locked":false,"assignee":{"login":"pawanrawal","id":7247941,"avatar_url":"https://avatars1.githubusercontent.com/u/7247941?v=4","gravatar_id":"","url":"https://api.github.com/users/pawanrawal","html_url":"https://github.com/pawanrawal","followers_url":"https://api.github.com/users/pawanrawal/followers","following_url":"https://api.github.com/users/pawanrawal/following{/other_user}","gists_url":"https://api.github.com/users/pawanrawal/gists{/gist_id}","starred_url":"https://api.github.com/users/pawanrawal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pawanrawal/subscriptions","organizations_url":"https://api.github.com/users/pawanrawal/orgs","repos_url":"https://api.github.com/users/pawanrawal/repos","events_url":"https://api.github.com/users/pawanrawal/events{/privacy}","received_events_url":"https://api.github.com/users/pawanrawal/received_events","type":"User","site_admin":false},"assignees":[{"login":"pawanrawal","id":7247941,"avatar_url":"https://avatars1.githubusercontent.com/u/7247941?v=4","gravatar_id":"","url":"https://api.github.com/users/pawanrawal","html_url":"https://github.com/pawanrawal","followers_url":"https://api.github.com/users/pawanrawal/followers","following_url":"https://api.github.com/users/pawanrawal/following{/other_user}","gists_url":"https://api.github.com/users/pawanrawal/gists{/gist_id}","starred_url":"https://api.github.com/users/pawanrawal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pawanrawal/subscriptions","organizations_url":"https://api.github.com/users/pawanrawal/orgs","repos_url":"https://api.github.com/users/pawanrawal/repos","events_url":"https://api.github.com/users/pawanrawal/events{/privacy}","received_events_url":"https://api.github.com/users/pawanrawal/received_events","type":"User","site_admin":false}],"milestone":null,"comments":6,"created_at":"2018-02-11T18:13:47Z","updated_at":"2018-02-28T05:17:43Z","closed_at":null,"author_association":"NONE","body":"- What version of Dgraph are you using?\r\n`1.0.3`\r\n\r\n- Have you tried reproducing the issue with latest release?\r\n`Yes`\r\n\r\n- What is the hardware spec (RAM, OS)?\r\n`Ubuntu 16.04 with 8 Core CPU and 16 GB RAM`\r\n\r\n- Steps to reproduce the issue (command/config used to run Dgraph).\r\n`Dgraph running on single node (zero and server on same machine), with data for about 66 million and then running the following query`\r\n\r\n```\r\n{\r\n    var(func:eq(iduser,%d)) {\r\n        favorite @filter(NOT eq(deleted,true)){\r\n            A AS doing\r\n        }\r\n    }\r\n    result(func:uid(A), orderdesc:create_time, first:%d) @filter(lt(create_time, %s)) {\r\n        idactivity\r\n        create_time\r\n    }\r\n}\r\n```\r\n`iduser` and `create_time` is integer and indexed using `hash`\r\n\r\n- The result.\r\n`CPU went high and then the result shown after for about 8s, the behaviour occurred every we do the query, even with the same one. But if we remove this filter : @filter(lt(create_time, %s)) , this issue not happened`\r\n\r\nAttached is CPU profile when the query is running\r\n\r\n[pprof.dgraph.samples.cpu.001.pb.gz](https://github.com/dgraph-io/dgraph/files/1714667/pprof.dgraph.samples.cpu.001.pb.gz)\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/dgraph-io/dgraph/issues/comments/369124583","html_url":"https://github.com/dgraph-io/dgraph/issues/2111#issuecomment-369124583","issue_url":"https://api.github.com/repos/dgraph-io/dgraph/issues/2111","id":369124583,"user":{"login":"pawanrawal","id":7247941,"avatar_url":"https://avatars1.githubusercontent.com/u/7247941?v=4","gravatar_id":"","url":"https://api.github.com/users/pawanrawal","html_url":"https://github.com/pawanrawal","followers_url":"https://api.github.com/users/pawanrawal/followers","following_url":"https://api.github.com/users/pawanrawal/following{/other_user}","gists_url":"https://api.github.com/users/pawanrawal/gists{/gist_id}","starred_url":"https://api.github.com/users/pawanrawal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pawanrawal/subscriptions","organizations_url":"https://api.github.com/users/pawanrawal/orgs","repos_url":"https://api.github.com/users/pawanrawal/repos","events_url":"https://api.github.com/users/pawanrawal/events{/privacy}","received_events_url":"https://api.github.com/users/pawanrawal/received_events","type":"User","site_admin":false},"created_at":"2018-02-28T05:17:42Z","updated_at":"2018-02-28T05:17:42Z","author_association":"MEMBER","body":"@essapermana Did you try the experiment and did it help? If so, can we close this issue?"}}
{"actor":{"display_login":"pawanrawal"}}