explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LUDc

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.400 ↓ 0.0 0 1

Delete on poblacion (cost=16.67..515.70 rows=1 width=6) (actual time=1.400..1.400 rows=0 loops=1)

2. 1.119 1.398 ↓ 0.0 0 1

Seq Scan on poblacion (cost=16.67..515.70 rows=1 width=6) (actual time=1.398..1.398 rows=0 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 2
3.          

SubPlan (forSeq Scan)

4. 0.002 0.279 ↑ 1.0 2 1

Unique (cost=16.66..16.67 rows=2 width=8) (actual time=0.278..0.279 rows=2 loops=1)

5. 0.014 0.277 ↑ 1.0 2 1

Sort (cost=16.66..16.66 rows=2 width=8) (actual time=0.277..0.277 rows=2 loops=1)

  • Sort Key: direccion.idpoblacion
  • Sort Method: quicksort Memory: 25kB
6. 0.013 0.263 ↑ 1.0 2 1

Append (cost=0.00..16.65 rows=2 width=8) (actual time=0.022..0.263 rows=2 loops=1)

7. 0.003 0.013 ↓ 2.0 2 1

Unique (cost=0.00..8.32 rows=1 width=8) (actual time=0.010..0.013 rows=2 loops=1)

8. 0.010 0.010 ↓ 2.0 2 1

Index Only Scan using direccion_idpedania_idx on direccion (cost=0.00..8.32 rows=1 width=8) (actual time=0.008..0.010 rows=2 loops=1)

  • Index Cond: (idpoblacion IS NOT NULL)
  • Heap Fetches: 2
9. 0.001 0.237 ↓ 0.0 0 1

Unique (cost=0.00..8.31 rows=1 width=8) (actual time=0.237..0.237 rows=0 loops=1)

10. 0.236 0.236 ↓ 0.0 0 1

Index Only Scan using localizacion_idpoblacion_idx on localizacion (cost=0.00..8.31 rows=1 width=8) (actual time=0.236..0.236 rows=0 loops=1)

  • Index Cond: (idpoblacion IS NOT NULL)
  • Heap Fetches: 0