Table: updown_downtime - Query Updown Downtime using SQL

Updown Downtime is a component of the Updown.io monitoring service that records periods of service unavailability or downtime. It provides specific start and end times, the error ratio, and the checks that were affected during these periods. This information can be critical in understanding and addressing service disruptions and maintaining optimal service performance.

Table Usage Guide

The updown_downtime table provides insights into service downtime within Updown.io. As a Site Reliability Engineer, explore downtime-specific details through this table, including start and end times, error ratios, and affected checks. Utilize it to uncover information about service disruptions, such as their duration, the degree of service impact, and the specific checks that were affected.

Important Notes

You must specify the token in the where clause to query this table.

Examples

List all downtimes

Discover the segments that have experienced downtimes in a specific area, ordered chronologically in reverse. This can help identify recurring issues and prioritize areas for improvement.

select
  *
from
  updown_downtime
where
  token = '3sdv'
order by
  started_at desc;

select
  *
from
  updown_downtime
where
  token = '3sdv'
order by
  started_at desc;

Schema for updown_downtime

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
duration	bigint		Duration of the downtime.
ended_at	timestamp with time zone		Time when the downtime ended.
error	text		Error from the downtime, if any.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
started_at	timestamp with time zone		Time when the downtime started.
token	text	=	Unique token of the check.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- updown

You can pass the configuration to the command with the --config argument:

steampipe_export_updown --config '<your_config>' updown_downtime