completed_action Table

This table lists the current set of completed actions. A completed action is an action that completed its execution, whether the action succeeded or failed.

This table does not contain “in progress” or “queued” actions.

completed_action

completed_action table

Column Name

Type

Nullable

Primary

Description

recommendation_time

timestamp with time zone

false

false

The time the action was recommended.

acceptance_time

timestamp with time zone

false

false

The time the action was accepted for execution.

completion_time

timestamp with time zone

false

false

The time the action was completed.

action_oid

bigint

false

false

The oid of the action in the system.

type

action_type

false

false

The type of the action.

severity

severity

false

false

The severity of the action.

severity

severity type

  • CRITICAL
  • MAJOR
  • MINOR
  • NORMAL

category

action_category

false

false

The category of the action.

target_entity_id

bigint

false

false

The oid of the target entity.

involved_entities

bigint[]

true

false

The oids of the involved entities (includes the target entity).

description

text

false

false

The text description of the action.

savings

double precision

false

false

Savings (or, if negative, investment) of the action.

final_state

terminal_state

false

false

The final state of the action.

terminal_state

terminal_state type

  • FAILED
  • SUCCEEDED

final_message

text

false

false

Message associated with the final state. Should contain an error message if the action failed.

attrs

jsonb

true

false

Additional (often type-specific) information for the action.

For example, in resizes this will contain the commodity type and from/to amounts.

Sample Use Cases

N/A