Collapse queries of the form IN (literal parameter-list) into distinct executions of a single query
With queries of the form where col in ($1, $2, ...)
, if the list of parameters varies in length ever, each query gets recorded separately. This can happen if we do Relation.where(other_id: OtherRelation.pluck(:id))
or a similar pattern, which is uncommon but sometimes necessary.
This makes the notifier report very difficult to read, and makes scrolling through the entire MR frustrating (since the comment is many screens tall).
We should identify this pattern and collapse the queries so that they only show up once.
gitlab-org/gitlab!73640 (comment 753654765) has a good example of this issue.