[
https://issues.apache.org/jira/browse/AIRFLOW-6242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16995499#comment-16995499
]
Ash Berlin-Taylor commented on AIRFLOW-6242:
--------------------------------------------
I'm sure you thought of this, just not mentioned in the ticket: plus we can
look at what queries we run and use this {{run_type}} column in a new/changed
index.
> Introduce run_type in DAG Run table
> -----------------------------------
>
> Key: AIRFLOW-6242
> URL: https://issues.apache.org/jira/browse/AIRFLOW-6242
> Project: Apache Airflow
> Issue Type: Bug
> Components: backfill, scheduler
> Affects Versions: 1.10.6
> Reporter: Kamil Bregula
> Priority: Major
>
> Hello,
> Before you start reading this ticket, I want to tell you one thing - you are
> wonderful.
> We use queries that use like expressions to filter two types of DAG Run.
> * Backfill:
>
> [https://github.com/apache/airflow/blob/699aea8ee368abcba29d717daf2580f897ab9d93/airflow/jobs/backfill_job.py#L52]
> * Scheduled
>
> [https://github.com/apache/airflow/blob/699aea8ee368abcba29d717daf2580f897ab9d93/airflow/models/dagrun.py#L46]
> This type of expression can affect performance and it seems a better idea to
> store this information in a separate column. This may allow a query planner
> to create a better query plan in the database engine.
> Thanks for reading this ticket.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
