Changeset 7009b029e1b54b90126ad1242c59edb399cf0492

Timestamp:

10/24/09 20:36:35 (4 years ago)

Author:

Theo Schlossnagle <jesus@omniti.com>

git-committer:

Theo Schlossnagle <jesus@omniti.com> 1256416595 +0000

git-parent:

[7c5375ebbc78acd69e46501e37a917cbe41bc93e]

git-author:

Theo Schlossnagle <jesus@omniti.com> 1256416595 +0000

Message:

make the math right

Files:

• sql/scaffolding.sql (modified) (1 diff)
• sql/sprocs/stratcon.rollup_metric_numeric.sql (modified) (1 diff)

sql/scaffolding.sql

@@ -58 +58 @@
-\i sprocs/stratcon.map_uuid_to_sid.sql
-\i sprocs/stratcon.update_config.sql
-_5m
+
-\i sprocs/stratcon.metric_name_summary_compile_fts_data.sql
-\i sprocs/stratcon.rollup_metric_numeric.sql

sql/sprocs/stratcon.rollup_metric_numeric.sql

@@ -66 +66 @@
-        END LOOP;
-
-up
+
-            v_sql := 'SELECT * FROM stratcon.window_robust_derive('||quote_literal(v_min_whence)||')';
-        ELSE
-
-
+
+
+
+
+
-            v_sql := v_sql || quote_literal(v_min_whence + (v_conf.seconds - 1) * '1 second'::interval) || ',' || quote_literal(v_conf.dependent_on) ||')';
-            v_sql := v_sql || ' GROUP BY sid, name';  
-
-       --   v_sql := 'SELECT sid, name, $1 as rollup_time, SUM(1) as count_rows, (SUM(avg_value*1)/SUM(1)) as avg_value, (SUM(counter_dev*1)/SUM(1)) as counter_dev
-       --             FROM  stratcon.unroll_metric_numeric( $1, $2, $3)
-       --             GROUP BY sid, name';
-        END IF;
-
+'
-
-        FOR v_rec IN EXECUTE v_sql LOOP