{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/4481","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/4481/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/4481/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/4481/events","html_url":"https://github.com/CartoDB/cartodb/pull/4481","id":95264167,"number":4481,"title":"Changed count query for PG stats","user":{"login":"ethervoid","id":741240,"avatar_url":"https://avatars.githubusercontent.com/u/741240?v=3","gravatar_id":"","url":"https://api.github.com/users/ethervoid","html_url":"https://github.com/ethervoid","followers_url":"https://api.github.com/users/ethervoid/followers","following_url":"https://api.github.com/users/ethervoid/following{/other_user}","gists_url":"https://api.github.com/users/ethervoid/gists{/gist_id}","starred_url":"https://api.github.com/users/ethervoid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ethervoid/subscriptions","organizations_url":"https://api.github.com/users/ethervoid/orgs","repos_url":"https://api.github.com/users/ethervoid/repos","events_url":"https://api.github.com/users/ethervoid/events{/privacy}","received_events_url":"https://api.github.com/users/ethervoid/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"ethervoid","id":741240,"avatar_url":"https://avatars.githubusercontent.com/u/741240?v=3","gravatar_id":"","url":"https://api.github.com/users/ethervoid","html_url":"https://github.com/ethervoid","followers_url":"https://api.github.com/users/ethervoid/followers","following_url":"https://api.github.com/users/ethervoid/following{/other_user}","gists_url":"https://api.github.com/users/ethervoid/gists{/gist_id}","starred_url":"https://api.github.com/users/ethervoid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ethervoid/subscriptions","organizations_url":"https://api.github.com/users/ethervoid/orgs","repos_url":"https://api.github.com/users/ethervoid/repos","events_url":"https://api.github.com/users/ethervoid/events{/privacy}","received_events_url":"https://api.github.com/users/ethervoid/received_events","type":"User","site_admin":false},"milestone":null,"comments":4,"created_at":"2015-07-15T18:49:54Z","updated_at":"2015-07-16T09:10:56Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/CartoDB/cartodb/pulls/4481","html_url":"https://github.com/CartoDB/cartodb/pull/4481","diff_url":"https://github.com/CartoDB/cartodb/pull/4481.diff","patch_url":"https://github.com/CartoDB/cartodb/pull/4481.patch"},"body":"This should be considered a fix. I've put a count(*) that is a very expensive. With this PR it's changed to use the PG statistics.\r\n\r\n**This PR fixes issue #4478**"},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/121891106","html_url":"https://github.com/CartoDB/cartodb/pull/4481#issuecomment-121891106","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/4481","id":121891106,"user":{"login":"Cartofante","id":5066482,"avatar_url":"https://avatars.githubusercontent.com/u/5066482?v=3","gravatar_id":"","url":"https://api.github.com/users/Cartofante","html_url":"https://github.com/Cartofante","followers_url":"https://api.github.com/users/Cartofante/followers","following_url":"https://api.github.com/users/Cartofante/following{/other_user}","gists_url":"https://api.github.com/users/Cartofante/gists{/gist_id}","starred_url":"https://api.github.com/users/Cartofante/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Cartofante/subscriptions","organizations_url":"https://api.github.com/users/Cartofante/orgs","repos_url":"https://api.github.com/users/Cartofante/repos","events_url":"https://api.github.com/users/Cartofante/events{/privacy}","received_events_url":"https://api.github.com/users/Cartofante/received_events","type":"User","site_admin":false},"created_at":"2015-07-16T09:10:56Z","updated_at":"2015-07-16T09:10:56Z","body":"Frontend tests were OK :+1: ([details](http://clinker.cartodb.net/jenkins/job/CartoDB-PR-testing/5029/))"}}