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
-
SQL: $2212568
-
Query plan https://explain.depesz.com/s/xy4y
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
-
Sql $2212572
-
Query plan https://explain.depesz.com/s/NDOBh
related to #243606 (closed)
Edited by Felipe Cardozo