SQL Introspection API

This page contains the reference of the introspection tables. To learn how to access the introspection interface, check out the introspection documentation.

Table: `sys_deployment`

Registered deployments. A deployment is a version of your service(s) code that Restate calls.

Column name	Type	Description
`id`	`Utf8`	The ID of the service deployment.
`ty`	`Utf8`	The type of the endpoint. Either `http` or `lambda`.
`endpoint`	`Utf8`	The address of the endpoint. Either HTTP URL or Lambda ARN.
`created_at`	`TimestampMillisecond`	Timestamp indicating the deployment registration time.
`min_service_protocol_version`	`UInt32`	Minimum supported protocol version.
`max_service_protocol_version`	`UInt32`	Maximum supported protocol version.
`services`	`Utf8 List`	List of service names registered by this deployment.

Table: `sys_inbox`

Invocations queued for a Virtual Object or Workflow key. Only one invocation runs at a time per key; the others wait here, ordered by sequence_number.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning the services invocations. Can be ignored.
`service_name`	`Utf8`	The name of the invoked virtual object/workflow.
`service_key`	`Utf8`	The key of the virtual object/workflow.
`id`	`Utf8`	Invocation ID.
`sequence_number`	`UInt64`	Sequence number in the inbox.
`created_at`	`TimestampMillisecond`	Timestamp indicating the start of this invocation. DEPRECATED: you should not use this field anymore, but join with the sys_invocation table

Table: `sys_journal`

Journal entries of invocations. The journal records the steps an invocation took (calls, sleeps, state access, promises, …), one row per entry, ordered by index.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning the services invocations. Can be ignored.
`id`	`Utf8`	Invocation ID.
`index`	`UInt32`	The index of this journal entry.
`entry_type`	`Utf8`	The entry type. You can check all the available entry types in `entries.rs`.
`name`	`Utf8`	The name of the entry supplied by the user, if any.
`completed`	`Boolean`	Indicates whether this journal entry has been completed; this is only valid for some entry types.
`invoked_id`	`Utf8`	If this entry represents an outbound invocation, indicates the ID of that invocation.
`invoked_target`	`Utf8`	If this entry represents an outbound invocation, indicates the invocation Target. Format for plain services: `ServiceName/HandlerName`, e.g. `Greeter/greet`. Format for virtual objects/workflows: `VirtualObjectName/Key/HandlerName`, e.g. `Greeter/Francesco/greet`.
`sleep_wakeup_at`	`TimestampMillisecond`	If this entry represents a sleep, indicates wakeup time.
`promise_name`	`Utf8`	If this entry is a promise related entry (GetPromise, PeekPromise, CompletePromise), indicates the promise name.
`raw`	`Binary`	Raw binary representation of the entry. Check the service protocol for more details to decode it.
`raw_length`	`UInt64`	The byte length of the raw entry. If you are writing a query that only needs to know the length, reading this field will be much more efficient than reading length(raw).
`version`	`UInt32`	The journal version.
`entry_json`	`Utf8`	The entry serialized as a JSON string. Filled only if journal version is 2.
`entry_lite_json`	`Utf8`	The EntryLite projection serialized as a JSON string. Filled only if journal version is 2.
`appended_at`	`TimestampMillisecond`	When the entry was appended to the journal. Filled only if journal version is 2.

Table: `sys_journal_events`

Events that happened during an invocation’s execution. Events are transient errors, pauses and suspensions. They are not journal entries; use after_journal_entry_index to place them between them.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning the services invocations. Can be ignored.
`id`	`Utf8`	Invocation ID.
`after_journal_entry_index`	`UInt32`	The journal index after which this event happened. This can be used to establish a total order between events and journal entries.
`appended_at`	`TimestampMillisecond`	When the entry was appended to the journal.
`event_type`	`Utf8`	The event type.
`event_json`	`Utf8`	The event serialized as a JSON string.

Table: `sys_locks`

