Skip to main content

SSV formatter

The SSV formatter sums all dimensions in results of database queries to a single value and returns a list of such values showing how it changes through time.

It supports the following formats:

formatcontent typedescription
ssvtext/plaina space separated list of values
ssvcommatext/plaina comma separated list of values
arrayapplication/jsona JSON array

The SSV formatter respects the following API &options=:

optionsupporteddescription
nonzeroyesto return only the dimensions that have at least a non-zero value
flipyesto return the numbers older to newer (the default is newer to older)
percentyesto replace all values with their percentage over the row total
absyesto turn all values positive, before using them
min2maxyesto return the delta from the minimum value to the maximum value (across dimensions)

Examples

Get the average system CPU utilization of the last hour, in 6 values (one every 10 minutes):

# curl -Ss 'https://registry.my-netdata.io/api/v1/data?chart=system.cpu&format=ssv&after=-3600&points=6&group=average'
1.741352 1.6800467 1.769411 1.6761112 1.629862 1.6807968

Get the total mysql bandwidth (in + out) for the last hour, in 6 values (one every 10 minutes):

Netdata returns bandwidth in kilobits.

# curl -Ss 'https://registry.my-netdata.io/api/v1/data?chart=mysql_local.net&format=ssvcomma&after=-3600&points=6&group=sum&options=abs'
72618.7936215,72618.778889,72618.788084,72618.9195918,72618.7760612,72618.6712421

Get the web server max connections for the last hour, in 12 values (one every 5 minutes) in a JSON array:

# curl -Ss 'https://registry.my-netdata.io/api/v1/data?chart=nginx_local.connections&format=array&after=-3600&points=12&group=max'
[278,258,268,239,259,260,243,266,278,318,264,258]

Was this page helpful?

Need further help?

Search for an answer in our community forum.

Contribute