Skip to content

Change approach to filter out hidden issues

Pavel Shutsin requested to merge 383552-issuefinder-investigate-banneduser-performance into master

What does this MR do and why?

This MR revert changes in !89051 (diffs) because new appoach sometimes get very inneficient. See corresponding issue for details.

Query plans

Issues Count:

Before: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/14033/commands/48972 After: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/14033/commands/48970

Issues List:

Before: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/14033/commands/48971 After: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/14033/commands/48973

Problematic count query:

Before: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/14033/commands/48976 After: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/14033/commands/48975

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #383552 (closed)

Edited by Pavel Shutsin

Merge request reports