Aggregate(1) Manual Page

Input

Records to aggregate over time.

Output

Records with aggregated data.

Aggregates records over time, i.e. takes record sets and determines aggregated values (sum, count, min, max, average) during predefined time periods.

You would like to determine how many times a given host has been requested on your web site and the average response time for a request.

This can be achieved by following these steps:

1. Make sure your Aggregate tool receives an input containing the fields host and time_taken.

2. Select host in the Keys field, time_taken in the Avg field and make sure the Include count box is checked.

3. Specify how many seconds you wish to aggregate your data over in the Duration in sec field.

4. Save the output of the Aggregate tool in a database table.

5. When you analyze the database table containing the output of the Aggregate tool, you can see numbers indicating the average response time and number of requests over a time interval.

The data could look something like this:

This has the following interpretation: The host www.my_site.com has been requested 348 times during the defined time interval and the average response time was 0.0015587 seconds.

Duration in sec

Time period in seconds to aggregate over.

Keys

Fields to be used as keys during the aggregation. The more fields selected here, the higher the CPU load on this tool will be.

Avg

Fields, which will get average values assigned.

Max

Fields, which will get maximum integer values assigned.

Min

Fields, which will get minimum integer values assigned.

Sum

Fields, which will get summarized integer values assigned.

Include count

Number of entries.