Locks currently held on Virtual Object keys. One row per lock, with when it was acquired and the invocation (or other operation) holding it.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning. Can be ignored.
`scope`	`Utf8`	The scope of this lock. Only present if this is a scoped lock (i.e. a lock of a scoped virtual object).
`lock_name`	`Utf8`	The name of the lock (in the format of `service/key`)
`acquired_at`	`TimestampMillisecond`	Timestamp of lock acquisition
`acquired_by`	`Utf8`	The invocation (or other operation) that acquired this lock.

Table: `sys_promise`

Durable promises of Workflows. One row per promise of a workflow instance, with its completion value or failure once completed.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning the services invocations. Can be ignored.
`scope`	`Utf8`	The scope of the workflow instance, if scoped. NULL for unscoped entries. Since v1.7.0
`service_name`	`Utf8`	The name of the workflow service.
`service_key`	`Utf8`	The workflow ID.
`key`	`Utf8`	The promise key.
`completed`	`Boolean`	True if the promise was completed.
`completion_success_value`	`Binary`	The completion success, if any.
`completion_success_value_utf8`	`Utf8`	The completion success as UTF-8 string, if any.
`completion_failure`	`Utf8`	The completion failure, if any.

Table: `sys_rules`

Rules that limit concurrency. Each rule matches invocations by pattern and can cap how many of them run at the same time.

Column name	Type	Description
`pattern`	`Utf8`	Rule pattern in canonical display form (e.g. `scope/*/tenant`).
`concurrency`	`UInt32`	Concurrency limit imposed by this rule. Null means the rule does not constrain concurrency.
`description`	`Utf8`	Free-form description set by the operator.
`disabled`	`Boolean`	True when the rule is parked (treated as absent at runtime).
`version`	`UInt32`	Per-rule version, bumped on runtime-relevant changes.
`last_modified`	`TimestampMillisecond`	Last modification time.

Table: `sys_scheduler`

Scheduler state of each vqueue. Shows whether a vqueue is dormant, blocked or scheduled, what its head entry is waiting on, and how long it waited on each resource.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning. Can be ignored.
`id`	`Utf8`	Identifier of the scheduled vqueue (vq_…).
`num_inbox`	`UInt64`	Number of entries currently waiting in the inbox stage.
`status`	`Utf8`	High-level scheduler state (dormant, blocked, scheduled, …).
`head_entry_id`	`Utf8`	Identifier of the head entry if the scheduler has already advanced to it. Null when the head has not yet been materialized
`scheduled_at`	`TimestampMillisecond`	Earliest time when the head entry becomes runnable. Set only when status is `Scheduled`.
`blocked_on`	`Utf8`	The current resource blocking the queue from dequeuing.
`blocked_on_json`	`Utf8`	Detailed blocking resource when status is `blocked`.
`invoker_concurrency_block_duration`	`DurationMillisecond`	Time the head entry spent waiting on global invoker concurrency.
`throttling_rules_block_duration`	`DurationMillisecond`	Time the head entry spent waiting on user-defined per-vqueue throttling rules.
`invoker_throttling_block_duration`	`DurationMillisecond`	Time the head entry spent waiting on node-level invoker throttling.
`invoker_memory_block_duration`	`DurationMillisecond`	Time the head entry spent waiting on invoker memory pool capacity.
`concurrency_rules_block_duration`	`DurationMillisecond`	Time the head entry spent waiting on user-defined concurrency rules.
`lock_block_duration`	`DurationMillisecond`	Time the head entry spent waiting on virtual-object locks.
`deployment_concurrency_block_duration`	`DurationMillisecond`	Time the head entry spent waiting on deployment-level concurrency capacity.

Table: `sys_service`

Registered services. One row per service, with its type, whether it is public, and the latest deployment serving it.

Column name	Type	Description
`name`	`Utf8`	The name of the registered user service.
`revision`	`UInt64`	The latest deployed revision.
`public`	`Boolean`	Whether the service is accessible through the ingress endpoint or not.
`ty`	`Utf8`	The service type. Either `service` or `virtual_object` or `workflow`.
`deployment_id`	`Utf8`	The ID of the latest deployment

Table: `state`

