Show
Ignore:
Timestamp:
10/23/09 20:02:12 (5 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1256328132 +0000
git-parent:

[dba7e5a3c25fc0d84d2ba5672f54fa0330030ac1]

git-author:
Robert Treat <robert@omniti.com> 1256328132 +0000
Message:

use config based interval names

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/sprocs/noit.mark_metric_numeric_rollup_buffer.sql

    r1cb12d1 rd4cb47f  
    1414 v_whence_5:=date_trunc('H',NEW.WHENCE) + (round(extract('minute' from NEW.WHENCE)/5)*5) * '1 minute'::interval; 
    1515  
    16    SELECT whence FROM noit.metric_numeric_rollup_queue WHERE whence=v_whence_5 and interval='5 minutes
     16   SELECT whence FROM noit.metric_numeric_rollup_queue WHERE whence=v_whence_5 and interval='5m
    1717     INTO v_whence; 
    1818      
    1919   IF NOT FOUND THEN 
    2020      BEGIN 
    21        INSERT INTO  noit.metric_numeric_rollup_queue VALUES(v_whence_5,'5 minutes'); 
     21       INSERT INTO  noit.metric_numeric_rollup_queue VALUES(v_whence_5,'5m'); 
    2222       EXCEPTION 
    2323        WHEN UNIQUE_VIOLATION THEN