How to fix Statement too complex in PostgreSQL

CREATE TEMP TABLE intermediate_results AS
SELECT col1, col2
FROM table1
JOIN table2 ON table1.id = table2.id
JOIN table3 ON table2.id = table3.id;

SELECT *
FROM intermediate_results
JOIN table4 ON intermediate_results.col1 = table4.col1;

WITH cte1 AS (
  SELECT * FROM table1 WHERE condition1
),
cte2 AS (
  SELECT * FROM cte1 JOIN table2 ON cte1.id = table2.id
),
cte3 AS (
  SELECT * FROM cte2 JOIN table3 ON cte2.id = table3.id
)
SELECT * FROM cte3;

WITH RECURSIVE cte AS (
  SELECT id, parent_id, 1 as depth
  FROM tree_table
  WHERE parent_id IS NULL
  
  UNION ALL
  
  SELECT t.id, t.parent_id, cte.depth + 1
  FROM tree_table t
  INNER JOIN cte ON t.parent_id = cte.id
  WHERE cte.depth < 10  -- Add a depth limit
)
SELECT * FROM cte;

-- Before: Query with 15+ joins
SELECT t1.col1, t2.col2, t5.col5
FROM t1 
JOIN t2 ON t1.id = t2.id
JOIN t3 ON t2.id = t3.id
JOIN t4 ON t3.id = t4.id
JOIN t5 ON t4.id = t5.id
WHERE t1.status = 'active';

-- After: Reduce with intermediate table
CREATE TEMP TABLE filtered_t1 AS
SELECT * FROM t1 WHERE status = 'active';

SELECT f.col1, t2.col2, t5.col5
FROM filtered_t1 f
JOIN t2 ON f.id = t2.id
JOIN t5 ON t2.t5_id = t5.id;  -- Direct join instead of chain

-- Before: Complex OR with subqueries
SELECT * FROM users
WHERE (id IN (SELECT user_id FROM orders WHERE amount > 1000))
   OR (id IN (SELECT user_id FROM reviews WHERE rating = 5))
   OR (id IN (SELECT user_id FROM clicks WHERE count > 100));

-- After: UNION ALL
SELECT * FROM users WHERE id IN (SELECT user_id FROM orders WHERE amount > 1000)
UNION ALL
SELECT * FROM users WHERE id IN (SELECT user_id FROM reviews WHERE rating = 5)
UNION ALL
SELECT * FROM users WHERE id IN (SELECT user_id FROM clicks WHERE count > 100);

ANALYZE table_name;

EXPLAIN (FORMAT JSON, ANALYZE)
SELECT ... FROM ...;