explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HFmb : Optimization for: plan #VFAc

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.036 ↓ 2.2 11 1

Append (cost=0.000..4.490 rows=5 width=92) (actual time=0.019..0.036 rows=11 loops=1)

2. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on romeo (cost=0.000..1.000 rows=1 width=48) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (three = 1)
3. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on india (cost=0.000..1.010 rows=1 width=160) (actual time=0.006..0.006 rows=1 loops=1)

  • Filter: (three = 1)
4. 0.008 0.008 ↑ 1.0 2 1

Seq Scan on victor (cost=0.000..1.140 rows=2 width=48) (actual time=0.007..0.008 rows=2 loops=1)

  • Filter: (three = 1)
  • Rows Removed by Filter: 9
5. 0.008 0.008 ↓ 8.0 8 1

Seq Scan on lima (cost=0.000..1.340 rows=1 width=160) (actual time=0.006..0.008 rows=8 loops=1)

  • Filter: (three = 1)
  • Rows Removed by Filter: 19