SQLStreams

the messaging platform that is just Postgres

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

0702 — Instance log timestamps follow existing names

Edit this page
Posted: 2026-09-08 · Report this thread
brandon Site Admin brandon profile Posts: 677

Context

The user asked that worker_instance_log follow existing log-table timestamp names. This supersedes the timestamp names in 0701; its write and retention contracts remain unchanged.

Decision

  • Keep created_at as the copied worker_instance creation timestamp.
  • Use attempted_at for the successful claim or renewal transaction’s timestamp, following the existing binding_config_log distinction between an original timestamp and an attempt timestamp.
  • Remove the names instance_created_at and recorded_at. No values are derived differently, and expiry-based cleanup does not change.

Consequences

Snapshot fields retain their source names. Fresh baseline creation and the snapshot insert agree on those names; existing development tables using the previous names require recreation or a local column rename.