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_alertwhere labels ->> 'severity' = 'high';
select *from prometheus_alertwhere 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_alertwhere active_at > now() - interval '5 min';
select *from prometheus_alertwhere active_at > datetime('now', '-5 minutes');
Schema for prometheus_alert
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
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. | |
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