explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Opp4

Settings
# exclusive inclusive rows x rows loops node
1. 602.355 2,899.655 ↓ 1.0 106,904 1

Hash Join (cost=6,071.01..11,639,515.96 rows=106,680 width=168) (actual time=76.313..2,899.655 rows=106,904 loops=1)

  • Hash Cond: (b.datos_personales_id = p.id)
2. 83.243 83.243 ↓ 1.0 106,904 1

Seq Scan on m1_afiliados_beneficiario b (cost=0.00..7,888.80 rows=106,680 width=100) (actual time=0.014..83.243 rows=106,904 loops=1)

3. 41.055 75.977 ↑ 1.0 76,978 1

Hash (cost=4,205.78..4,205.78 rows=76,978 width=72) (actual time=75.977..75.977 rows=76,978 loops=1)

  • Buckets: 1024 Batches: 8 Memory Usage: 985kB
4. 34.922 34.922 ↑ 1.0 76,978 1

Seq Scan on osm_datos_personales p (cost=0.00..4,205.78 rows=76,978 width=72) (actual time=0.010..34.922 rows=76,978 loops=1)

5.          

SubPlan (forHash Join)

6. 106.937 534.520 ↑ 1.0 1 106,904

Nested Loop (cost=0.69..16.75 rows=1 width=5) (actual time=0.005..0.005 rows=1 loops=106,904)

7. 320.712 320.712 ↑ 1.0 1 106,904

Index Scan using osm_direcciones_pkey on osm_direcciones d (cost=0.41..8.43 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=106,904)

  • Index Cond: (id = p.direccion_id)
8. 106.871 106.871 ↑ 1.0 1 106,871

Index Scan using osm_codigos_postales_pkey on osm_codigos_postales c (cost=0.28..8.30 rows=1 width=9) (actual time=0.001..0.001 rows=1 loops=106,871)

  • Index Cond: (id = d.codigo_postal_id)
9. 106.970 534.520 ↑ 1.0 1 106,904

Nested Loop (cost=0.83..16.88 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=106,904)

10. 213.808 213.808 ↑ 1.0 1 106,904

Index Scan using osm_direcciones_pkey on osm_direcciones d_1 (cost=0.41..8.43 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=106,904)

  • Index Cond: (id = p.direccion_id)
11. 213.742 213.742 ↑ 1.0 1 106,871

Index Scan using osm_calles_pkey on osm_calles a (cost=0.42..8.44 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=106,871)

  • Index Cond: (id = d_1.calle_id)
12. 213.808 213.808 ↑ 1.0 1 106,904

Index Scan using osm_direcciones_pkey on osm_direcciones d_2 (cost=0.41..8.43 rows=1 width=7) (actual time=0.002..0.002 rows=1 loops=106,904)

  • Index Cond: (id = p.direccion_id)
13. 213.808 213.808 ↑ 1.0 1 106,904

Index Scan using osm_direcciones_pkey on osm_direcciones d_3 (cost=0.41..8.43 rows=1 width=1) (actual time=0.001..0.002 rows=1 loops=106,904)

  • Index Cond: (id = p.direccion_id)
14. 213.808 213.808 ↑ 1.0 1 106,904

Index Scan using osm_direcciones_pkey on osm_direcciones d_4 (cost=0.41..8.43 rows=1 width=1) (actual time=0.001..0.002 rows=1 loops=106,904)

  • Index Cond: (id = p.direccion_id)
15. 213.808 213.808 ↑ 1.0 1 106,904

Index Scan using osm_direcciones_pkey on osm_direcciones d_5 (cost=0.41..8.43 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=106,904)

  • Index Cond: (id = p.direccion_id)
16. 85.424 106.904 ↓ 0.0 0 106,904

Nested Loop (cost=0.55..16.62 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=106,904)

17. 0.000 0.000 ↓ 0.0 0 106,904

Index Scan using osm_telefonos_pkey on osm_telefonos tf (cost=0.28..8.30 rows=1 width=11) (actual time=0.000..0.000 rows=0 loops=106,904)

  • Index Cond: (id = p.telefono_fijo_id)
18. 21.480 21.480 ↑ 1.0 1 10,740

Index Scan using osm_codigos_de_area_pkey on osm_codigos_de_area af (cost=0.27..8.29 rows=1 width=9) (actual time=0.001..0.002 rows=1 loops=10,740)

  • Index Cond: (id = tf.codigo_area_id)
19. 87.202 106.904 ↓ 0.0 0 106,904

Nested Loop (cost=0.55..16.62 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=106,904)

20. 0.000 0.000 ↓ 0.0 0 106,904

Index Scan using osm_telefonos_pkey on osm_telefonos tc (cost=0.28..8.30 rows=1 width=11) (actual time=0.000..0.000 rows=0 loops=106,904)

  • Index Cond: (id = p.telefono_celular_id)
21. 19.702 19.702 ↑ 1.0 1 9,851

Index Scan using osm_codigos_de_area_pkey on osm_codigos_de_area ac (cost=0.27..8.29 rows=1 width=9) (actual time=0.001..0.002 rows=1 loops=9,851)

  • Index Cond: (id = tc.codigo_area_id)
22. 0.000 0.000 ↓ 0.0 0 106,904

Index Scan using osm_emails_pkey on osm_emails e (cost=0.28..8.30 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=106,904)

  • Index Cond: (p.email_id = id)