CSV Results

How to download and interpret CSV Results

The CSV results file forms the basis of charts in the UI, and can be downloaded at the completion of a flood load test by clicking on the gear icon and selecting CSV Results.​

You can then download the resulting CSV file. When you open it up in your text editor, it will look something like this:

Time,Elapsed Time,Account UUID,Project UUID,Project,Stream UUID,Stream,Flood UUID,Flood,Region,Measurement,Label,Value
2020-01-03 13:40:45,0,LVEISdfIkNA,1RgBAcD8IRZU6gNDE8FIOsEbfoc,JMeter,1VnQoeGRefMjYt4JEAd703j16Ae,JMeter Sample,oIV68RO9rm1f1WFqvJk54A,JMeter Sample 2,us-east-1,concurrent_users,"",1
2020-01-03 13:41:00,15,LVEISdfIkNA,1RgBAcD8IRZU6gNDE8FIOsEbfoc,JMeter,1VnQoeGRefMjYt4JEAd703j16Ae,JMeter Sample,oIV68RO9rm1f1WFqvJk54A,JMeter Sample 2,us-east-1,concurrent_users,"",1
2020-01-03 13:41:15,30,LVEISdfIkNA,1RgBAcD8IRZU6gNDE8FIOsEbfoc,JMeter,1VnQoeGRefMjYt4JEAd703j16Ae,JMeter Sample,oIV68RO9rm1f1WFqvJk54A,JMeter Sample 2,us-east-1,concurrent_users,"",1

Headers

The CSV results file has the following headers:

  • Time: the date and time of the measurement

  • Elapsed Time: the amount of time relative to the beginning of the flood

  • Account UUID: unique identifier of the account from which the flood was executed

  • Project UUID: unique identifier of the project to which the flood belongs

  • Project: name of the project

  • Stream UUID: unique identifier of the stream from which the flood was started

  • Stream: name of the stream

  • Flood UUID: unique identifier of the flood

  • Flood: name of the flood

  • Region: geographical region of the grid node

  • Measurement: string to indicate what value is being measured.

  • Label: string to indicate if this is a specific transaction measurement or a global measurement (__all).

  • Value: integer result of the measurement, aggregated (see below)

Values

Values are context-sensitive to measurements, and are recorded for the measured period (15 seconds) as follows:

  • failed is the sum total of failed transactions.

  • passed is the sum total of passed transactions.

  • response_time is the average response time in milliseconds.

  • concurrency is the maximum concurrent users of all transactions.

  • throughput is the sum total of bytes of all transactions.

  • transaction_rate is the sum total of all transactions.

Example

Let's have a look at this sample from the CSV results of a flood:

2020-01-03 13:40:45,0,LVEISdfIkNA,1RgBAcD8IRZU6gNDE8FIOsEbfoc,JMeter,1VnQoeGRefMjYt4JEAd703j16Ae,JMeter Sample,oIV68RO9rm1f1WFqvJk54A,JMeter Sample 2,us-east-1,failed,home_page,0

This line means that at the beginning of the test, for the first 15 seconds, there were no failed requests for the home_page transaction.