Table: updown_check - Query Updown.io Checks using SQL

Updown.io is a website monitoring service that checks your website's status every few seconds from different locations around the world. It provides detailed reports of uptime, downtime, and performance metrics. This service helps you stay informed about the health and performance of your website and take appropriate actions when predefined conditions are met.

Table Usage Guide

The updown_check table provides insights into Checks within Updown.io. As a Site Reliability Engineer, explore check-specific details through this table, including uptime, downtime, and associated metadata. Utilize it to uncover information about checks, such as those with significant downtime, the performance metrics of each check, and the verification of uptime reports.

Examples

List all checks

Explore all monitoring checks in your system to better understand the health and performance of your digital assets. This can help you proactively identify potential issues and rectify them before they escalate.

select
  *
from
  updown_check;

select
  *
from
  updown_check;

Get a check by token

Discover the segments that correspond to a specific identifier in order to analyze and manage system checks more efficiently. This can be useful in pinpointing specific checks for troubleshooting or system optimization.

select
  *
from
  updown_check
where
  token = 'sdfw';

select
  *
from
  updown_check
where
  token = 'sdfw';

List checks that are currently down

Identify instances where certain checks are currently down. This can assist in promptly addressing and rectifying any issues that might be affecting system performance or functionality.

select
  *
from
  updown_check
where
  down;

select
  *
from
  updown_check
where
  down = 1;

Schema for updown_check

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
alias	text		Alias for the check.
apdex_threshold	double precision		APDEX (Application Performance Index) threshold in seconds (0.125, 0.25, 0.5, 1.0 or 2.0).
disabled_locations	jsonb		Disabled monitoring locations. It's an array of abbreviated location names. Can be any of these: lan, mia, bhs, rbx, fra, sin, tok, syd.
down	boolean		True if the URL is down.
down_since	timestamp with time zone		The URL has been down since this time. Null if the URL is up.
enabled	boolean		True if the check is enabled.
error	text		Error from the check, if any.
favicon_url	text		Favicon for the URL.
last_check_at	timestamp with time zone		Time of the last check.
last_status	bigint		Last status of the check.
mute_until	timestamp with time zone		Check is muted until this time.
next_check_at	timestamp with time zone		Time when the next check will be performed.
period	bigint		Interval in seconds (15, 30, 60, 120, 300, 600, 1800 or 3600).
published	boolean		True if the status of the check is public.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
ssl	jsonb		SSL information.
token	text	=	The check unique token.
uptime	double precision		Uptime (percentage) for the check.
url	text		The URL being monitored.

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_check