SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then

Read consumer worker settings

Edit this page
Consumer · Related pages
Posted: 2026-09-16 · Report this thread
brandon Site Admin brandon profile Posts: 96
Workers(ctx context.Context) ([]*Worker, error)

Reads the worker declarations owned by a consumer group. These are stored settings shared by the group’s instances.

Example

Inspect the charge-cards group on the payments.requested stream using an initialized client.

payments := client.Stream[sqlstreams.RawPayload]("payments.requested")
workers, err := payments.Consumer("charge-cards").Workers(ctx)
if err != nil {
return err
}
for _, worker := range workers {
fmt.Println(worker.Name, worker.TargetInstances, worker.Metadata)
}

Parameters

Parameter Type Required Description
ctx context.Context Yes Cancellation or its deadline interrupts the read.

Returns

Condition Return value
Read succeeds (workers, nil), where workers contains Worker objects. The slice can be empty.
Stream or group is absent (nil, err) with the corresponding not-found error.
Read fails (nil, err).

Worker

Field Type JSON name Description
Id int64 id Worker registration id.
Name string worker Worker kind, such as message_consumer.
Owner *Owner owner Resource owning the worker declaration.
Metadata any metadata Stored configuration, with worker-specific fields and omitted defaults.
TargetInstances InstanceTarget target_instances Allowed concurrent instances across the deployment. Zero means suspended, a positive value sets a limit, and NoInstanceTarget (-1) removes the limit.

Owner

Field Type JSON name Description
SystemId int64 system_id Owning system id.
StreamId int64 stream_id Owning stream id. Zero for system ownership.
ConsumerGroupId int64 group_id Owning group id. Zero unless the owner is a group.
Name string owner System, stream, or group name.

Owner.Kind returns OwnerSystem, OwnerStream, or OwnerConsumerGroup from the deepest populated id. InstanceTarget.Suspended reports whether the target is zero.

CLI

sqlstreams consumer worker list payments.requested charge-cards

Prints stored configuration keys and the worker declaring each one. An optional third argument selects a key. --output json returns the CLI’s configuration-key view, not the raw Worker slice.

Errors

Error When
Validation error The stream or group name is empty.
ErrStreamNotFound The stream is absent.
ErrConsumerNotFound The group is absent.
Database or context error The read fails or is interrupted.