EXPLAIN (ANALYZE, BUFFERS) results: https://pastebin.canonical.com/190056/
As anticipated, the planner works much better when the CTE optimisation barrier is added, forcing it to use indexes to calculate the set of workitems.
EXPLAIN (ANALYZE, BUFFERS) results: https:/ /pastebin. canonical. com/190056/
As anticipated, the planner works much better when the CTE optimisation barrier is added, forcing it to use indexes to calculate the set of workitems.