{"action":"opened","issue":{"url":"https://api.github.com/repos/elastic/apm-server/issues/1371","repository_url":"https://api.github.com/repos/elastic/apm-server","labels_url":"https://api.github.com/repos/elastic/apm-server/issues/1371/labels{/name}","comments_url":"https://api.github.com/repos/elastic/apm-server/issues/1371/comments","events_url":"https://api.github.com/repos/elastic/apm-server/issues/1371/events","html_url":"https://github.com/elastic/apm-server/issues/1371","id":358499548,"node_id":"MDU6SXNzdWUzNTg0OTk1NDg=","number":1371,"title":"Investigate indexing `span.context.db.*`","user":{"login":"simitt","id":5555349,"node_id":"MDQ6VXNlcjU1NTUzNDk=","avatar_url":"https://avatars0.githubusercontent.com/u/5555349?v=4","gravatar_id":"","url":"https://api.github.com/users/simitt","html_url":"https://github.com/simitt","followers_url":"https://api.github.com/users/simitt/followers","following_url":"https://api.github.com/users/simitt/following{/other_user}","gists_url":"https://api.github.com/users/simitt/gists{/gist_id}","starred_url":"https://api.github.com/users/simitt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simitt/subscriptions","organizations_url":"https://api.github.com/users/simitt/orgs","repos_url":"https://api.github.com/users/simitt/repos","events_url":"https://api.github.com/users/simitt/events{/privacy}","received_events_url":"https://api.github.com/users/simitt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-09-10T07:27:34Z","updated_at":"2018-09-10T07:27:34Z","closed_at":null,"author_association":"COLLABORATOR","body":"Currently `span.context.db.*` properties are stored but not indexed in ES. This makes it impossible to query/aggregate on them, which might be helpful for multiple use cases (aggregate on them to figure out occurence of queries per type, problematic instances, etc.).\r\n\r\nSuggested solution:\r\n\r\nattribute | type | description | index type | limit (server) | limit (agent) | note\r\n-- | -- | -- | -- | -- | -- | --\r\ninstance | string | db instance name | keyword | 1024 | 1024 | -\r\nuser | string | username for accessing db | keyword | 1024 | 1024 |-  \r\ntype | string | database type | keyword | 1024 |  1024| -\r\nstatement | string | concrete query | text | none | ? | should be sanitized for grouping\r\n\r\n"}}
{"actor":{"display_login":"simitt"}}