Просроченные лиды

SET search_path = _00000003, public;

/*
CREATE INDEX "iЛид-РегламентПодразделениеНовые_tmp2"
  ON _00000003."Лид"
  USING btree
  ("Регламент", "Подразделение", "СозданиеДата" DESC NULLS LAST)
  WHERE "Черновик" IS NULL AND "ПоследнийКонтакт" IS NULL;
*/

EXPLAIN (analyze, buffers)

WITH dept AS (
   WITH RECURSIVE sp AS (
      SELECT
         x."@Лицо" "Лицо",
         x."Раздел",
         x."Название",
         x."Раздел@",
         x."Тип"
      FROM
         "СтруктураПредприятия" x
      WHERE
         x."Тип" = 0
          AND "@Лицо" = 14466736
      UNION ALL
      SELECT
         z."@Лицо" "Лицо",
         z."Раздел",
         z."Название",
         z."Раздел@",
         z."Тип"
      FROM
         "СтруктураПредприятия" z
      INNER JOIN sp y ON z."Раздел" = y."Лицо" AND z."Тип" = y."Тип"
      WHERE
         z."$Черновик" IS NULL AND z."ДатаЗакрытия" IS NULL
   )
   SELECT "Лицо", "Раздел", "Название", "Раздел@" FROM sp
),

theme AS (
   WITH RECURSIVE regs AS (
      SELECT
         x."@Регламент" "Регламент",
         x."Раздел",
         x."Раздел@",
         x."Название",
         x."Флаги",
         x."Лимит",
         x."Порядок",
         x."Норма",
         x."Флаги"[3] "Удален"
      FROM "Регламент" x
      WHERE
         x."Идентификатор" = '8992e41a-a499-11e1-8c02-63ba74c41964'
      UNION ALL
      SELECT
         y."@Регламент" "Регламент",
         y."Раздел",
         y."Раздел@",
         y."Название",
         y."Флаги",
         y."Лимит",
         y."Порядок",
         y."Норма",
         y."Флаги"[3] "Удален"
      FROM regs z
         INNER JOIN "Регламент" y ON z."Регламент" = y."Раздел"
   )

   SELECT *
   FROM regs
   WHERE
      "Удален" IS NOT TRUE  AND
      "Раздел@" IS NOT TRUE
)

SELECT
   COUNT((a)) kol
FROM (
   SELECT
      unnest(ARRAY(
         SELECT
            unnest(ARRAY(
               SELECT ld
               FROM "Лид" ld
               WHERE
                  ld."Черновик" IS NULL AND
                  ld."ПоследнийКонтакт" IS NULL AND
                  ld."Регламент" = t."Регламент" AND
                  ld."Подразделение" = d."Лицо" AND
                  ld."СозданиеДата" >= (date_trunc('day', now()) - '2 years'::INTERVAL)::DATE AND
                  ld."СозданиеДата" < (date_trunc('day', now())::DATE - t."Лимит")::DATE
            )) a
         FROM theme t
         WHERE t."Лимит" IS NOT NULL
      )) a
   FROM dept d
) t