Skip to main content
Version: Nightly

Alerts

NOTE

This feature is only available in the GreptimeDB Enterprise database.

The ALERTS table provides the information about all alert instances generated by triggers.

DESC TABLE INFORMATION_SCHEMA.ALERTS;
+--------------+---------------------+------+------+---------+---------------+
| Column       | Type                | Key  | Null | Default | Semantic Type |
+--------------+---------------------+------+------+---------+---------------+
| trigger_id   | UInt64              |      | NO   |         | FIELD         |
| trigger_name | String              |      | NO   |         | FIELD         |
| labels       | Json                |      | NO   |         | FIELD         |
| annotations  | Json                |      | YES  |         | FIELD         |
| status       | String              |      | NO   |         | FIELD         |
| active_at    | TimestampNanosecond |      | NO   |         | FIELD         |
| fired_at     | TimestampNanosecond |      | YES  |         | FIELD         |
| resolved_at  | TimestampNanosecond |      | YES  |         | FIELD         |
| last_sent_at | TimestampNanosecond |      | YES  |         | FIELD         |
+--------------+---------------------+------+------+---------+---------------+

The columns in table:

  • trigger_id: the id of the trigger that generated the alert instance.
  • trigger_name: the name of the trigger that generated the alert instance.
  • labels: the key-value pairs associated with the alert instance. And the label set uniquely identifies an alert instance.
  • annotations: the key-value pairs associated with the alert instance.
  • status: the current status of the alert instance.
  • active_at: the timestamp when the alert instance became active.
  • fired_at: the timestamp when the alert instance first entered the Firing state.
  • resolved_at: the timestamp when the alert instance was resolved.
  • last_sent_at: the timestamp when the last notification for the alert instance was sent.