State of Virtual Objects and Workflows. One row per state key of each Virtual Object or Workflow instance.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning the services invocations. Can be ignored.
`scope`	`Utf8`	The scope of the Virtual Object instance, if scoped. NULL for unscoped entries. Since v1.7.0
`service_name`	`Utf8`	The name of the invoked service.
`service_key`	`Utf8`	The key of the Virtual Object.
`key`	`Utf8`	The `utf8` state key.
`key_length`	`UInt64`	The byte length of the state key. If you are writing a query that only needs to know the length, reading this field will be much more efficient than reading octet_length(key).
`value_utf8`	`Utf8`	Only contains meaningful values when a service stores state as `utf8`. This is the case for services that serialize state using JSON (default for Typescript SDK, Java/Kotlin SDK if using JsonSerdes).
`value`	`Binary`	A binary, uninterpreted representation of the value. You can use the more specific column `value_utf8` if the value is a string.
`value_length`	`UInt64`	The byte length of the value. If you are writing a query that only needs to know the length, reading this field will be much more efficient than reading length(value).

Table: `sys_user_limits`

Counters of the concurrency limits set by rules. One row per counter, with its current usage, its limit, the rule defining it and how many vqueues are waiting on it.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning. Can be ignored.
`scope`	`Utf8`	The scope this counter belongs to.
`l1`	`Utf8`	The level-1 key component (null for scope-level counters).
`l2`	`Utf8`	The level-2 key component (null for scope-level and L1-level counters).
`level`	`Utf8`	The hierarchy level: “Scope”, “Level1”, or “Level2”.
`usage`	`UInt32`	Current concurrency usage at this counter.
`concurrency_limit`	`UInt32`	The configured concurrency limit (null if unlimited).
`rule_pattern`	`Utf8`	The rule pattern that defines the limit (null if unlimited). Resolved from the rule handle; shows “[removed]” if the rule was deleted since the counter was created.
`available`	`UInt32`	Available capacity (limit - usage). Null if unlimited.
`num_waiters`	`UInt64`	Number of vqueues currently waiting behind this counter.

Table: `sys_vqueue_entry_status`

