turbot/updown

steampipe plugin install updownsteampipe plugin install updown
On This Page
Get Involved

Table: updown_metric_hour

Hourly metrics collected for the given check. Results are limited to the last month only.

Note: The token field must be set in the where clause.

Examples

List all metrics by hour

select
*
from
updown_metric_hour
where
token = '3sdv'
order by
timestamp desc

List all metric periods where the total time was greater than 400ms

select
timestamp,
timings ->> 'total' as timing_total
from
updown_metric_hour
where
token = '3sdv'
and (timings ->> 'total')::int > 400
order by
timestamp desc

Percentage of samples responding under 1 second

select
100 * (requests -> 'by_response_time' -> 'under1000')::int / (requests -> 'samples')::float as req_under_1sec
from
updown_metric_hour
where
token = '3sdv'
order by
timestamp desc

.inspect updown_metric_hour

Get detailed metrics about a check. Statistic are aggregated per hour. For example all requests performed between 5:00 and 5:59 will be reported at 5:00 in this API. The time range needs to be at least one hour to get data.

NameTypeDescription
apdexdouble precisionTODO
hostjsonbHost where the check was made.
requestsjsonbRequest statistics.
timestamptimestamp without time zoneThe time (hour) that the metrics are for.
timingsjsonbTiming statistics.
tokentextUnique token of the check.