GitLab Migration - canceling statement due to statement timeout in IssuesPipeline

Noticed this error while running a test migration on .com which is happening across multiple separate project migrations.

[
  {
    "relation": "issues",
    "step": "transformer",
    "exception_message": "PG::QueryCanceled: ERROR:  canceling statement due to statement timeout\n",
    "exception_class": "ActiveRecord::QueryCanceled",
    "correlation_id_value": "546ade9620a4cddc942c33add22dc169",
    "created_at": "2022-11-09T17:28:48.743Z",
    "pipeline_class": "BulkImports::Projects::Pipelines::IssuesPipeline",
    "pipeline_step": "transformer"
  },
  {
    "relation": "issues",
    "step": "transformer",
    "exception_message": "PG::QueryCanceled: ERROR:  canceling statement due to statement timeout\n",
    "exception_class": "ActiveRecord::QueryCanceled",
    "correlation_id_value": "546ade9620a4cddc942c33add22dc169",
    "created_at": "2022-11-09T17:28:33.658Z",
    "pipeline_class": "BulkImports::Projects::Pipelines::IssuesPipeline",
    "pipeline_step": "transformer"
  }
]

Seems to be consistently happening in IssuesPipeline during transformation step.

Investigate which query is taking a while and replace/optimize it.