Status of every vqueue entry. One row per entry (an invocation or a state mutation), with its stage, its attempts and how long it was blocked on each resource.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning. Can be ignored.
`entry_id`	`Utf8`	Identifier of the entry. Due to quirks in DataFusion, this should remain `LargeUtf8` to match `id` in `sys_invocation_status` for dynamic filter pushdown.
`vqueue_id`	`Utf8`	The VQueue Identifier (vq_…).
`stage`	`Utf8`	The stage this entry currently belongs to. Choices are ‘inbox’, ‘running’, ‘paused’, ‘suspended’, and ‘finished’.
`status`	`Utf8`	The entry processing status. Examples are `new`, `scheduled`, `started`, `backing-off`, `yielded`, `killed`, `cancelled`, `failed`, and `succeeded`.
`has_lock`	`Boolean`	Whether this entry currently holds a lock.
`next_at`	`TimestampMillisecond`	The next timestamp at which this entry is scheduled for the next transition.
`sequence_number`	`UInt64`	Sequence number encoded in the entry ordering key.
`entry_kind`	`Utf8`	Entry kind (`invocation` or `state-mutation`).
`created_at`	`TimestampMillisecond`	Creation timestamp of the entry.
`transitioned_at`	`TimestampMillisecond`	Timestamp of the latest stage transition.
`num_attempts`	`UInt32`	Number of times this entry has been moved to the run queue.
`num_errors`	`UInt32`	Number of times this entry has yielded execution due to transient errors.
`num_pauses`	`UInt32`	Number of times this entry has been moved to the paused stage.
`num_suspensions`	`UInt32`	Number of times this entry has been moved to the suspended stage.
`num_yields`	`UInt32`	Number of times this entry has yielded execution.
`first_attempt_at`	`TimestampMillisecond`	Timestamp of the first attempt to run this entry.
`latest_attempt_at`	`TimestampMillisecond`	Timestamp of the latest attempt to run this entry.
`first_runnable_at`	`TimestampMillisecond`	The realistic earliest time at which this entry can run its first attempt.
`deployment`	`Utf8`	If set, the entry’s pinned deployment identifier.
`needed_memory`	`UInt64`	If set, the amount of memory in bytes the invocation seems to require on the invoker side.
`retry_attempts`	`UInt32`	Number of retry attempts recorded in the entry metadata.
`retry_count_since_last_stored_command`	`UInt32`	Number of retries since the latest stored command.
`latest_attempt_blocked_on_invoker_concurrency`	`DurationMillisecond`	Time the latest attempt spent waiting on global invoker capacity.
`latest_attempt_blocked_on_throttling_rules`	`DurationMillisecond`	Time the latest attempt spent blocked on user-defined per-vqueue throttling rules.
`latest_attempt_blocked_on_invoker_throttling`	`DurationMillisecond`	Time the latest attempt spent blocked on node-level invoker throttling.
`latest_attempt_blocked_on_invoker_memory`	`DurationMillisecond`	Time the latest attempt spent waiting on the invoker memory pool.
`latest_attempt_blocked_on_concurrency_rules`	`DurationMillisecond`	Time the latest attempt spent waiting on user-defined concurrency limits.
`latest_attempt_blocked_on_lock`	`DurationMillisecond`	Time the latest attempt spent waiting to acquire a virtual object lock.
`latest_attempt_blocked_on_deployment_concurrency`	`DurationMillisecond`	Time the latest attempt spent blocked on deployment concurrency capacity.
`total_blocked_on_invoker_concurrency`	`DurationMillisecond`	Total time spent waiting on global invoker capacity across all attempts.
`total_blocked_on_throttling_rules`	`DurationMillisecond`	Total time spent blocked on user-defined per-vqueue throttling rules across all attempts.
`total_blocked_on_invoker_throttling`	`DurationMillisecond`	Total time spent blocked on node-level invoker throttling across all attempts.
`total_blocked_on_invoker_memory`	`DurationMillisecond`	Total time spent waiting on the invoker memory pool across all attempts.
`total_blocked_on_concurrency_rules`	`DurationMillisecond`	Total time spent waiting on user-defined concurrency limits across all attempts.
`total_blocked_on_lock`	`DurationMillisecond`	Total time spent waiting to acquire a virtual object lock across all attempts.
`total_blocked_on_deployment_concurrency`	`DurationMillisecond`	Total time spent blocked on deployment concurrency capacity across all attempts.

Table: `sys_vqueue_meta`

Metadata and statistics of each vqueue. Number of entries per stage, latest activity timestamps, and moving averages of wait, run and blocking times.

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning. Can be ignored.
`id`	`Utf8`	The VQueue Identifier (vq_…)
`is_active`	`Boolean`	Whether this vqueue is active or not. An active vqueue is a vqueue that is not paused, and has non-finished items.
`queue_is_paused`	`Boolean`	Whether this vqueue is paused.
`service_name`	`Utf8`	Service name linked to this vqueue
`scope`	`Utf8`	The scope of this vqueue.
`limit_key`	`Utf8`	The name of the limit-key assigned to this vqueue
`lock_name`	`Utf8`	The name of the lock (in the format of `service/key`) This is only set if this is a vqueue for a virtual object.
`created_at`	`TimestampMillisecond`	When was this vqueue first created
`last_enqueued_at`	`TimestampMillisecond`	Last timestamp an entry moved into Inbox. This covers items enqueued for the first time only.
`last_start_at`	`TimestampMillisecond`	Last timestamp an entry first transitioned to Run.
`last_attempt_at`	`TimestampMillisecond`	Last timestamp an entry transitioned to Run.
`last_finish_at`	`TimestampMillisecond`	Last timestamp an entry transitioned to Finished.
`avg_queue_duration`	`DurationMillisecond`	Exponential moving average (EMA) of first-attempt queue wait time.
`avg_inbox_duration`	`DurationMillisecond`	Exponential moving average (EMA) of how long entries stayed in inbox.
`avg_run_duration`	`DurationMillisecond`	Exponential moving average (EMA) of how long entries stayed running.
`avg_suspension_duration`	`DurationMillisecond`	Exponential moving average (EMA) of how long entries stayed suspended.
`avg_end_to_end_duration`	`DurationMillisecond`	Exponential moving average (EMA) of end-to-end entry lifetime from first-runnable time to completion. Note that this only tracks entries that were not killed/cancelled or failed/paused.
`avg_blocked_on_concurrency_rules`	`DurationMillisecond`	Exponential moving average (EMA) of time the head item spent blocked on user-defined concurrency rules before entering Running. Sampled on every Inbox → Running transition (every run attempt, including retries).
`avg_blocked_on_invoker_concurrency`	`DurationMillisecond`	Exponential moving average (EMA) of time the head item spent blocked on node-level invoker concurrency tokens before entering Running.
`avg_blocked_on_invoker_throttling`	`DurationMillisecond`	Exponential moving average (EMA) of time the head item spent blocked on node-level invoker throttling before entering Running. Sampled on every Inbox → Running transition (every run attempt, including retries).
`avg_blocked_on_lock`	`DurationMillisecond`	Exponential moving average (EMA) of time the head item spent blocked on a virtual object lock before entering Running.
`num_inbox`	`UInt64`	The number of entries that are in the inbox. The inbox is the priority queue that the scheduler uses to choose which entries to run next.
`num_running`	`UInt64`	The number of entries that are currently running.
`num_suspended`	`UInt64`	The number of entries that are suspended.
`num_paused`	`UInt64`	The number of entries that are paused.
`num_finished`	`UInt64`	The number of entries that have finished processing and are pending deletion or archival.

