explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DLwf

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

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

2.          

CTE foo

3. 0.003 448.808 ↑ 1.5 2 1

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

4. 173.812 173.812 ↑ 1.0 1 1

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

5. 274.993 274.993 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=274.993..274.993 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. 173.818 173.818 ↑ 3.0 1 1

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

9. 173.825 448.829 ↑ 1.5 2 1

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

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

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

Planning time : 0.137 ms
Execution time : 448.909 ms