QUERY PLAN |
Nested Loop (cost=0.03..3564.08 rows=32768 width=32) (actual rows=32768 loops=1) |
CTE sep |
-> Values Scan on "*VALUES*" (cost=0.00..0.03 rows=2 width=32) (actual rows=2 loops=1) |
-> Nested Loop (cost=0.00..451.07 rows=16384 width=448) (actual rows=16384 loops=1) |
-> CTE Scan on sep sep2 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..266.71 rows=8192 width=416) (actual rows=8192 loops=2) |
-> Nested Loop (cost=0.00..225.75 rows=8192 width=416) (actual rows=8192 loops=1) |
-> CTE Scan on sep sep8 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..133.55 rows=4096 width=384) (actual rows=4096 loops=2) |
-> Nested Loop (cost=0.00..113.07 rows=4096 width=384) (actual rows=4096 loops=1) |
-> CTE Scan on sep sep12 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..66.95 rows=2048 width=352) (actual rows=2048 loops=2) |
-> Nested Loop (cost=0.00..56.71 rows=2048 width=352) (actual rows=2048 loops=1) |
-> CTE Scan on sep sep6 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..33.63 rows=1024 width=320) (actual rows=1024 loops=2) |
-> Nested Loop (cost=0.00..28.51 rows=1024 width=320) (actual rows=1024 loops=1) |
-> CTE Scan on sep sep1 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..16.95 rows=512 width=288) (actual rows=512 loops=2) |
-> Nested Loop (cost=0.00..14.39 rows=512 width=288) (actual rows=512 loops=1) |
-> CTE Scan on sep sep9 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..8.59 rows=256 width=256) (actual rows=256 loops=2) |
-> Nested Loop (cost=0.00..7.31 rows=256 width=256) (actual rows=256 loops=1) |
-> CTE Scan on sep sep10 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..4.39 rows=128 width=224) (actual rows=128 loops=2) |
-> Nested Loop (cost=0.00..3.75 rows=128 width=224) (actual rows=128 loops=1) |
-> CTE Scan on sep sep15 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..2.27 rows=64 width=192) (actual rows=64 loops=2) |
-> Nested Loop (cost=0.00..1.95 rows=64 width=192) (actual rows=64 loops=1) |
-> CTE Scan on sep sep4 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..1.19 rows=32 width=160) (actual rows=32 loops=2) |
-> Nested Loop (cost=0.00..1.03 rows=32 width=160) (actual rows=32 loops=1) |
-> CTE Scan on sep sep5 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..0.63 rows=16 width=128) (actual rows=16 loops=2) |
-> Nested Loop (cost=0.00..0.55 rows=16 width=128) (actual rows=16 loops=1) |
-> CTE Scan on sep sep7 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..0.33 rows=8 width=96) (actual rows=8 loops=2) |
-> Nested Loop (cost=0.00..0.29 rows=8 width=96) (actual rows=8 loops=1) |
-> CTE Scan on sep sep11 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> Materialize (cost=0.00..0.16 rows=4 width=64) (actual rows=4 loops=2) |
-> Nested Loop (cost=0.00..0.14 rows=4 width=64) (actual rows=4 loops=1) |
-> CTE Scan on sep sep14 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=1) |
-> CTE Scan on sep sep3 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=2) |
-> CTE Scan on sep sep13 (cost=0.00..0.04 rows=2 width=32) (actual rows=2 loops=16384) |
Planning Time: 9.936 ms |
Execution Time: 56.137 ms |