It seems that my run of the CTE version was simply unlucky (locking…). a new run of the exact same query by stub show that it improves things significantly: https://pastebin.canonical.com/55946/.
It seems that my run of the CTE version was simply unlucky (locking…). a new run of the exact same query by stub show that it improves things significantly: https:/ /pastebin. canonical. com/55946/.