{"action":"created","issue":{"url":"https://api.github.com/repos/zalando/PGObserver/issues/44","labels_url":"https://api.github.com/repos/zalando/PGObserver/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/zalando/PGObserver/issues/44/comments","events_url":"https://api.github.com/repos/zalando/PGObserver/issues/44/events","html_url":"https://github.com/zalando/PGObserver/pull/44","id":57725561,"number":44,"title":"Statement load graph and Top statements feature implemented","user":{"login":"psycho-ir","id":726875,"avatar_url":"https://avatars.githubusercontent.com/u/726875?v=3","gravatar_id":"","url":"https://api.github.com/users/psycho-ir","html_url":"https://github.com/psycho-ir","followers_url":"https://api.github.com/users/psycho-ir/followers","following_url":"https://api.github.com/users/psycho-ir/following{/other_user}","gists_url":"https://api.github.com/users/psycho-ir/gists{/gist_id}","starred_url":"https://api.github.com/users/psycho-ir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/psycho-ir/subscriptions","organizations_url":"https://api.github.com/users/psycho-ir/orgs","repos_url":"https://api.github.com/users/psycho-ir/repos","events_url":"https://api.github.com/users/psycho-ir/events{/privacy}","received_events_url":"https://api.github.com/users/psycho-ir/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-02-15T10:23:16Z","updated_at":"2015-02-18T15:19:54Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/zalando/PGObserver/pulls/44","html_url":"https://github.com/zalando/PGObserver/pull/44","diff_url":"https://github.com/zalando/PGObserver/pull/44.diff","patch_url":"https://github.com/zalando/PGObserver/pull/44.patch"},"body":"First of all pleaese update pgobserver.yaml file\r\nThen you need to update your schema, so if tables are already exist. just run sql/patch/00_STAT_STATEMENTS_DATA.sql\r\n\r\nNote: I made some changes in StatStatementsGatherer to gather statement calls incrementally, so we are able to filter them in different time windows. Also i have added ssd_user_id to stat_statements_data. so it is possible to filter queries by user_id.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/zalando/PGObserver/issues/comments/74881217","html_url":"https://github.com/zalando/PGObserver/pull/44#issuecomment-74881217","issue_url":"https://api.github.com/repos/zalando/PGObserver/issues/44","id":74881217,"user":{"login":"psycho-ir","id":726875,"avatar_url":"https://avatars.githubusercontent.com/u/726875?v=3","gravatar_id":"","url":"https://api.github.com/users/psycho-ir","html_url":"https://github.com/psycho-ir","followers_url":"https://api.github.com/users/psycho-ir/followers","following_url":"https://api.github.com/users/psycho-ir/following{/other_user}","gists_url":"https://api.github.com/users/psycho-ir/gists{/gist_id}","starred_url":"https://api.github.com/users/psycho-ir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/psycho-ir/subscriptions","organizations_url":"https://api.github.com/users/psycho-ir/orgs","repos_url":"https://api.github.com/users/psycho-ir/repos","events_url":"https://api.github.com/users/psycho-ir/events{/privacy}","received_events_url":"https://api.github.com/users/psycho-ir/received_events","type":"User","site_admin":false},"created_at":"2015-02-18T15:19:54Z","updated_at":"2015-02-18T15:19:54Z","body":"\"\"\"\r\n\r\nAfter commenting out the \"if not tplE._settings['run_aggregations']:\" I got:\r\n\r\nFile \"/ssd/code/temp/pgo-psycho-ir/frontend/src/topstats.py\", line 115, in getStatLoad\r\ncur.execute(sql)\r\nFile \"/usr/local/lib/python2.7/dist-packages/psycopg2/extras.py\", line 120, in execute\r\nreturn super(DictCursor, self).execute(query, vars)\r\nDataError: numeric field overflow\r\nDETAIL: A field with precision 6, scale 2 must round to an absolute value less than 10^4\r\n\"\"\"\r\n\r\nI could not reproduce this error.\r\nCould you please let me know how it happens, or give me a unit test that fails with your conditions."}}