{"action":"created","comment":{"url":"https://api.github.com/repos/influxdb/influxdb.com/pulls/comments/39594047","id":39594047,"diff_hunk":"@@ -0,0 +1,40 @@\n+---\n+title: InfluxDB 0.9.4 released with top function, order by time desc and more\n+author: Paul Dix\n+date: 2015-09-16\n+publishdate: 2015-09-16\n+---\n+\n+Today we're releasing InfluxDB v0.9.4. This release has a few big features and some bug fixes. Full details are in the [InfluxDB changelog](https://github.com/influxdb/influxdb/blob/master/CHANGELOG.md#v094-2015-09-14), but here are some of the highlights.\n+\n+The [top aggregate](https://github.com/influxdb/influxdb/issues/1821) has been brought into the 0.9 release line. This means that for a given period of time you can query for the top N values. This is useful for a ranked list, like seeing which counters were highest, or which hosts had the highest CPU, or which sensors had the highest readings.\n+\n+You can now [order by time descending](https://github.com/influxdb/influxdb/issues/2022). The most common use case for this is to pair it with a `LIMIT 1` in the query to find the most recent data point in a time series.\n+\n+You can now [backreference measurement names in continuous queries](https://github.com/influxdb/influxdb/issues/2555). By using this and the `GROUP BY *` shortcut in a query, you can now define continuous queries that aggregate all of your data into lower and longer retention policies.\n+\n+We've added two queries that will provide instrumentation information about InfluxDB. From now on you'll be able to run:\n+\n+```sql\n+-- basic stats information\n+show stats\n+\n+-- diagnostics information\n+show diagnostics\n+```\n+\n+We don't have statistics instrumentation for every part of the system yet, but we'll adding to it over time. Bt default, the server will write the stats information into a database called `_internal`. This data is only kept around for 7 days, but it'll be a first stop when we're helping people troubleshoot problems with InfluxDB.","path":"content/blog/2015/09/16/InfluxDB-0_9_4-released-with-top-order-by-time-desc-and-more.md","position":26,"original_position":26,"commit_id":"d780081f1ba8dbf7bc6c0b69f1b95ca6d6bab275","original_commit_id":"d780081f1ba8dbf7bc6c0b69f1b95ca6d6bab275","user":{"login":"otoolep","id":536312,"avatar_url":"https://avatars.githubusercontent.com/u/536312?v=3","gravatar_id":"","url":"https://api.github.com/users/otoolep","html_url":"https://github.com/otoolep","followers_url":"https://api.github.com/users/otoolep/followers","following_url":"https://api.github.com/users/otoolep/following{/other_user}","gists_url":"https://api.github.com/users/otoolep/gists{/gist_id}","starred_url":"https://api.github.com/users/otoolep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/otoolep/subscriptions","organizations_url":"https://api.github.com/users/otoolep/orgs","repos_url":"https://api.github.com/users/otoolep/repos","events_url":"https://api.github.com/users/otoolep/events{/privacy}","received_events_url":"https://api.github.com/users/otoolep/received_events","type":"User","site_admin":false},"body":"\"Bt default...\" -> \"By default...\"","created_at":"2015-09-16T05:00:14Z","updated_at":"2015-09-16T05:00:14Z","html_url":"https://github.com/influxdb/influxdb.com/pull/316#discussion_r39594047","pull_request_url":"https://api.github.com/repos/influxdb/influxdb.com/pulls/316","_links":{"self":{"href":"https://api.github.com/repos/influxdb/influxdb.com/pulls/comments/39594047"},"html":{"href":"https://github.com/influxdb/influxdb.com/pull/316#discussion_r39594047"},"pull_request":{"href":"https://api.github.com/repos/influxdb/influxdb.com/pulls/316"}}},"pull_request":{"url":"https://api.github.com/repos/influxdb/influxdb.com/pulls/316","id":45095121,"html_url":"https://github.com/influxdb/influxdb.com/pull/316","diff_url":"https://github.com/influxdb/influxdb.com/pull/316.diff","patch_url":"https://github.com/influxdb/influxdb.com/pull/316.patch","issue_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/316","number":316,"state":"closed","locked":false,"title":"Add post for 0.9.4 announcement","user":{"login":"pauldix","id":4331,"avatar_url":"https://avatars.githubusercontent.com/u/4331?v=3","gravatar_id":"","url":"https://api.github.com/users/pauldix","html_url":"https://github.com/pauldix","followers_url":"https://api.github.com/users/pauldix/followers","following_url":"https://api.github.com/users/pauldix/following{/other_user}","gists_url":"https://api.github.com/users/pauldix/gists{/gist_id}","starred_url":"https://api.github.com/users/pauldix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pauldix/subscriptions","organizations_url":"https://api.github.com/users/pauldix/orgs","repos_url":"https://api.github.com/users/pauldix/repos","events_url":"https://api.github.com/users/pauldix/events{/privacy}","received_events_url":"https://api.github.com/users/pauldix/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-09-15T20:02:08Z","updated_at":"2015-09-16T05:00:14Z","closed_at":"2015-09-16T04:44:08Z","merged_at":"2015-09-16T04:44:08Z","merge_commit_sha":"e8ea5c427d269e0419bd6ffb87a914daac2dba4e","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/influxdb/influxdb.com/pulls/316/commits","review_comments_url":"https://api.github.com/repos/influxdb/influxdb.com/pulls/316/comments","review_comment_url":"https://api.github.com/repos/influxdb/influxdb.com/pulls/comments{/number}","comments_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/316/comments","statuses_url":"https://api.github.com/repos/influxdb/influxdb.com/statuses/d780081f1ba8dbf7bc6c0b69f1b95ca6d6bab275","head":{"label":"influxdb:pd-add-0_9_4-post","ref":"pd-add-0_9_4-post","sha":"d780081f1ba8dbf7bc6c0b69f1b95ca6d6bab275","user":{"login":"influxdb","id":5713248,"avatar_url":"https://avatars.githubusercontent.com/u/5713248?v=3","gravatar_id":"","url":"https://api.github.com/users/influxdb","html_url":"https://github.com/influxdb","followers_url":"https://api.github.com/users/influxdb/followers","following_url":"https://api.github.com/users/influxdb/following{/other_user}","gists_url":"https://api.github.com/users/influxdb/gists{/gist_id}","starred_url":"https://api.github.com/users/influxdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/influxdb/subscriptions","organizations_url":"https://api.github.com/users/influxdb/orgs","repos_url":"https://api.github.com/users/influxdb/repos","events_url":"https://api.github.com/users/influxdb/events{/privacy}","received_events_url":"https://api.github.com/users/influxdb/received_events","type":"Organization","site_admin":false},"repo":{"id":35440649,"name":"influxdb.com","full_name":"influxdb/influxdb.com","owner":{"login":"influxdb","id":5713248,"avatar_url":"https://avatars.githubusercontent.com/u/5713248?v=3","gravatar_id":"","url":"https://api.github.com/users/influxdb","html_url":"https://github.com/influxdb","followers_url":"https://api.github.com/users/influxdb/followers","following_url":"https://api.github.com/users/influxdb/following{/other_user}","gists_url":"https://api.github.com/users/influxdb/gists{/gist_id}","starred_url":"https://api.github.com/users/influxdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/influxdb/subscriptions","organizations_url":"https://api.github.com/users/influxdb/orgs","repos_url":"https://api.github.com/users/influxdb/repos","events_url":"https://api.github.com/users/influxdb/events{/privacy}","received_events_url":"https://api.github.com/users/influxdb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/influxdb/influxdb.com","description":"The main InfluxDB site","fork":false,"url":"https://api.github.com/repos/influxdb/influxdb.com","forks_url":"https://api.github.com/repos/influxdb/influxdb.com/forks","keys_url":"https://api.github.com/repos/influxdb/influxdb.com/keys{/key_id}","collaborators_url":"https://api.github.com/repos/influxdb/influxdb.com/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/influxdb/influxdb.com/teams","hooks_url":"https://api.github.com/repos/influxdb/influxdb.com/hooks","issue_events_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/events{/number}","events_url":"https://api.github.com/repos/influxdb/influxdb.com/events","assignees_url":"https://api.github.com/repos/influxdb/influxdb.com/assignees{/user}","branches_url":"https://api.github.com/repos/influxdb/influxdb.com/branches{/branch}","tags_url":"https://api.github.com/repos/influxdb/influxdb.com/tags","blobs_url":"https://api.github.com/repos/influxdb/influxdb.com/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/influxdb/influxdb.com/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/influxdb/influxdb.com/git/refs{/sha}","trees_url":"https://api.github.com/repos/influxdb/influxdb.com/git/trees{/sha}","statuses_url":"https://api.github.com/repos/influxdb/influxdb.com/statuses/{sha}","languages_url":"https://api.github.com/repos/influxdb/influxdb.com/languages","stargazers_url":"https://api.github.com/repos/influxdb/influxdb.com/stargazers","contributors_url":"https://api.github.com/repos/influxdb/influxdb.com/contributors","subscribers_url":"https://api.github.com/repos/influxdb/influxdb.com/subscribers","subscription_url":"https://api.github.com/repos/influxdb/influxdb.com/subscription","commits_url":"https://api.github.com/repos/influxdb/influxdb.com/commits{/sha}","git_commits_url":"https://api.github.com/repos/influxdb/influxdb.com/git/commits{/sha}","comments_url":"https://api.github.com/repos/influxdb/influxdb.com/comments{/number}","issue_comment_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/comments{/number}","contents_url":"https://api.github.com/repos/influxdb/influxdb.com/contents/{+path}","compare_url":"https://api.github.com/repos/influxdb/influxdb.com/compare/{base}...{head}","merges_url":"https://api.github.com/repos/influxdb/influxdb.com/merges","archive_url":"https://api.github.com/repos/influxdb/influxdb.com/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/influxdb/influxdb.com/downloads","issues_url":"https://api.github.com/repos/influxdb/influxdb.com/issues{/number}","pulls_url":"https://api.github.com/repos/influxdb/influxdb.com/pulls{/number}","milestones_url":"https://api.github.com/repos/influxdb/influxdb.com/milestones{/number}","notifications_url":"https://api.github.com/repos/influxdb/influxdb.com/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/influxdb/influxdb.com/labels{/name}","releases_url":"https://api.github.com/repos/influxdb/influxdb.com/releases{/id}","created_at":"2015-05-11T18:02:06Z","updated_at":"2015-08-28T19:07:39Z","pushed_at":"2015-09-16T04:57:00Z","git_url":"git://github.com/influxdb/influxdb.com.git","ssh_url":"git@github.com:influxdb/influxdb.com.git","clone_url":"https://github.com/influxdb/influxdb.com.git","svn_url":"https://github.com/influxdb/influxdb.com","homepage":null,"size":6652,"stargazers_count":10,"watchers_count":10,"language":"HTML","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":37,"mirror_url":null,"open_issues_count":71,"forks":37,"open_issues":71,"watchers":10,"default_branch":"master"}},"base":{"label":"influxdb:master","ref":"master","sha":"486f34cddfc8ef38eb59a69f40f818f9966a6825","user":{"login":"influxdb","id":5713248,"avatar_url":"https://avatars.githubusercontent.com/u/5713248?v=3","gravatar_id":"","url":"https://api.github.com/users/influxdb","html_url":"https://github.com/influxdb","followers_url":"https://api.github.com/users/influxdb/followers","following_url":"https://api.github.com/users/influxdb/following{/other_user}","gists_url":"https://api.github.com/users/influxdb/gists{/gist_id}","starred_url":"https://api.github.com/users/influxdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/influxdb/subscriptions","organizations_url":"https://api.github.com/users/influxdb/orgs","repos_url":"https://api.github.com/users/influxdb/repos","events_url":"https://api.github.com/users/influxdb/events{/privacy}","received_events_url":"https://api.github.com/users/influxdb/received_events","type":"Organization","site_admin":false},"repo":{"id":35440649,"name":"influxdb.com","full_name":"influxdb/influxdb.com","owner":{"login":"influxdb","id":5713248,"avatar_url":"https://avatars.githubusercontent.com/u/5713248?v=3","gravatar_id":"","url":"https://api.github.com/users/influxdb","html_url":"https://github.com/influxdb","followers_url":"https://api.github.com/users/influxdb/followers","following_url":"https://api.github.com/users/influxdb/following{/other_user}","gists_url":"https://api.github.com/users/influxdb/gists{/gist_id}","starred_url":"https://api.github.com/users/influxdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/influxdb/subscriptions","organizations_url":"https://api.github.com/users/influxdb/orgs","repos_url":"https://api.github.com/users/influxdb/repos","events_url":"https://api.github.com/users/influxdb/events{/privacy}","received_events_url":"https://api.github.com/users/influxdb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/influxdb/influxdb.com","description":"The main InfluxDB site","fork":false,"url":"https://api.github.com/repos/influxdb/influxdb.com","forks_url":"https://api.github.com/repos/influxdb/influxdb.com/forks","keys_url":"https://api.github.com/repos/influxdb/influxdb.com/keys{/key_id}","collaborators_url":"https://api.github.com/repos/influxdb/influxdb.com/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/influxdb/influxdb.com/teams","hooks_url":"https://api.github.com/repos/influxdb/influxdb.com/hooks","issue_events_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/events{/number}","events_url":"https://api.github.com/repos/influxdb/influxdb.com/events","assignees_url":"https://api.github.com/repos/influxdb/influxdb.com/assignees{/user}","branches_url":"https://api.github.com/repos/influxdb/influxdb.com/branches{/branch}","tags_url":"https://api.github.com/repos/influxdb/influxdb.com/tags","blobs_url":"https://api.github.com/repos/influxdb/influxdb.com/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/influxdb/influxdb.com/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/influxdb/influxdb.com/git/refs{/sha}","trees_url":"https://api.github.com/repos/influxdb/influxdb.com/git/trees{/sha}","statuses_url":"https://api.github.com/repos/influxdb/influxdb.com/statuses/{sha}","languages_url":"https://api.github.com/repos/influxdb/influxdb.com/languages","stargazers_url":"https://api.github.com/repos/influxdb/influxdb.com/stargazers","contributors_url":"https://api.github.com/repos/influxdb/influxdb.com/contributors","subscribers_url":"https://api.github.com/repos/influxdb/influxdb.com/subscribers","subscription_url":"https://api.github.com/repos/influxdb/influxdb.com/subscription","commits_url":"https://api.github.com/repos/influxdb/influxdb.com/commits{/sha}","git_commits_url":"https://api.github.com/repos/influxdb/influxdb.com/git/commits{/sha}","comments_url":"https://api.github.com/repos/influxdb/influxdb.com/comments{/number}","issue_comment_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/comments{/number}","contents_url":"https://api.github.com/repos/influxdb/influxdb.com/contents/{+path}","compare_url":"https://api.github.com/repos/influxdb/influxdb.com/compare/{base}...{head}","merges_url":"https://api.github.com/repos/influxdb/influxdb.com/merges","archive_url":"https://api.github.com/repos/influxdb/influxdb.com/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/influxdb/influxdb.com/downloads","issues_url":"https://api.github.com/repos/influxdb/influxdb.com/issues{/number}","pulls_url":"https://api.github.com/repos/influxdb/influxdb.com/pulls{/number}","milestones_url":"https://api.github.com/repos/influxdb/influxdb.com/milestones{/number}","notifications_url":"https://api.github.com/repos/influxdb/influxdb.com/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/influxdb/influxdb.com/labels{/name}","releases_url":"https://api.github.com/repos/influxdb/influxdb.com/releases{/id}","created_at":"2015-05-11T18:02:06Z","updated_at":"2015-08-28T19:07:39Z","pushed_at":"2015-09-16T04:57:00Z","git_url":"git://github.com/influxdb/influxdb.com.git","ssh_url":"git@github.com:influxdb/influxdb.com.git","clone_url":"https://github.com/influxdb/influxdb.com.git","svn_url":"https://github.com/influxdb/influxdb.com","homepage":null,"size":6652,"stargazers_count":10,"watchers_count":10,"language":"HTML","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":37,"mirror_url":null,"open_issues_count":71,"forks":37,"open_issues":71,"watchers":10,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/influxdb/influxdb.com/pulls/316"},"html":{"href":"https://github.com/influxdb/influxdb.com/pull/316"},"issue":{"href":"https://api.github.com/repos/influxdb/influxdb.com/issues/316"},"comments":{"href":"https://api.github.com/repos/influxdb/influxdb.com/issues/316/comments"},"review_comments":{"href":"https://api.github.com/repos/influxdb/influxdb.com/pulls/316/comments"},"review_comment":{"href":"https://api.github.com/repos/influxdb/influxdb.com/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/influxdb/influxdb.com/pulls/316/commits"},"statuses":{"href":"https://api.github.com/repos/influxdb/influxdb.com/statuses/d780081f1ba8dbf7bc6c0b69f1b95ca6d6bab275"}}}}