Skip to content

Improve epic swimlanes loading performance for group issue board

Felipe Cardozo requested to merge issue_243606-improve_epic_swimlanes_query into master

What does this MR do and why?

Improves loading of epics swimlanes on group issue boards. Removing aORDER BY epics.id DESC
from an authorization subquery gives a performance increase.

Before removing order statement

For some reason Postgres loads 3 million rows when having order statement on subquery: https://explain.depesz.com/s/xy4y#l25 producing heavy load on https://explain.depesz.com/s/xy4y#l6

This disappears when removing the following line from query: $2212568#LC414

After removing order statement

related to #243606 (closed)

Edited by Felipe Cardozo

Merge request reports