Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
|||
| room_id | uuid | 2147483647 | √ | null |
|
|
||
| url | text | 2147483647 | null |
|
|
|||
| slug | text | 2147483647 | null |
|
|
|||
| version | text | 2147483647 | √ | null |
|
|
||
| tier | int4 | 10 | √ | null |
|
|
||
| used_relay | bool | 1 | √ | null |
|
|
||
| pages_crawled | int4 | 10 | √ | null |
|
|
||
| wacz_bytes | int8 | 19 | √ | null |
|
|
||
| states_audited | int4 | 10 | √ | null |
|
|
||
| total_violations | int4 | 10 | √ | null |
|
|
||
| status | text | 2147483647 | null |
|
|
|||
| error | text | 2147483647 | √ | null |
|
|
||
| duration_ms | int8 | 19 | √ | null |
|
|
||
| started_at | timestamptz | 35,6 | √ | null |
|
|
||
| finished_at | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ir_capture_run_pkey | Primary key | Asc | id |
| idx_ir_run_room | Performance | Asc | room_id |
| idx_ir_run_slug | Performance | Asc | slug |
| idx_ir_run_time | Performance | Desc | finished_at |
| idx_ir_run_url | Performance | Asc | url |