Remstats Home


  About remstats
  architecture
  Release Notes
  FAQ
  Conventions
  Prerequisites
  Installation
  Configuration
  Configuration Tools
  Servers
  Collectors
  Updater
  Monitors
      alerter
  pagemakers
  run-remstats2
  CGIs
  troubleshooting
  do-traceroutes
  Miscellany
      alerter
      availability-report
      convert-config-links
      files
      functions
      genindex
      genmenu
      htmlpod
      lockfile
      podhtml
      podlatex
      podpdf
      remstats-backup
      remstats-cleanup
      remstats-version
      rename-host
      rrd-report
      rt-updater
  Thank-you
  Index


  Live Data

  Remstats was written by
  Thomas Erskine at the
  CRC in Canada and now
  at SourceWorks.

[Top] [Prev] [Next]

rrd-report - display summaries of an RRD file

Usage:

Can't locate RRDs.pm in @INC (@INC contains: . /usr/lib/remstats/lib /usr/lib/perl5/ /etc/perl /usr/local/lib/perl/5.8.0 /usr/local/share/perl/5.8.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8.0 /usr/share/perl/5.8.0 /usr/local/lib/site_perl) at ../rrd-report line 48.
BEGIN failed--compilation aborted at ../rrd-report line 48.

Examples:

I hope that the above is enough to use it after seeing a few examples. Here's the equivalent of the command that created the RRD for the example.

rrdtool create ping.rrd \ DS:sent:GAUGE:600:0:10 \ DS:rcvd:GAUGE:600:0:10 \ DS:min:GAUGE:600:U:U \ DS:avg:GAUGE:600:U:U \ DS:max:GAUGE:600:U:U \ RRA:AVERAGE:0.1:1:600 \ RRA:AVERAGE:0.1:7:300 \ RRA:AVERAGE:0.1:30:300 \ RRA:AVERAGE:0.1:90:300 \ RRA:AVERAGE:0.1:365:300 \ RRA:MIN:0.1:1:600 \ RRA:MIN:0.1:7:300 \ RRA:MIN:0.1:30:300 \ RRA:MIN:0.1:90:300 \ RRA:MIN:0.1:365:300 \ RRA:MAX:0.1:1:600 \ RRA:MAX:0.1:7:300 \ RRA:MAX:0.1:30:300 \ RRA:MAX:0.1:90:300 \ RRA:MAX:0.1:365:300

See "man rrdcreate" for an explanation for the command itself. The fields are:

  • sent/rcvd - number of ping packets sent/received
  • min/avg/max - the round-trip-time (min, average and max) for the pings

Here's a default report from one of my ping RRDs:

	%rrd-report ping.rrd
	[snip]
	data 1999-10-25 17:20:49 1999-10-26 17:20:49 10.000000 10.000000 10.000000 9.864444 9.899444 9.934444 41.569556 42.210222 42.850889 45.626889 45.758833 45.890778 50.955111 51.253056 51.551000
	data 1999-10-26 17:20:49 1999-10-27 17:20:49 10.000000 10.000000 10.000000 9.934444 9.987819 10.000000 39.536556 41.498103 46.124938 42.166222 45.386889 49.370000 50.955111 52.435532 54.635926
	summary 1999-10-19 17:20:49 1999-10-26 17:20:49 10.000000 10.000000 10.000000 9.331111 9.932391 10.000000 38.317778 42.750146 48.318444 41.500556 46.736223 50.265778 49.122444 52.261605 59.867778
	[snip]
	data 1999-11-17 16:20:49 1999-11-18 16:20:49 10.000000 10.000000 10.000000 8.000000 9.934245 10.000000 36.400000 46.585421 50.000000 41.256667 49.592941 58.640000 49.036667 53.837716 117.240000
	summary 1999-11-16 16:20:49 1999-11-18 16:20:49 10.000000 10.000000 10.000000 9.142857 9.929788 10.000000 38.285714 46.482773 50.000000 47.148095 49.503659 51.294286 50.000000 53.124615 65.880952
	overall 1999-10-19 17:20:49 1999-11-18 16:20:49 9.978889 9.999918 10.000000 1.323333 9.876767 10.000000 6.194333 45.631272 76.394778 6.516556 48.842746 107.286556 6.971111 54.319770 179.554222

Each "data" line is a report for the interval covered by the two timestamps, (by default one day). The values are the requested (or in this case all) DS:CF combinations. The "summary" lines are just reports over a longer interval (by default one week). The "overall" line is for the whole selected time-period.

Hmm. There's much too much there. What I'd really like to see is just the interesting stuff. I know how many pings I'm sending during this period (10), so drop that and just show the minimum min average avg and maximum max:

	% rrd-report -v rcvd:AVERAGE,min:MIN,avg:AVERAGE,max:MAX
	data 1999-10-19 17:54:57 1999-10-20 17:54:57 9.820267 38.317778 43.948411 55.716667
	data 1999-10-20 17:54:57 1999-10-21 17:54:57 9.966716 39.303333 46.180111 59.867778
	data 1999-10-21 17:54:57 1999-10-22 17:54:57 9.907440 40.469000 48.496274 56.022222
	data 1999-10-22 17:54:57 1999-10-23 17:54:57 9.977827 40.232333 47.571133 54.475062
	[snip]
	summary 1999-11-09 16:54:57 1999-11-16 16:54:57 9.950836 39.310056 52.578943 179.554222
	data 1999-11-17 16:54:57 1999-11-18 16:54:57 9.934164 36.400000 49.606736 117.240000
	summary 1999-11-16 16:54:57 1999-11-18 16:54:57 9.928672 38.285714 49.489729 65.880952
	overall 1999-10-19 17:54:57 1999-11-18 16:54:57 9.876767 6.194333 48.842746 179.554222

