consumer_groups


Description

{“what”:“A consumer group with a single shared offset for its members.”,“why”:“Without it, consumer progress cannot be persisted across restarts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:21.860390688+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id text 2147483647 null

{“what”:“Unique name that identifies the consumer group.”,“why”:“Primary key; needed to address the group when reading or updating its offset.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:21.908783708+00:00”}

last_offset int8 19 0

{“what”:“Highest committed message offset, starting at 0.”,“why”:“Without it, consumers would not know where to resume after a restart.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:22.041739439+00:00”}

created_at text 2147483647 null

{“what”:“Creation timestamp of the group, stored as text.”,“why”:“Without it, the group’s age cannot be determined for lifecycle management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:22.147706688+00:00”}

updated_at text 2147483647 null

{“what”:“Last modification timestamp of the group, stored as text.”,“why”:“Without it, staleness of the offset cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:22.273305964+00:00”}

Indexes

Constraint Name Type Sort Column(s)
consumer_groups_pkey Primary key Asc group_id

Relationships