Re: BUG #16053: Query planner performance regression in sql querywith multiple CTE in v12

--explain analyse
WITH cte_A AS
  (SELECT inv_y.cid AS cid,
          inv_y.pid AS pid,
          sum(inv_y.value) AS value
   FROM inv_y
   WHERE inv_y.y = 1
   GROUP BY inv_y.cid,
            inv_y.pid),
     cte_B AS
  (SELECT inv_y.cid AS cid,
          inv_y.pid AS pid
   FROM inv_y
   WHERE inv_y.y = 1),
     cte_C AS
  (SELECT sum(inv.value) AS value,
          inv.cid AS cid,
          inv.pid AS pid
   FROM inv
   JOIN cte_B ON cte_B.cid = inv.cid
   AND cte_B.pid = inv.pid
   WHERE inv.invd >= '2017-01-01'
     AND inv.invd <= '2018-12-31'
   GROUP BY inv.cid,
            inv.pid),
     cte_D AS
  (SELECT cte_C.cid AS cid,
          cte_C.pid AS pid,
          sum(cte_C.value) AS value
   FROM cte_C
   GROUP BY cte_C.cid,
            cte_C.pid),
     cte_E AS
  (SELECT sum(inv.value) AS value,
          inv.cid AS cid,
          inv.pid AS pid
   FROM inv
   JOIN cte_B ON cte_B.cid = inv.cid
   AND cte_B.pid = inv.pid
   WHERE inv.invd >= '2018-01-01'
     AND inv.invd <= '2018-06-30'
   GROUP BY inv.cid,
            inv.pid),
     cte_F AS
  (SELECT cte_B.cid AS cid,
          cte_B.pid AS pid,
          coalesce(sum(cte_E.value), 0) AS value
   FROM cte_B
   LEFT OUTER JOIN cte_E ON cte_E.cid = cte_B.cid
   AND cte_E.pid = cte_B.pid
   GROUP BY cte_B.cid,
            cte_B.pid),
     cte_G AS
  (SELECT sum(expe.value) AS value,
          expe.cid AS cid,
          expe.pid AS pid
   FROM expe
   JOIN cte_B ON cte_B.cid = expe.cid
   AND cte_B.pid = expe.pid
   WHERE expe.invd >= '2018-07-01'
     AND expe.invd <= '2018-12-31'
   GROUP BY expe.cid,
            expe.pid),
     cte_H AS
  (SELECT cte_B.cid AS cid,
          cte_B.pid AS pid,
          coalesce(sum(cte_G.value), 0) AS value
   FROM cte_B
   LEFT OUTER JOIN cte_G ON cte_G.cid = cte_B.cid
   AND cte_G.pid = cte_B.pid
   GROUP BY cte_B.cid,
            cte_B.pid)
SELECT cte_D.value AS ref_value,
       cte_D.value - (cte_F.value + cte_H.value) AS rem_value
FROM cte_A
JOIN cte_D ON cte_A.cid = cte_D.cid
AND cte_A.pid = cte_D.pid
JOIN cte_F ON cte_A.cid = cte_F.cid
AND cte_A.pid = cte_F.pid
JOIN cte_H ON cte_A.cid = cte_H.cid
AND cte_A.pid = cte_H.pid
--join cte_B ON cte_A.cid = cte_B.cid
--AND cte_A.pid = cte_B.pid