Remove legacy columns from ci_builds
Overview
There are bunch of deprecated columns in ci_builds
, we should identify and remove them as part of &4685 (closed).
Columns
Column | Type | Collation | Nullable | Default | Deprecated? |
---|---|---|---|---|---|
id | integer | not null | nextval('ci_builds_id_seq'::regclass) | ||
status | character varying | ||||
finished_at | timestamp without time zone | ||||
trace | text | ||||
created_at | timestamp without time zone | ||||
updated_at | timestamp without time zone | ||||
started_at | timestamp without time zone | ||||
runner_id | integer | ||||
coverage | double precision | ||||
commit_id | integer | ||||
commands | text | ||||
name | character varying | ||||
options | text | ||||
allow_failure | boolean | not null | false | ||
stage | character varying | ||||
trigger_request_id | integer | ||||
stage_idx | integer | ||||
tag | boolean | ||||
ref | character varying | ||||
user_id | integer | ||||
type | character varying | ||||
target_url | character varying | ||||
description | character varying | ||||
artifacts_file | text | ||||
project_id | integer | ||||
artifacts_metadata | text | ||||
erased_by_id | integer | ||||
erased_at | timestamp without time zone | ||||
artifacts_expire_at | timestamp without time zone | ||||
environment | character varying | ||||
artifacts_size | bigint | ||||
when | character varying | ||||
yaml_variables | text | ||||
queued_at | timestamp without time zone | ||||
token | character varying | ||||
lock_version | integer | 0 | |||
coverage_regex | character varying | ||||
auto_canceled_by_id | integer | ||||
retried | boolean | ||||
stage_id | integer | ||||
artifacts_file_store | integer | ||||
artifacts_metadata_store | integer | ||||
protected | boolean | ||||
failure_reason | integer | ||||
scheduled_at | timestamp with time zone | ||||
token_encrypted | character varying | ||||
upstream_pipeline_id | integer | ||||
resource_group_id | bigint | ||||
waiting_for_resource_at | timestamp with time zone | ||||
processed | boolean | ||||
scheduling_type | smallint |
Notes
The stage
column is known to take a lot of space, and it might not be needed anymore after we enable ci_atomic_processing
FF.
Edited by Ricky Wiens