Table: prometheus_alert - Query Prometheus Alerts using SQL

Prometheus is an open-source systems monitoring and alerting toolkit. It provides a multi-dimensional data model with time series data identified by metric name and key/value pairs. Alerts in Prometheus sends notifications to external systems when certain conditions are observed in the monitored system.

Table Usage Guide

The prometheus_alert table provides insights into active alerts within Prometheus. As a system administrator or DevOps engineer, explore alert-specific details through this table, including alert name, severity, and associated metadata. Utilize it to uncover information about active alerts, such as those with high severity, the conditions that triggered the alerts, and the duration for which the alerts have been active.

Examples

List all alerts

Gain insights into all the alerts currently active in your system. This can be useful for monitoring system health and responding quickly to any issues.

select
  *
from
  prometheus_alert;

select
  *
from
  prometheus_alert;

Alerts with a labeled severity of high

Identify instances where alerts have been marked with a high severity level. This can be useful in prioritizing responses to potential issues within your system.

select
  *
from
  prometheus_alert
where
  labels ->> 'severity' = 'high';

select
  *
from
  prometheus_alert
where
  json_extract(labels, '$.severity') = 'high';

Alerts that became active in the last 5 mins

Discover the alerts that have been activated recently, allowing you to respond promptly to any potential issues or threats. This can be particularly beneficial in real-time monitoring and incident response scenarios.

select
  *
from
  prometheus_alert
where
  active_at > now() - interval '5 min';

select
  *
from
  prometheus_alert
where
  active_at > datetime('now', '-5 minutes');

Schema for prometheus_alert

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form.
active_at	timestamp with time zone	Timestamp when the alert became active.
annotations	jsonb	Annotations set on the alert rule.
labels	jsonb	Labels set on the metric.
sp_connection_name	text	Steampipe connection name.
sp_ctx	jsonb	Steampipe context in JSON form.
state	text	State of the metric, e.g. firing.
value	double precision	Value of the metric.

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)" -- prometheus

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

steampipe_export_prometheus --config '<your_config>' prometheus_alert