explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hAdK

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 303.506 ↑ 1.0 2 1

Limit (cost=0.10..0.14 rows=2 width=8) (actual time=101.317..303.506 rows=2 loops=1)

2.          

CTE foo

3. 0.003 303.481 ↑ 1.5 2 1

Append (cost=0.00..0.08 rows=3 width=8) (actual time=101.302..303.481 rows=2 loops=1)

4. 101.302 101.302 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=101.301..101.302 rows=1 loops=1)

5. 202.176 202.176 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=202.176..202.176 rows=1 loops=1)

6. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=8) (never executed)

7.          

Initplan (for Limit)

8. 101.309 101.309 ↑ 3.0 1 1

CTE Scan on foo foo_1 (cost=0.00..0.06 rows=3 width=0) (actual time=101.309..101.309 rows=1 loops=1)

9. 101.317 303.502 ↑ 1.5 2 1

Result (cost=0.00..0.06 rows=3 width=8) (actual time=101.316..303.502 rows=2 loops=1)

  • One-Time Filter: $1
10. 202.185 202.185 ↑ 1.5 2 1

CTE Scan on foo (cost=0.00..0.06 rows=3 width=8) (actual time=0.002..202.185 rows=2 loops=1)

Planning time : 0.158 ms
Execution time : 303.558 ms