{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/4994","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/4994/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/4994/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/4994/events","html_url":"https://github.com/influxdata/influxdb/issues/4994","id":120467780,"number":4994,"title":"[feature request] entry in SHOW STATS or SHOW DIAGNOSTICS for series cardinality","user":{"login":"beckettsean","id":6537329,"avatar_url":"https://avatars.githubusercontent.com/u/6537329?v=3","gravatar_id":"","url":"https://api.github.com/users/beckettsean","html_url":"https://github.com/beckettsean","followers_url":"https://api.github.com/users/beckettsean/followers","following_url":"https://api.github.com/users/beckettsean/following{/other_user}","gists_url":"https://api.github.com/users/beckettsean/gists{/gist_id}","starred_url":"https://api.github.com/users/beckettsean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beckettsean/subscriptions","organizations_url":"https://api.github.com/users/beckettsean/orgs","repos_url":"https://api.github.com/users/beckettsean/repos","events_url":"https://api.github.com/users/beckettsean/events{/privacy}","received_events_url":"https://api.github.com/users/beckettsean/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/support","name":"support","color":"0052cc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-12-04T19:17:53Z","updated_at":"2016-01-14T18:48:38Z","closed_at":null,"body":"Series cardinality has a significant effect on RAM usage, and second order effects on write performance. It's an important number to be able to know, and yet there is no reasonable way to get it from the database.\r\n\r\nGiven that the series cardinality = the number of series IDs in the in-RAM index, can we make it so that there's a single place to get this number?\r\n\r\n@otoolep is there something already in the output that we can use to calculate it? I tried `select sum(seriesCreate) from _internal..shard` but that returns a number that seems way too high. I think each series is created for each shard, more or less, and I don't see any way to calculate the unique number of series."},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/171736310","html_url":"https://github.com/influxdata/influxdb/issues/4994#issuecomment-171736310","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/4994","id":171736310,"user":{"login":"kfitzpatrick","id":24348,"avatar_url":"https://avatars.githubusercontent.com/u/24348?v=3","gravatar_id":"","url":"https://api.github.com/users/kfitzpatrick","html_url":"https://github.com/kfitzpatrick","followers_url":"https://api.github.com/users/kfitzpatrick/followers","following_url":"https://api.github.com/users/kfitzpatrick/following{/other_user}","gists_url":"https://api.github.com/users/kfitzpatrick/gists{/gist_id}","starred_url":"https://api.github.com/users/kfitzpatrick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kfitzpatrick/subscriptions","organizations_url":"https://api.github.com/users/kfitzpatrick/orgs","repos_url":"https://api.github.com/users/kfitzpatrick/repos","events_url":"https://api.github.com/users/kfitzpatrick/events{/privacy}","received_events_url":"https://api.github.com/users/kfitzpatrick/received_events","type":"User","site_admin":false},"created_at":"2016-01-14T18:48:38Z","updated_at":"2016-01-14T18:48:38Z","body":"+1 to this idea. We could really use it in managed hosting to spot problems earlier."}}