[rrd-users] rrdfetch returning too many rows

permalink · #1 (**permalink**) 11-12-2007

--===============1710825404==
Content-Type: multipart/alternative;
boundary="_8281c681-3445-4de9-81b7-573b14f6e695_"

--_8281c681-3445-4de9-81b7-573b14f6e695_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I would like to fetch the hourly averages for a particular datasouce in an =
rrd file for the last 24 hours.
The command I'm using is similar to the one on the man page for rrdfetch:

rrdtool fetch $rrdfile AVERAGE -r $rrdres -e @{[int($ctime/$rrdres)*$rrdres=
]} -s e-24h

However, this returns 50 rows, instead of 24. Also is there a way for me ju=
st to pull out one datasource, instead of all of them?

Thanks for any help.

Ed.

This is my rrd file info:

filename =3D "/ac/appl/rra/solaris/smpl336/CPU_Utilisation.rrd"
rrd_version =3D "0003"
step =3D 60
last_update =3D 1194790260
ds[CPUIdleTime].type =3D "GAUGE"
ds[CPUIdleTime].minimal_heartbeat =3D 120
ds[CPUIdleTime].min =3D NaN
ds[CPUIdleTime].max =3D NaN
ds[CPUIdleTime].last_ds =3D "UNKN"
ds[CPUIdleTime].value =3D 0.0000000000e+00
ds[CPUIdleTime].unknown_sec =3D 0
ds[CPUSysTime].type =3D "GAUGE"
ds[CPUSysTime].minimal_heartbeat =3D 120
ds[CPUSysTime].min =3D NaN
ds[CPUSysTime].max =3D NaN
ds[CPUSysTime].last_ds =3D "UNKN"
ds[CPUSysTime].value =3D 0.0000000000e+00
ds[CPUSysTime].unknown_sec =3D 0
ds[CPUUserTime].type =3D "GAUGE"
ds[CPUUserTime].minimal_heartbeat =3D 120
ds[CPUUserTime].min =3D NaN
ds[CPUUserTime].max =3D NaN
ds[CPUUserTime].last_ds =3D "UNKN"
ds[CPUUserTime].value =3D 0.0000000000e+00
ds[CPUUserTime].unknown_sec =3D 0
ds[CPUWio].type =3D "GAUGE"
ds[CPUWio].minimal_heartbeat =3D 120
ds[CPUWio].min =3D NaN
ds[CPUWio].max =3D NaN
ds[CPUWio].last_ds =3D "UNKN"
ds[CPUWio].value =3D 0.0000000000e+00
ds[CPUWio].unknown_sec =3D 0
rra[0].cf =3D "AVERAGE"
rra[0].rows =3D 26352
rra[0].pdp_per_row =3D 5
rra[0].xff =3D 5.0000000000e-01
rra[0].cdp_prep[0].value =3D 9.6212500000e+01
rra[0].cdp_prep[0].unknown_datapoints =3D 0
rra[0].cdp_prep[1].value =3D 2.3208300000e+00
rra[0].cdp_prep[1].unknown_datapoints =3D 0
rra[0].cdp_prep[2].value =3D 1.0000000000e+00
rra[0].cdp_prep[2].unknown_datapoints =3D 0
rra[0].cdp_prep[3].value =3D 4.6666700000e-01
rra[0].cdp_prep[3].unknown_datapoints =3D 0
rra[1].cf =3D "AVERAGE"
rra[1].rows =3D 8784
rra[1].pdp_per_row =3D 30
rra[1].xff =3D 5.0000000000e-01
rra[1].cdp_prep[0].value =3D 1.0412208000e+03
rra[1].cdp_prep[0].unknown_datapoints =3D 0
rra[1].cdp_prep[1].value =3D 3.3233320000e+01
rra[1].cdp_prep[1].unknown_datapoints =3D 0
rra[1].cdp_prep[2].value =3D 1.9645834000e+01
rra[1].cdp_prep[2].unknown_datapoints =3D 0
rra[1].cdp_prep[3].value =3D 5.9000000000e+00
rra[1].cdp_prep[3].unknown_datapoints =3D 0
rra[2].cf =3D "AVERAGE"
rra[2].rows =3D 4392
rra[2].pdp_per_row =3D 120
rra[2].xff =3D 5.0000000000e-01
rra[2].cdp_prep[0].value =3D 1.0412208000e+03
rra[2].cdp_prep[0].unknown_datapoints =3D 0
rra[2].cdp_prep[1].value =3D 3.3233320000e+01
rra[2].cdp_prep[1].unknown_datapoints =3D 0
rra[2].cdp_prep[2].value =3D 1.9645834000e+01
rra[2].cdp_prep[2].unknown_datapoints =3D 0
rra[2].cdp_prep[3].value =3D 5.9000000000e+00
rra[2].cdp_prep[3].unknown_datapoints =3D 0
rra[3].cf =3D "AVERAGE"
rra[3].rows =3D 1098
rra[3].pdp_per_row =3D 1440
rra[3].xff =3D 5.0000000000e-01
rra[3].cdp_prep[0].value =3D 7.3504437525e+04
rra[3].cdp_prep[0].unknown_datapoints =3D 0
rra[3].cdp_prep[1].value =3D 6.2181231118e+03
rra[3].cdp_prep[1].unknown_datapoints =3D 0
rra[3].cdp_prep[2].value =3D 4.4994659040e+03
rra[3].cdp_prep[2].unknown_datapoints =3D 0
rra[3].cdp_prep[3].value =3D 8.7797240245e+02
rra[3].cdp_prep[3].unknown_datapoints =3D 0
rra[4].cf =3D "MAX"
rra[4].rows =3D 26352
rra[4].pdp_per_row =3D 5
rra[4].xff =3D 5.0000000000e-01
rra[4].cdp_prep[0].value =3D 9.6212500000e+01
rra[4].cdp_prep[0].unknown_datapoints =3D 0
rra[4].cdp_prep[1].value =3D 6.6625000000e+00
rra[4].cdp_prep[1].unknown_datapoints =3D 0
rra[4].cdp_prep[2].value =3D 5.4833300000e+00
rra[4].cdp_prep[2].unknown_datapoints =3D 0
rra[4].cdp_prep[3].value =3D 7.3333300000e-01
rra[4].cdp_prep[3].unknown_datapoints =3D 0
rra[5].cf =3D "MAX"
rra[5].rows =3D 8784
rra[5].pdp_per_row =3D 30
rra[5].xff =3D 5.0000000000e-01
rra[5].cdp_prep[0].value =3D 9.6970800000e+01
rra[5].cdp_prep[0].unknown_datapoints =3D 0
rra[5].cdp_prep[1].value =3D 6.6791700000e+00
rra[5].cdp_prep[1].unknown_datapoints =3D 0
rra[5].cdp_prep[2].value =3D 5.6000000000e+00
rra[5].cdp_prep[2].unknown_datapoints =3D 0
rra[5].cdp_prep[3].value =3D 7.4166700000e-01
rra[5].cdp_prep[3].unknown_datapoints =3D 0
rra[6].cf =3D "MAX"
rra[6].rows =3D 4392
rra[6].pdp_per_row =3D 120
rra[6].xff =3D 5.0000000000e-01
rra[6].cdp_prep[0].value =3D 9.6970800000e+01
rra[6].cdp_prep[0].unknown_datapoints =3D 0
rra[6].cdp_prep[1].value =3D 6.6791700000e+00
rra[6].cdp_prep[1].unknown_datapoints =3D 0
rra[6].cdp_prep[2].value =3D 5.6000000000e+00
rra[6].cdp_prep[2].unknown_datapoints =3D 0
rra[6].cdp_prep[3].value =3D 7.4166700000e-01
rra[6].cdp_prep[3].unknown_datapoints =3D 0
rra[7].cf =3D "MAX"
rra[7].rows =3D 1098
rra[7].pdp_per_row =3D 1440
rra[7].xff =3D 5.0000000000e-01
rra[7].cdp_prep[0].value =3D 9.8075000000e+01
rra[7].cdp_prep[0].unknown_datapoints =3D 0
rra[7].cdp_prep[1].value =3D 4.0170800000e+01
rra[7].cdp_prep[1].unknown_datapoints =3D 0
rra[7].cdp_prep[2].value =3D 3.0358300000e+01
rra[7].cdp_prep[2].unknown_datapoints =3D 0
rra[7].cdp_prep[3].value =3D 2.2837500000e+01
rra[7].cdp_prep[3].unknown_datapoints =3D 0
rra[8].cf =3D "MIN"
rra[8].rows =3D 26352
rra[8].pdp_per_row =3D 5
rra[8].xff =3D 5.0000000000e-01
rra[8].cdp_prep[0].value =3D 8.7120800000e+01
rra[8].cdp_prep[0].unknown_datapoints =3D 0
rra[8].cdp_prep[1].value =3D 2.3208300000e+00
rra[8].cdp_prep[1].unknown_datapoints =3D 0
rra[8].cdp_prep[2].value =3D 1.0000000000e+00
rra[8].cdp_prep[2].unknown_datapoints =3D 0
rra[8].cdp_prep[3].value =3D 4.6666700000e-01
rra[8].cdp_prep[3].unknown_datapoints =3D 0
rra[9].cf =3D "MIN"
rra[9].rows =3D 8784
rra[9].pdp_per_row =3D 30
rra[9].xff =3D 5.0000000000e-01
rra[9].cdp_prep[0].value =3D 8.7120800000e+01
rra[9].cdp_prep[0].unknown_datapoints =3D 0
rra[9].cdp_prep[1].value =3D 1.7541700000e+00
rra[9].cdp_prep[1].unknown_datapoints =3D 0
rra[9].cdp_prep[2].value =3D 7.2916700000e-01
rra[9].cdp_prep[2].unknown_datapoints =3D 0
rra[9].cdp_prep[3].value =3D 4.1666700000e-01
rra[9].cdp_prep[3].unknown_datapoints =3D 0
rra[10].cf =3D "MIN"
rra[10].rows =3D 4392
rra[10].pdp_per_row =3D 120
rra[10].xff =3D 5.0000000000e-01
rra[10].cdp_prep[0].value =3D 8.7120800000e+01
rra[10].cdp_prep[0].unknown_datapoints =3D 0
rra[10].cdp_prep[1].value =3D 1.7541700000e+00
rra[10].cdp_prep[1].unknown_datapoints =3D 0
rra[10].cdp_prep[2].value =3D 7.2916700000e-01
rra[10].cdp_prep[2].unknown_datapoints =3D 0
rra[10].cdp_prep[3].value =3D 4.1666700000e-01
rra[10].cdp_prep[3].unknown_datapoints =3D 0
rra[11].cf =3D "MIN"
rra[11].rows =3D 1098
rra[11].pdp_per_row =3D 1440
rra[11].xff =3D 5.0000000000e-01
rra[11].cdp_prep[0].value =3D 4.2287500000e+01
rra[11].cdp_prep[0].unknown_datapoints =3D 0
rra[11].cdp_prep[1].value =3D 1.1125000000e+00
rra[11].cdp_prep[1].unknown_datapoints =3D 0
rra[11].cdp_prep[2].value =3D 4.5416700000e-01
rra[11].cdp_prep[2].unknown_datapoints =3D 0
rra[11].cdp_prep[3].value =3D 2.5000000000e-01
rra[11].cdp_prep[3].unknown_datapoints =3D 0

