Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('sensor_instance_id_seq'::regclass) |
|
|
||
| task_id | varchar | 250 | null |
|
|
|||
| dag_id | varchar | 250 | null |
|
|
|||
| execution_date | timestamptz | 35,6 | null |
|
|
|||
| state | varchar | 20 | √ | null |
|
|
||
| try_number | int4 | 10 | √ | null |
|
|
||
| start_date | timestamptz | 35,6 | √ | null |
|
|
||
| operator | varchar | 1000 | null |
|
|
|||
| op_classpath | varchar | 1000 | null |
|
|
|||
| hashcode | int8 | 19 | null |
|
|
|||
| int4 | 10 | null |
|
|
||||
| poke_context | text | 2147483647 | null |
|
|
|||
| execution_context | text | 2147483647 | √ | null |
|
|
||
| created_at | timestamptz | 35,6 | null |
|
|
|||
| updated_at | timestamptz | 35,6 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| sensor_instance_pkey | Primary key | Asc | id |
| si_hashcode | Performance | Asc | hashcode |
| si_shardcode | Performance | Asc | shardcode |
| si_state_shard | Performance | Asc/Asc | state + shardcode |
| si_updated_at | Performance | Asc | updated_at |
| ti_primary_key | Must be unique | Asc/Asc/Asc | dag_id + task_id + execution_date |
Diagram producer might be missing
No diagrams were produced please see application output for any errors