Skip to content

Improve epic swimlanes loading performance for group issue board

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

Loading