Statsd & Graphite - get data as CSV

export-to-csv graphite statsd
Pavel S. picture Pavel S. · Jan 24, 2014 · Viewed 9.7k times · Source

I use statsd for measuring stats and Graphite for displaying these. Anyway, I would like to do a more sophisticated analysis in statistical software, to find out the relations between various variables.

In order to do this, I need the "raw" data, which are usually displayed in Graphite as color lines. Is it possible to get the data in CSV format? Data sampled to 1 entry per 10 seconds will be perfect, and that's statsd default behavior, I think.

Answer

erbdex picture erbdex · Jan 26, 2014

Yes. And it is straightforward.

Server: graphite.example.com
Metric: Graphite.system.data.ip-10-0-0-1.load

As you might be aware, Graphite has a URL API. 

graphite.example.com/render/?target=Graphite.system.data.ip-10-0-0-1.load

Returns the line-graph. To get data in csv or even json, append- &format=json

graphite.example.com/render/?target=Graphite.system.data.ip-10-0-0-1.load&format=csv

Related questions

How to export table as CSV with headings on Postgresql?

I'm trying to export a PostgreSQL table with headings to a CSV file via command line, however I get it to export to CSV file, but without headings. My code looks as follows: COPY products_273 to '/tmp/products_199.csv' …

Read More
How to create and download a csv file from php script?

I am a novice programmer and I searched a lot about my question but couldn't find a helpful solution or tutorial about this. My goal is I have a PHP array and the array elements are showing in a list …

Read More
Java - Writing strings to a CSV file

I am trying to write data to a csv file with java, however when I try opening the produced file with excel I am getting an error saying the file is corrupt. Upon opening the file in notepad it looks …

Read More