[rrd-users] odd XPORT results

Mon Jun 13 16:19:01 CEST 2011

Hi

I'm puzzled by my results when extracting data from an RRD which stores
power usage in kW from several sensors. They are spot values and are not
constantly increasing like a router byte counter. This is RRD 1.2 on
Windows x86 by the way.

The RRD definition is this.... 

rrdtool create kwh.rrd --start N --step 300 

DS:graze_0:GAUGE:900:0:60000 

DS:edctr_0:GAUGE:900:0:60000 

DS:hall_0:GAUGE:900:0:60000 

DS:shop_0:GAUGE:900:0:60000 

DS:encounter_0:GAUGE:900:0:60000 

RRA:AVERAGE:0.5:1:105120 

RRA:AVERAGE:0.5:12:43800

Which as I understand it should maintain the data with two averages for
each sensor. 

One average should be for every 5 minutes for 105120 samples (approx 1
years worth)

The other should store 1hrly for 43800 samples (approx 5 years worth)

The data collection has been running since approx May 2010 so I was
expecting to be able to dump either 5min averages (back to Jun 12ish
2010 - a yrs worth) or the full 1hrly averages right back to May 2010. I
realise its averaged data and not actual data values - thats fine.

If I dump the data using RRDTOOL DUMP I can see all the data as I expect
it. (5 min and 1 hr intervals all ok)

The problem I am having is getting the data exported using RRDTOOL XPORT
- no matter what step I give it seems to be in 36000 steps and I cant
get either 5 min or 1hr steps.......

The output command I'm using is (eg)

rrdtool xport -s Jan_1 -e Jun_6 --step 300
DEF:graze=kwh.rrd:graze_0:AVERAGE XPORT:graze:graze

Which gets me this

graze:36000

step: 36000

<?xml version="1.0" encoding="ISO-8859-1"?>

<xport>

  <meta>

    <start>1293912000</start>

    <step>36000</step>

    <end>1307340000</end>

    <rows>374</rows>

    <columns>1</columns>

    <legend>

      <entry>graze</entry>

    </legend>

  </meta>

  <data>

    <row><t>1293912000</t><v>NaN</v></row>

    <row><t>1293948000</t><v>7.6373329643e+003</v></row>

    <row><t>1293984000</t><v>3.2184306372e+004</v></row>

    <row><t>1294020000</t><v>8.7615560014e+003</v></row>

    <row><t>1294056000</t><v>1.9665019537e+004</v></row>

    <row><t>1294092000</t><v>2.1051444142e+004</v></row>

    <row><t>1294128000</t><v>7.4891892048e+003</v></row>

    <row><t>1294164000</t><v>3.1874450422e+004</v></row>

    <row><t>1294200000</t><v>2.1790117352e+004</v></row>

    <row><t>1294236000</t><v>3.0731709437e+004</v></row>

    <row><t>1294272000</t><v>1.6547402220e+004</v></row>

    <row><t>1294308000</t><v>1.6929343229e+004</v></row>

    <row><t>1294344000</t><v>2.1757634908e+004</v></row>

    <row><t>1294380000</t><v>7.4123166718e+003</v></row>

    <row><t>1294416000</t><v>2.3384609095e+004</v></row>

    <row><t>1294452000</t><v>8.5652547377e+003</v></row>

    <row><t>1294488000</t><v>1.6631237788e+004</v></row>

    <row><t>1294524000</t><v>1.9049472654e+004</v></row>

    <row><t>1294560000</t><v>8.7360718392e+003</v></row>

    <row><t>1294596000</t><v>3.1791358773e+004</v></row>

Why is the step size so large? I'm sure I'm doing something stupid .....
8-)

Thanks

Dave

Dave Whitehead | IT & Telecomms Manager | Marwell Wildlife | Colden
Common | Winchester | SO21 1JH

( Direct: +44 (0)1962 777930 | Mob: +44 (0)7881 408657 +
davew at marwell.org.uk <mailto:davew at marwell.org.uk>  : www.marwell.org.uk
<http://www.marwell.org.uk/>  

-----------------------------------------

Please print responsibly

Marwell Wildlife is a limited liability company registered in England and Wales under number 1355272.
VAT No. 631 9661 30. The company is a registered charity, number 275433 

Registered office: Marwell Wildlife, Colden Common, Winchester, Hampshire, SO21 1JH.

Opinions expressed in this e-mail are those of the individual, not the company unless specifically indicated to that effect. This e-mail and any attachments are confidential and solely for the use of the intended recipient. If you are not the intended recipient we apologise for any inconvenience. Please return to the sender. Any use or copying is strictly prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20110613/cf434d40/attachment.htm 