SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then
View previous thread::View next thread

Alert commands

Edit this page
System · Related pages
Posted: 2026-09-16 · Report this thread
brandon Site Admin brandon profile Posts: 96
sqlstreams alert latest partition_count --stream payments.requested

Reads recorded alerts, including resolved reports. These commands do not run a check or evaluate current evidence. Use the Go Snapshot API for an on-demand evaluation.

List reports

sqlstreams alert list [--stream <name>] [--consumer <group>] [--quiet]

Lists one retained report per alert name and owner. Without owner flags, lists reports across the installation.

Flag Default Effect
--stream All owners Only reports owned by this stream.
--consumer No group filter Only reports owned by this group. Requires --stream.
--quiet, -q false Print alert name and owner, one pair per line. Cannot be combined with JSON output.

JSON returns an array of Alert objects. A successful empty list exits 0, with JSON []. A requested owner that is absent exits 1.

Latest and history

sqlstreams alert latest <name> [--stream <name>] [--consumer <group>]
sqlstreams alert history <name> [--stream <name>] [--consumer <group>] [--limit 10]
sqlstreams alert history worker_liveness --stream payments.requested --limit 5
sqlstreams alert latest metrics_collector_progress

These commands select one owner. With no owner flags, they select the system. --stream selects a stream, and --stream plus --consumer selects a group. history’s positive limit defaults to 10 and returns newest message ids first.

Result latest JSON history JSON Exit status
Retained report found One Alert object. Array of Alert objects. 0
Owner exists but no report is retained null. []. 1
Owner is absent or a database read fails Error document on stderr. Error document on stderr. 1
Invalid owner flags or limit Usage error on stderr. Usage error on stderr. 2

A resolved report still counts as found. No report does not establish health.

Built-in owners

Alert name Required owner selection
partition_count --stream.
compaction_read_cost --stream.
worker_liveness --stream, even when the report identifies consumer-group workers.
metrics_collector_progress No owner flags.

There are no built-in group-owned alerts. Selecting the wrong existing owner can therefore return no report even when another owner has an active alert.

The team