__________________________________________________ _______________
Feel like a local wherever you go.
http://www.backofmyhand.com=

--_8281c681-3445-4de9-81b7-573b14f6e695_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
..hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class=3D'hmmessage'>
Hi, I would like to fetch the hourly averages for a particular datas=
ouce in an rrd file for the last 24 hours. The command I'm using is simi=
lar to the one on the man page for rrdfetch: rrdtool fetch $rrdfile =
AVERAGE -r $rrdres -e @{[int($ctime/$rrdres)*$rrdres]} -s e-24h Howe=
ver, this returns 50 rows, instead of 24. Also is there a way for me just t=
o pull out one datasource, instead of all of them? Thanks for any he=
lp. Ed. This is my rrd file info: filename =3D "/ac/ap=
pl/rra/solaris/smpl336/CPU_Utilisation.rrd" rrd_version =3D "0003" st=
ep =3D 60 last_update =3D 1194790260 ds[CPUIdleTime].type =3D "GAUGE"=
 ds[CPUIdleTime].minimal_heartbeat =3D 120 ds[CPUIdleTime].min =3D Na=
N ds[CPUIdleTime].max =3D NaN ds[CPUIdleTime].last_ds =3D "UNKN" d=
s[CPUIdleTime].value =3D 0.0000000000e+00 ds[CPUIdleTime].unknown_sec =
=3D 0 ds[CPUSysTime].type =3D "GAUGE" ds[CPUSysTime].minimal_heartbea=
t =3D 120 ds[CPUSysTime].min =3D NaN ds[CPUSysTime].max =3D NaN ds=
[CPUSysTime].last_ds =3D "UNKN" ds[CPUSysTime].value =3D 0.0000000000e+0=
0 ds[CPUSysTime].unknown_sec =3D 0 ds[CPUUserTime].type =3D "GAUGE"<b=
r>ds[CPUUserTime].minimal_heartbeat =3D 120 ds[CPUUserTime].min =3D NaN<=
br>ds[CPUUserTime].max =3D NaN ds[CPUUserTime].last_ds =3D "UNKN" ds[=
CPUUserTime].value =3D 0.0000000000e+00 ds[CPUUserTime].unknown_sec =3D =
0 ds[CPUWio].type =3D "GAUGE" ds[CPUWio].minimal_heartbeat =3D 120<br=
>ds[CPUWio].min =3D NaN ds[CPUWio].max =3D NaN ds[CPUWio].last_ds =3D=
"UNKN" ds[CPUWio].value =3D 0.0000000000e+00 ds[CPUWio].unknown_sec =
=3D 0 rra[0].cf =3D "AVERAGE" rra[0].rows =3D 26352 rra[0].pdp_per=
_row =3D 5 rra[0].xff =3D 5.0000000000e-01 rra[0].cdp_prep[0].value =
=3D 9.6212500000e+01 rra[0].cdp_prep[0].unknown_datapoints =3D 0 rra[=
0].cdp_prep[1].value =3D 2.3208300000e+00 rra[0].cdp_prep[1].unknown_dat=
apoints =3D 0 rra[0].cdp_prep[2].value =3D 1.0000000000e+00 rra[0].cd=
p_prep[2].unknown_datapoints =3D 0 rra[0].cdp_prep[3].value =3D 4.666670=
0000e-01 rra[0].cdp_prep[3].unknown_datapoints =3D 0 rra[1].cf =3D "A=
VERAGE" rra[1].rows =3D 8784 rra[1].pdp_per_row =3D 30 rra[1].xff =
=3D 5.0000000000e-01 rra[1].cdp_prep[0].value =3D 1.0412208000e+03 rr=
a[1].cdp_prep[0].unknown_datapoints =3D 0 rra[1].cdp_prep[1].value =3D 3=
..3233320000e+01 rra[1].cdp_prep[1].unknown_datapoints =3D 0 rra[1].cd=
p_prep[2].value =3D 1.9645834000e+01 rra[1].cdp_prep[2].unknown_datapoin=
ts =3D 0 rra[1].cdp_prep[3].value =3D 5.9000000000e+00 rra[1].cdp_pre=
p[3].unknown_datapoints =3D 0 rra[2].cf =3D "AVERAGE" rra[2].rows =3D=
4392 rra[2].pdp_per_row =3D 120 rra[2].xff =3D 5.0000000000e-01 r=
ra[2].cdp_prep[0].value =3D 1.0412208000e+03 rra[2].cdp_prep[0].unknown_=
datapoints =3D 0 rra[2].cdp_prep[1].value =3D 3.3233320000e+01 rra[2]=
..cdp_prep[1].unknown_datapoints =3D 0 rra[2].cdp_prep[2].value =3D 1.964=
5834000e+01 rra[2].cdp_prep[2].unknown_datapoints =3D 0 rra[2].cdp_pr=
ep[3].value =3D 5.9000000000e+00 rra[2].cdp_prep[3].unknown_datapoints =
=3D 0 rra[3].cf =3D "AVERAGE" rra[3].rows =3D 1098 rra[3].pdp_per_=
row =3D 1440 rra[3].xff =3D 5.0000000000e-01 rra[3].cdp_prep[0].value=
=3D 7.3504437525e+04 rra[3].cdp_prep[0].unknown_datapoints =3D 0 rra=
[3].cdp_prep[1].value =3D 6.2181231118e+03 rra[3].cdp_prep[1].unknown_da=
tapoints =3D 0 rra[3].cdp_prep[2].value =3D 4.4994659040e+03 rra[3].c=
dp_prep[2].unknown_datapoints =3D 0 rra[3].cdp_prep[3].value =3D 8.77972=
40245e+02 rra[3].cdp_prep[3].unknown_datapoints =3D 0 rra[4].cf =3D "=
MAX" rra[4].rows =3D 26352 rra[4].pdp_per_row =3D 5 rra[4].xff =3D=
5.0000000000e-01 rra[4].cdp_prep[0].value =3D 9.6212500000e+01 rra[4=
].cdp_prep[0].unknown_datapoints =3D 0 rra[4].cdp_prep[1].value =3D 6.66=
25000000e+00 rra[4].cdp_prep[1].unknown_datapoints =3D 0 rra[4].cdp_p=
rep[2].value =3D 5.4833300000e+00 rra[4].cdp_prep[2].unknown_datapoints =
=3D 0 rra[4].cdp_prep[3].value =3D 7.3333300000e-01 rra[4].cdp_prep[3=
].unknown_datapoints =3D 0 rra[5].cf =3D "MAX" rra[5].rows =3D 8784<b=
r>rra[5].pdp_per_row =3D 30 rra[5].xff =3D 5.0000000000e-01 rra[5].cd=
p_prep[0].value =3D 9.6970800000e+01 rra[5].cdp_prep[0].unknown_datapoin=
ts =3D 0 rra[5].cdp_prep[1].value =3D 6.6791700000e+00 rra[5].cdp_pre=
p[1].unknown_datapoints =3D 0 rra[5].cdp_prep[2].value =3D 5.6000000000e=
+00 rra[5].cdp_prep[2].unknown_datapoints =3D 0 rra[5].cdp_prep[3].va=
lue =3D 7.4166700000e-01 rra[5].cdp_prep[3].unknown_datapoints =3D 0 =
rra[6].cf =3D "MAX" rra[6].rows =3D 4392 rra[6].pdp_per_row =3D 120<b=
r>rra[6].xff =3D 5.0000000000e-01 rra[6].cdp_prep[0].value =3D 9.6970800=
000e+01 rra[6].cdp_prep[0].unknown_datapoints =3D 0 rra[6].cdp_prep[1=
].value =3D 6.6791700000e+00 rra[6].cdp_prep[1].unknown_datapoints =3D 0=
 rra[6].cdp_prep[2].value =3D 5.6000000000e+00 rra[6].cdp_prep[2].unk=
