Follow-up from "Show pending placeholder assignment notice"
<!--IssueSummary start-->
<details>
<summary>
Everyone can contribute. [Help move this issue forward](https://handbook.gitlab.com/handbook/marketing/developer-relations/contributor-success/community-contributors-workflows/#contributor-links) while earning points, leveling up and collecting rewards.
</summary>
- [Close this issue](https://contributors.gitlab.com/manage-issue?action=close&projectId=278964&issueIid=486247)
</details>
<!--IssueSummary end-->
The following discussion from !163355 should be addressed:
- [ ] @panoskanell started a [discussion](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/163355#note_2089641356): (+3 comments)
> **Question:** What is the potential output volume of this query?
>
> I am asking because there are several application-level transformations below, so hopefully the data volume is low.
issue