explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pbdy : Example of plan without costs

Settings
# exclusive inclusive rows x rows loops node
1. 0.160 0.160 ↓ 0.0 42 1

CTE Scan on foo (cost=0..0 rows=0 width=0) (actual time=0.008..0.160 rows=42 loops=1)

2.          

CTE foo

3. 0.087 0.132 ↓ 0.0 42 1

Recursive Union (cost=0..0 rows=0 width=0) (actual time=0.005..0.132 rows=42 loops=1)

4. 0.003 0.003 ↓ 0.0 1 1

Result (cost=0..0 rows=0 width=0) (actual time=0.003..0.003 rows=1 loops=1)

5. 0.042 0.042 ↓ 0.0 1 42

WorkTable Scan on foo foo_1 (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=1 loops=42)

  • Filter: (n < 42)
  • Rows Removed by Filter: 0