Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| interface_id | varchar | 100 | null |
|
|
Unique interface name to represent a batch execution. Refer to EXECUTION_MAP table PK |
|||||
| execution_id | int4 | 10 | null |
|
|
The execution ID that represent a batch execution. Refer to EXECUTION_MAP table PK |
|||||
| execution_status | varchar | 100 | null |
|
|
Status of this execution. FAILED or SUCCESS expected. |
|||||
| execution_details | text | 2147483647 | √ | null |
|
|
Reference text of this interface instance execution |
||||
| source_connect_timedelta | interval | 49,6 | √ | null |
|
|
Timedelta referring to how much time was needed to stablish a connection in the source database |
||||
| source_extract_timedelta | interval | 49,6 | √ | null |
|
|
Timedelta referring to how much time was needed to execute a extract statement in the source database |
||||
| source_extract_row_count | int4 | 10 | √ | null |
|
|
Number of rows extracted from the source database for this execution. |
||||
| target_connect_timedelta | interval | 49,6 | √ | null |
|
|
Timedelta referring to how much time was needed to stablish a connection in the target database |
||||
| target_load_timedelta | interval | 49,6 | √ | null |
|
|
Timedelta referring to how much time was needed to load the extracted data in the target database |
||||
| target_load_row_count | int4 | 10 | √ | null |
|
|
Number of rows inserted or updated in the target database for this execution. |
||||
| process_started_at | timestamp | 29,6 | √ | null |
|
|
Timestamp when this execution instance was started |
||||
| process_finished_at | timestamp | 29,6 | √ | null |
|
|
Timestamp when this execution instance was finished |
||||
| process_timedelta | interval | 49,6 | √ | null |
|
|
Timedelta referring how much time was spent to execute the whole process. |
||||
| last_run_ts | timestamp | 29,6 | √ | null |
|
|
Last timestamp this interface instance was executed for batch execution |
||||
| current_run_ts | timestamp | 29,6 | √ | null |
|
|
Current timestamp this interface instance was executed of this batch execution |
||||
| retry_process | bool | 1 | √ | false |
|
|
If true, this log instance will be processed again (with last_run_ts and current_run_ts parameters) |
||||
| updated_at | timestamp | 29,6 | now() |
|
|
Timestamp of the last time this record was updated |
|||||
| created_at | timestamp | 29,6 | now() |
|
|
Timestamp of the time this record was created |
Relationships
Close relationships within degrees of separation