nown_datapoints =3D 0 rra[6].cdp_prep[3].value =3D 7.4166700000e-01 r=
ra[6].cdp_prep[3].unknown_datapoints =3D 0 rra[7].cf =3D "MAX" rra[7]=
..rows =3D 1098 rra[7].pdp_per_row =3D 1440 rra[7].xff =3D 5.000000000=
0e-01 rra[7].cdp_prep[0].value =3D 9.8075000000e+01 rra[7].cdp_prep[0=
].unknown_datapoints =3D 0 rra[7].cdp_prep[1].value =3D 4.0170800000e+01=
 rra[7].cdp_prep[1].unknown_datapoints =3D 0 rra[7].cdp_prep[2].value=
=3D 3.0358300000e+01 rra[7].cdp_prep[2].unknown_datapoints =3D 0 rra=
[7].cdp_prep[3].value =3D 2.2837500000e+01 rra[7].cdp_prep[3].unknown_da=
tapoints =3D 0 rra[8].cf =3D "MIN" rra[8].rows =3D 26352 rra[8].pd=
p_per_row =3D 5 rra[8].xff =3D 5.0000000000e-01 rra[8].cdp_prep[0].va=
lue =3D 8.7120800000e+01 rra[8].cdp_prep[0].unknown_datapoints =3D 0 =
rra[8].cdp_prep[1].value =3D 2.3208300000e+00 rra[8].cdp_prep[1].unknown=
_datapoints =3D 0 rra[8].cdp_prep[2].value =3D 1.0000000000e+00 rra[8=
].cdp_prep[2].unknown_datapoints =3D 0 rra[8].cdp_prep[3].value =3D 4.66=
66700000e-01 rra[8].cdp_prep[3].unknown_datapoints =3D 0 rra[9].cf =
=3D "MIN" rra[9].rows =3D 8784 rra[9].pdp_per_row =3D 30 rra[9].xf=
f =3D 5.0000000000e-01 rra[9].cdp_prep[0].value =3D 8.7120800000e+01 =
rra[9].cdp_prep[0].unknown_datapoints =3D 0 rra[9].cdp_prep[1].value =3D=
1.7541700000e+00 rra[9].cdp_prep[1].unknown_datapoints =3D 0 rra[9].=
cdp_prep[2].value =3D 7.2916700000e-01 rra[9].cdp_prep[2].unknown_datapo=
ints =3D 0 rra[9].cdp_prep[3].value =3D 4.1666700000e-01 rra[9].cdp_p=
rep[3].unknown_datapoints =3D 0 rra[10].cf =3D "MIN" rra[10].rows =3D=
4392 rra[10].pdp_per_row =3D 120 rra[10].xff =3D 5.0000000000e-01<br=
>rra[10].cdp_prep[0].value =3D 8.7120800000e+01 rra[10].cdp_prep[0].unkn=
own_datapoints =3D 0 rra[10].cdp_prep[1].value =3D 1.7541700000e+00 r=
ra[10].cdp_prep[1].unknown_datapoints =3D 0 rra[10].cdp_prep[2].value =
=3D 7.2916700000e-01 rra[10].cdp_prep[2].unknown_datapoints =3D 0 rra=
[10].cdp_prep[3].value =3D 4.1666700000e-01 rra[10].cdp_prep[3].unknown_=
datapoints =3D 0 rra[11].cf =3D "MIN" rra[11].rows =3D 1098 rra[11=
].pdp_per_row =3D 1440 rra[11].xff =3D 5.0000000000e-01 rra[11].cdp_p=
rep[0].value =3D 4.2287500000e+01 rra[11].cdp_prep[0].unknown_datapoints=
=3D 0 rra[11].cdp_prep[1].value =3D 1.1125000000e+00 rra[11].cdp_pre=
p[1].unknown_datapoints =3D 0 rra[11].cdp_prep[2].value =3D 4.5416700000=
e-01 rra[11].cdp_prep[2].unknown_datapoints =3D 0 rra[11].cdp_prep[3]=
..value =3D 2.5000000000e-01 rra[11].cdp_prep[3].unknown_datapoints =3D 0=
 <hr />Do you know a place like the back of your hand? Sha=
re local knowledge with <a href=3D'http://www.backofmyhand.com' target=3D'=
_new'>BackOfMyHand.com</a></body>
</html>=

--_8281c681-3445-4de9-81b7-573b14f6e695_--

--===============1710825404==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
rrd-users mailing list
rrd-users@lists.oetiker.ch
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

--===============1710825404==--

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode