explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1JA

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 19.578 ↓ 0.0 0 1

Delete on poblacion (cost=6,189.93..6,688.95 rows=1 width=6) (actual time=19.578..19.578 rows=0 loops=1)

2. 1.418 19.572 ↓ 0.0 0 1

Seq Scan on poblacion (cost=6,189.93..6,688.95 rows=1 width=6) (actual time=19.572..19.572 rows=0 loops=1)

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

SubPlan (forSeq Scan)

4. 0.004 18.154 ↑ 1.0 2 1

Unique (cost=6,189.91..6,189.92 rows=2 width=8) (actual time=18.153..18.154 rows=2 loops=1)

5. 0.033 18.150 ↑ 1.0 2 1

Sort (cost=6,189.91..6,189.92 rows=2 width=8) (actual time=18.150..18.150 rows=2 loops=1)

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

Append (cost=0.00..6,189.90 rows=2 width=8) (actual time=0.009..18.117 rows=2 loops=1)

7. 0.003 0.012 ↓ 2.0 2 1

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

8. 0.009 0.009 ↓ 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.009 rows=2 loops=1)

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

HashAggregate (cost=6,181.55..6,181.56 rows=1 width=8) (actual time=18.104..18.104 rows=0 loops=1)

10. 18.101 18.101 ↓ 0.0 0 1

Seq Scan on localizacion (cost=0.00..6,181.55 rows=1 width=8) (actual time=18.101..18.101 rows=0 loops=1)

  • Filter: (idpoblacion IS NOT NULL)
  • Rows Removed by Filter: 368331