CSV formatter
The CSV formatter presents results of database queries in the following formats:
| format | content type | description |
|---|---|---|
csv | text/plain | a text table, comma separated, with a header line (dimension names) and \r\n at the end of the lines |
csvjsonarray | application/json | a JSON array, with each row as another array (the first row has the dimension names) |
tsv | text/plain | like csv but TAB is used instead of comma to separate values (MS Excel flavor) |
html | text/html | an html table |
markdown | text/plain | markdown table |
In all formats the date and time is the first column.
The CSV formatter respects the following API &options=:
| option | supported | description |
|---|---|---|
nonzero | yes | to return only the dimensions that have at least a non-zero value |
flip | yes | to return the rows older to newer (the default is newer to older) |
seconds | yes | to return the date and time in unix timestamp |
ms | yes | to return the date and time in unit timestamp as milliseconds |
percent | yes | to replace all values with their percentage over the row total |
abs | yes | to turn all values positive |
null2zero | yes | to replace gaps with zeros (the default prints the string null |
Examples#
Get the system total bandwidth for all physical network interfaces, over the last hour,
in 6 rows (one for every 10 minutes), in csv format:
Netdata always returns bandwidth in kilobits.
Get the max RAM used by the SQL server and any cron jobs, over the last hour, in 2 rows (one for every 30
minutes), in tsv format, and format the date and time as unix timestamp:
Netdata always returns memory in MB.
Get an HTML table of the last 4 values (4 seconds) of system CPU utilization:
Netdata always returns CPU utilization as %.
This is how it looks when rendered by a web browser:
Get a JSON array with the average bandwidth rate of the mysql server, over the last hour, in 6 values (one every 10 minutes), and return the date and time in milliseconds:
Netdata always returns bandwidth rates in kilobits/s.
Get the number of processes started per minute, for the last 10 minutes, in markdown format:
And this is how it looks when formatted:
| time | started |
|---|---|
| 2018-10-27 03:52:00 | 245.1706149 |
| 2018-10-27 03:51:00 | 152.6654636 |
| 2018-10-27 03:50:00 | 163.1755789 |
| 2018-10-27 03:49:00 | 176.1574766 |
| 2018-10-27 03:48:00 | 178.0137076 |
| 2018-10-27 03:47:00 | 183.8306543 |
| 2018-10-27 03:46:00 | 264.1635621 |
| 2018-10-27 03:45:00 | 205.001551 |
| 2018-10-27 03:44:00 | 7026.9852167 |
| 2018-10-27 03:43:00 | 205.9904794 |