X-Git-Url: https://git.octo.it/?a=blobdiff_plain;f=sql%2Fmetrics.sql;h=2a06268253ec58e4d0216db63160210191213e52;hb=e13c2f7ca76664f818b98062d0d90033c53484ee;hp=c7e24ea8f17e4c6ff526b0f8717ec62fd63cc50a;hpb=25f3f18fba213e61518e8f4acd5d0f208ba4bff5;p=collectd_dbstore.git

diff --git a/sql/metrics.sql b/sql/metrics.sql
index c7e24ea..2a06268 100644
--- a/sql/metrics.sql
+++ b/sql/metrics.sql
@@ -127,17 +127,14 @@ $$ LANGUAGE plpgsql;
 --  SELECT timestamp,
 --   ((m.measure - lag(m.measure) 
 --           over(partition by m.hostname_id, 
---                             p.plugin,
---                             p.plugin_instance,
---                             t.type,
---                             t.type_instance
---                 order by timestamp, m.hostname_id, p.plugin, p.plugin_instance, t.type, t.type_instance))) AS metric,
+--                             p.plugin_id,
+--                             t.type_id,
+--                 order by timestamp, m.hostname_id, p.plugin_id, t.type_id))) AS metric,
 --  m.hostname_id, 
 --  m.plugin_id, 
 --  m.type_id
 -- FROM metrics m, plugin_dimension p, type_dimension t
 -- where m.type_id = t.id
--- and m.plugin_id = p.id
 -- and t.ds_type = 'COUNTER'
 -- UNION
 -- select timestamp, m.measure as metric,