graphs/sql/battle_plan/req01.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

EXPLAIN (ANALYZE, COSTS, BUFFERS, VERBOSE, FORMAT YAML)
WITH RECURSIVE fib AS (
    SELECT
        1 AS n,
        1::bigint AS fibn,
        1::bigint AS fibn_1
    UNION ALL
    SELECT
        n + 1 AS n,
        fibn_1 AS fibn,
        fibn + fibn_1 AS fibn_1
    FROM fib
    WHERE n < 80
)

SELECT
    n,
    fibn
FROM fib;