Table: `sys_vqueues`

Entries of each vqueue, by stage. One row per entry in a vqueue stage (inbox, running, paused, suspended or finished).

Column name	Type	Description
`partition_key`	`UInt64`	Internal column that is used for partitioning. Can be ignored.
`id`	`Utf8`	The VQueue Identifier (vq_…).
`stage`	`Utf8`	The stage this entry currently belongs to. Choices are ‘inbox’, ‘running’, ‘paused’, ‘suspended’, and ‘finished’.
`status`	`Utf8`	The entry processing status. Examples are `new`, `scheduled`, `started`, `backing-off`, `yielded`, `killed`, `cancelled`, `failed`, and `succeeded`. Note that in stages some cases, the status will reflect the old status prior to transitioning into the current stage. We preserve the last known status because it will be useful to know when the entry transitions out of the current stage.
`has_lock`	`Boolean`	Whether this entry currently holds a lock.
`run_at`	`TimestampMillisecond`	The entry will be eligible to run after this timestamp. Only present for entries that are in the stage=inbox.
`sequence_number`	`UInt64`	Sequence number encoded in the queue ordering key.
`entry_id`	`Utf8`	Identifier of the entry. Due to quirks in DataFusion, this should remain `LargeUtf8` to match `id` in `sys_invocation_status` for dynamic filter pushdown.
`entry_kind`	`Utf8`	Entry kind (`invocation` or `state-mutation`).
`created_at`	`TimestampMillisecond`	Creation timestamp of the entry.
`transitioned_at`	`TimestampMillisecond`	Timestamp of the latest stage transition.
`num_attempts`	`UInt32`	Number of times this entry has been moved to the run queue.
`num_errors`	`UInt32`	Number of times this entry has yielded execution due to transient errors.
`num_pauses`	`UInt32`	Number of times this entry has been moved to the paused stage.
`num_suspensions`	`UInt32`	Number of times this entry has been moved to the suspended stage.
`num_yields`	`UInt32`	Number of times this entry has yielded execution.
`first_attempt_at`	`TimestampMillisecond`	Timestamp of the first attempt to run this entry.
`latest_attempt_at`	`TimestampMillisecond`	Timestamp of the latest attempt to run this entry.
`first_runnable_at`	`TimestampMillisecond`	The realistic earliest time at which this entry can run its first attempt.
`deployment`	`Utf8`	If set, the entry’s pinned deployment identifier. Due to quirks in DataFusion, this should remain `LargeUtf8` to match `id` in `sys_deployment` for dynamic filter pushdown.

Table: `sys_invocation`

All invocations, whatever their status. One row per invocation, with its target and caller, lifecycle timestamps, and the retry and failure details of the current attempt.