Well, I can figure out when the period ended, so leave out the end-time, and I don't like seeing all those meaningless (in this case) decimal places, so how about:

	% rrd-report -D start,pretty -n %.1lf -v rcvd:AVERAGE,min:MIN,avg:AVERAGE,max:MAX
	[snip]
	data 1999-11-14 17:27:04 10.0 40.0 49.4 88.7
	data 1999-11-15 17:27:04 9.7 21.7 48.0 63.4
	data 1999-11-16 17:27:04 9.9 38.3 49.4 61.3
	summary 1999-11-09 17:27:04 10.0 39.3 52.6 179.6
	data 1999-11-17 17:27:04 9.9 36.4 49.6 117.2
	summary 1999-11-16 17:27:04 9.9 38.3 49.5 65.9
	overall 1999-10-19 18:27:04 9.9 6.2 48.8 179.6

OK. I'd like to see the last year with a one-week interval, with no summaries. (Setting the report-interval to the same as the summary-interval drops summaries. You still get an overall line.)

	% rrd-report -D start,pretty -n %.1lf -v rcvd:AVERAGE,min:MIN,avg:AVERAGE,ma
	x:MAX -i 1w -s 1w
	data 1998-11-19 09:04:43 NODATA NODATA NODATA NODATA
	[snip]
	data 1999-02-25 09:04:43 9.9 45.0 55.0 64.2
	data 1999-03-04 09:04:43 10.0 43.9 54.5 64.3
	[snip]
	data 1999-11-11 09:04:43 10.0 39.3 51.7 179.6
	data 1999-11-18 09:04:43 9.9 37.4 49.7 169.7
	overall 1998-11-19 09:04:43 9.6 0.0 45.3 103.7

And for those of us who like to see it on the web:

Start rcvd:AVERAGE min:MIN avg:AVERAGE max:MAX
1998-11-19 09:06:37        
1998-11-26 09:06:37        
1998-12-03 09:06:37        
1998-12-10 09:06:37        
1998-12-17 09:06:37        
1998-12-24 09:06:37        
1998-12-31 09:06:37        
1999-01-07 09:06:37        
1999-01-14 09:06:37        
1999-01-21 09:06:37        
1999-01-28 09:06:37        
1999-02-04 09:06:37        
1999-02-11 09:06:37        
1999-02-18 09:06:37        
1999-02-25 09:06:37 9.9 45.0 55.0 64.2
1999-03-04 09:06:37 10.0 43.9 54.5 64.3
1999-03-11 09:06:37 10.0 41.6 54.1 103.7
1999-03-18 09:06:37 9.4 30.7 49.8 62.0
1999-03-25 09:06:37 6.1 0.0 31.9 60.5
1999-04-01 09:06:37 1.7 0.0 8.5 52.4
1999-04-08 10:06:37 10.0 47.2 49.8 52.4
1999-04-15 10:06:37 10.0 48.2 49.7 52.4
1999-04-22 10:06:37 10.0 48.0 49.7 52.1
1999-04-29 10:06:37 10.0 47.6 49.8 52.7
1999-05-06 10:06:37 10.0 46.7 49.7 60.3
1999-05-13 10:06:37 10.0 46.7 51.9 90.4
1999-05-20 10:06:37 10.0 48.1 53.5 100.4
1999-05-27 10:06:37 10.0 40.7 50.0 93.7
1999-06-03 10:06:37 10.0 40.0 44.3 54.7
1999-06-10 10:06:37 10.0 39.9 41.2 56.3
1999-06-17 10:06:37 10.0 40.0 41.1 56.3
1999-06-24 10:06:37 10.0 39.0 41.1 50.7
1999-07-01 10:06:37 10.0 39.5 40.5 48.2
1999-07-08 10:06:37 10.0 40.0 40.7 44.6
1999-07-15 10:06:37 10.0 41.0 42.6 48.2
1999-07-22 10:06:37 10.0 43.0 43.3 48.2
1999-07-29 10:06:37 10.0 41.0 42.5 61.6
1999-08-05 10:06:37 10.0 40.9 41.8 61.6
1999-08-12 10:06:37 9.6 34.5 39.7 47.0
1999-08-19 10:06:37 10.0 39.9 40.3 46.3
1999-08-26 10:06:37 10.0 39.9 40.3 48.0
1999-09-02 10:06:37 10.0 39.6 40.6 54.9
1999-09-09 10:06:37 9.8 39.9 48.0 70.5
1999-09-16 10:06:37 9.9 44.5 50.0 58.1
1999-09-23 10:06:37 9.9 46.4 49.9 58.0
1999-09-30 10:06:37 9.9 46.0 50.1 62.3
1999-10-07 10:06:37 9.9 46.8 50.0 56.9
1999-10-14 10:06:37 9.8 39.1 47.1 56.4
1999-10-21 10:06:37 10.0 38.9 47.0 59.9
1999-10-28 10:06:37 9.7 6.2 47.0 59.1
1999-11-04 09:06:37 9.9 46.0 50.8 126.1
1999-11-11 09:06:37 10.0 39.3 51.7 179.6
1999-11-18 09:06:37 9.9 37.4 49.7 169.7
1998-11-19 09:06:37 9.6 0.0 45.3 103.7


[
Top] [Remstats] [SourceWorks] [RRDtool] [SourceForge]
Last updated Fri Sep 5 07:34:20 UTC 2003 by <terskine@users.sourceforge.net>.