From 3762da9211ecc8b0fcbb57df0ae996af9b76de57 Mon Sep 17 00:00:00 2001
From: =?utf8?q?=C3=89ric=20Lemoine?= <elemoine@mirantis.com>
Date: Thu, 24 Nov 2016 14:01:32 +0000
Subject: [PATCH] Use better InfluxDB queries

Use better InfluxDB queries by not using GROUP_BY when not necessary.
---
 elasticsearch/files/grafana_influxdb.json | 50 +++++++----------------
 1 file changed, 15 insertions(+), 35 deletions(-)

diff --git a/elasticsearch/files/grafana_influxdb.json b/elasticsearch/files/grafana_influxdb.json
index 1697da0..9eec5af 100644
--- a/elasticsearch/files/grafana_influxdb.json
+++ b/elasticsearch/files/grafana_influxdb.json
@@ -90,19 +90,12 @@
               "dsType": "influxdb",
               "fill": "",
               "function": "last",
-              "groupBy": [
-                {
-                  "params": [
-                    "auto"
-                  ],
-                  "type": "time"
-                }
-              ],
+              "groupBy": [],
               "groupby_field": "",
               "interval": "",
               "measurement": "cluster_status",
               "policy": "default",
-              "query": "SELECT last(\"value\") FROM \"cluster_status\" WHERE \"cluster_name\" = 'elasticsearch' AND $timeFilter GROUP BY time($interval)",
+              "query": "SELECT last(\"value\") FROM \"cluster_status\" WHERE \"cluster_name\" = 'elasticsearch' AND $timeFilter",
               "rawQuery": false,
               "refId": "A",
               "resultFormat": "time_series",
@@ -123,10 +116,11 @@
               "tags": [
                 {
                   "key": "environment_label",
-                  "operator": "=",
-                  "value": "$environment"
+                  "operator": "=~",
+                  "value": "/^$environment$/"
                 },
                 {
+                  "condition": "AND",
                   "key": "cluster_name",
                   "operator": "=",
                   "value": "elasticsearch"
@@ -232,17 +226,10 @@
             {
               "alias": "number",
               "dsType": "influxdb",
-              "groupBy": [
-                {
-                  "params": [
-                    "auto"
-                  ],
-                  "type": "time"
-                }
-              ],
+              "groupBy": [],
               "measurement": "elasticsearch_cluster_number_of_nodes",
               "policy": "default",
-              "query": "SELECT last(\"value\") FROM \"elasticsearch_cluster_number_of_nodes\" WHERE $timeFilter GROUP BY time($interval)",
+              "query": "SELECT last(\"value\") FROM \"elasticsearch_cluster_number_of_nodes\" WHERE $timeFilter",
               "rawQuery": false,
               "refId": "A",
               "resultFormat": "time_series",
@@ -263,8 +250,8 @@
               "tags": [
                 {
                   "key": "environment_label",
-                  "operator": "=",
-                  "value": "$environment"
+                  "operator": "=~",
+                  "value": "/^$environment$/"
                 }
               ]
             }
@@ -726,17 +713,10 @@
               "column": "value",
               "dsType": "influxdb",
               "function": "last",
-              "groupBy": [
-                {
-                  "params": [
-                    "auto"
-                  ],
-                  "type": "time"
-                }
-              ],
+              "groupBy": [],
               "measurement": "lma_components_threads",
               "policy": "default",
-              "query": "SELECT last(\"value\") FROM \"lma_components_threads\" WHERE \"service\" = 'elasticsearch' AND \"hostname\" =~ /^$server$/ AND $timeFilter GROUP BY time($interval)",
+              "query": "SELECT last(\"value\") FROM \"lma_components_threads\" WHERE \"service\" = 'elasticsearch' AND \"hostname\" =~ /^$server$/ AND $timeFilter",
               "rawQuery": false,
               "refId": "A",
               "resultFormat": "time_series",
@@ -763,8 +743,8 @@
                 {
                   "condition": "AND",
                   "key": "hostname",
-                  "operator": "=",
-                  "value": "$server"
+                  "operator": "=~",
+                  "value": "/^$server$/"
                 }
               ]
             }
@@ -1333,5 +1313,5 @@
   },
   "timezone": "browser",
   "title": "Elasticsearch",
-  "version": 3
-}
\ No newline at end of file
+  "version": 4
+}
-- 
2.32.7