Column name	Type	Description
`id`	`Utf8`	Invocation ID.
`vqueue_id`	`Utf8`	The VQueue assigned to the the invocation. NULL if invocation was not migrated to vqueues. Since v1.7.0.
`target`	`Utf8`	Invocation Target. Format for plain services: `ServiceName/HandlerName`, e.g. `Greeter/greet`. Format for virtual objects/workflows: `VirtualObjectName/Key/HandlerName`, e.g. `Greeter/Francesco/greet`.
`target_service_name`	`Utf8`	The name of the invoked service.
`target_service_key`	`Utf8`	The key of the virtual object or the workflow ID. Null for regular services.
`target_handler_name`	`Utf8`	The invoked handler.
`target_service_ty`	`Utf8`	The service type. Either `service` or `virtual_object` or `workflow`.
`scope`	`Utf8`	The scope of the invocation for vqueue partitioning, if scoped. NULL for unscoped invocations. Since v1.7.0.
`limit_key`	`Utf8`	The limit key that was used for the invocation. NULL if no limit key was set. Since v1.7.0.
`idempotency_key`	`Utf8`	Idempotency key, if any.
`invoked_by`	`Utf8`	Either: * `ingress` if the invocation was created externally. * `service` if the invocation was created by another Restate service. * `subscription` if the invocation was created by a subscription (e.g. Kafka). * `restart_as_new` if the invocation was created by restarting an old invocation as new. * `ingress_ingestion` if the invocation was created by the ingestion API.
`invoked_by_service_name`	`Utf8`	The name of caller service if `invoked_by = 'service'`.
`invoked_by_id`	`Utf8`	The caller Invocation ID if `invoked_by = 'service'`.
`invoked_by_subscription_id`	`Utf8`	The subscription id if `invoked_by = 'subscription'`.
`invoked_by_target`	`Utf8`	The caller invocation target if `invoked_by = 'service'`.
`restarted_from`	`Utf8`	The original invocation id if `invoked_by = 'restart_as_new'`.
`pinned_deployment_id`	`Utf8`	The ID of the service deployment that started processing this invocation, and will continue to do so (e.g. for retries). This gets set after the first journal entry has been stored for this invocation.
`pinned_service_protocol_version`	`UInt32`	The negotiated protocol version used for this invocation. This gets set after the first journal entry has been stored for this invocation.
`trace_id`	`Utf8`	The ID of the trace that is assigned to this invocation. Only relevant when tracing is enabled.
`journal_size`	`UInt32`	The number of journal entries durably logged for this invocation.
`journal_commands_size`	`UInt32`	The number of commands generated by this invocation, stored in the journal. Only relevant when pinned_service_protocol_version >= 4.
`created_at`	`TimestampMillisecond`	Timestamp indicating the start of this invocation.
`created_using_restate_version`	`Utf8`	restate-server version in use when this invocation was created.
`modified_at`	`TimestampMillisecond`	Timestamp indicating the last invocation status transition. For example, last time the status changed from `invoked` to `suspended`.
`inboxed_at`	`TimestampMillisecond`	Timestamp indicating when the invocation was inboxed, if ever.
`scheduled_at`	`TimestampMillisecond`	Timestamp indicating when the invocation was scheduled, if ever.
`scheduled_start_at`	`TimestampMillisecond`	If the invocation was scheduled, indicates the timestamp when the invocation should start.
`running_at`	`TimestampMillisecond`	Timestamp indicating when the invocation first transitioned to running, if ever.
`completed_at`	`TimestampMillisecond`	Timestamp indicating when the invocation was completed, if ever.
`completion_retention`	`DurationMillisecond`	For how long the metadata of this invocation, including its result, is retained after completion.
`journal_retention`	`DurationMillisecond`	For how long the journal is retained after completion.
`suspended_waiting_for_completions`	`UInt32 List`	List of completion ids the invocation is awaiting on, if `status = suspended`. DEPRECATED: use `suspended_waiting_future_json` instead.
`suspended_waiting_for_signals`	`UInt32 List`	List of signals the invocation is awaiting on, if `status = suspended`. DEPRECATED: use `suspended_waiting_future_json` instead.
`suspended_waiting_future_json`	`Utf8`	Future tree the invocation is suspended on, if `status = suspended`.
`retry_count`	`UInt64`	The number of invocation attempts since the current leader started executing it. Increments on start, so a value greater than 1 means a failure occurred. Note: the value is not a global attempt counter across invocation suspensions and leadership changes.
`last_start_at`	`TimestampMillisecond`	Timestamp indicating the start of the most recent attempt of this invocation.
`next_retry_at`	`TimestampMillisecond`	Timestamp indicating the start of the next attempt of this invocation.
`last_attempt_deployment_id`	`Utf8`	The ID of the service deployment that executed the most recent attempt of this invocation; this is set before a journal entry is stored, but can change later.
`last_attempt_server`	`Utf8`	Server/SDK version, e.g. `restate-sdk-java/1.0.1`
`last_failure`	`Utf8`	An error message describing the most recent failed attempt of this invocation, if any.
`last_failure_error_code`	`Utf8`	The error code of the most recent failed attempt of this invocation, if any.
`last_failure_related_entry_index`	`UInt64`	The index of the journal entry that caused the failure, if any. It may be out-of-bound of the currently stored entries in `sys_journal`. DEPRECATED: you should not use this field anymore, but last_failure_related_command_index instead.
`last_failure_related_entry_name`	`Utf8`	The name of the journal entry that caused the failure, if any. DEPRECATED: you should not use this field anymore, but last_failure_related_command_name instead.
`last_failure_related_entry_type`	`Utf8`	The type of the journal entry that caused the failure, if any. You can check all the available entry types in `entries.rs`. DEPRECATED: you should not use this field anymore, but last_failure_related_command_type instead.
`last_failure_related_command_index`	`UInt64`	The index of the command in the journal that caused the failure, if any. It may be out-of-bound of the currently stored commands in `sys_journal`.
`last_failure_related_command_name`	`Utf8`	The name of the command that caused the failure, if any.
`last_failure_related_command_type`	`Utf8`	The type of the command that caused the failure, if any. You can check all the available command types in `entries.rs`.
`last_awaiting_on_future_json`	`Utf8`	Last known future the SDK was awaiting on, if `in_flight = true`.
`status`	`Utf8`	Either `pending` or `scheduled` or `ready` or `running` or `paused` or `backing-off` or `suspended` or `completed`.
`completion_result`	`Utf8`	If `status = 'completed'`, this contains either `success` or `failure`
`completion_failure`	`Utf8`	If `status = 'completed' AND completion_result = 'failure'`, this contains the error cause

