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
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 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.
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,0This line means that at the beginning of the test, for the first 15 seconds, there were no failed requests for the home_page transaction.