Analyze `p_ci_pipeline_variables` and change the table name for the model

After the routing table is created, we must analyze the routing table and change the table_name in the model to use the routing table instead of the partition. These are the last steps in the partitioning document:

• https://docs.gitlab.com/ee/development/database/partitioning/list.html#step-9---analyze-the-partitioned-table-and-create-new-partitions
• https://docs.gitlab.com/ee/development/database/partitioning/list.html#step-10---update-the-application-to-use-the-partitioned-table

changed milestone to %16.9

added CI data partitioning Category:Continuous Integration Deliverable backend ciscaling cicdactive database devopsverify grouppipeline execution maintenancescalability sectionci typemaintenance workflowin review labels

added to epic &11805 (closed)

removed workflowin review label

removed Deliverable label

mentioned in epic &7522

mentioned in issue gitlab-org/database-team/team-tasks#406 (closed)

assigned to @morefice

mentioned in merge request !143041 (merged)

@mbobin

Should we use a feature flag when reading from our new partitioned table?

@morefice the switch module works with a feature flag.

@morefice looks like the table was analyzed earlier today

@mbobin

Where do you see this?

I thought the job auto_explain job was populated once we add partitioned: true to the model.

!143041 (merged) was executed, see the workflowpost-deploy-db-production status

Yes definitely saw this

Update

We are now fully reading data from p_ci_pipeline variables on gitlab.com.

cc @mbobin @panoskanell

Update

• The feature has been fully rollout and we are now using our new partitioned table

The work for this issue is completed, closing it.

cc @mbobin @panoskanell

mentioned in issue gitlab-com/gl-infra/production#17508 (closed)

mentioned in merge request !143334 (merged)

added workflowin dev label

mentioned in merge request !143528 (merged)

mentioned in issue gitlab-org/quality/triage-reports#16167 (closed)

mentioned in merge request !143795 (merged)

mentioned in merge request !143905 (merged)

mentioned in issue #440759 (closed)

mentioned in issue #440760 (closed)

added workflowin review label and removed workflowin dev label

closed

added workflowcomplete label and removed workflowin review label

mentioned in issue #441759 (closed)