SDKs

Services

Restate Cloud / BYOC / OSS

References

SQL Introspection API

SQL Introspection API

Table: `sys_deployment`

Table: `sys_inbox`

Table: `sys_journal`

Table: `sys_journal_events`

Table: `sys_locks`

Table: `sys_promise`

Table: `sys_rules`

Table: `sys_scheduler`

Table: `sys_service`

Table: `state`

Table: `sys_user_limits`

Table: `sys_vqueue_entry_status`

Table: `sys_vqueue_meta`

Table: `sys_vqueues`

Table: `sys_invocation`

​SQL Introspection API

​Table: sys_deployment

​Table: sys_inbox

​Table: sys_journal

​Table: sys_journal_events

​Table: sys_locks

​Table: sys_promise

​Table: sys_rules

​Table: sys_scheduler

​Table: sys_service

​Table: state

​Table: sys_user_limits

​Table: sys_vqueue_entry_status

​Table: sys_vqueue_meta

​Table: sys_vqueues

​Table: sys_invocation

SQL Introspection API

Table: `sys_deployment`

Table: `sys_inbox`

Table: `sys_journal`

Table: `sys_journal_events`

Table: `sys_locks`

Table: `sys_promise`

Table: `sys_rules`

Table: `sys_scheduler`

Table: `sys_service`

Table: `state`

Table: `sys_user_limits`

Table: `sys_vqueue_entry_status`

Table: `sys_vqueue_meta`

Table: `sys_vqueues`

Table: `sys_invocation`