explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aUy6

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

Limit (cost=1.29..1.44 rows=1 width=140) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=1.29..310,152,086.00 rows=2,160,069,575 width=140) (actual rows= loops=)

  • Merge Cond: ((a."DocumentoIdentidad")::text = (b.numero_documento)::text)
  • Join Filter: (similarity((((((a."Paterno")::text || ' '::text) || (a."Materno")::text) || ' '::text) || (a."Nombres")::text), (((((b.primer_apellido)::text || ' '::text) || (b.segundo_apellido)::text) || ' '::text) || (b.nombres)::text)) >= '0.5'::double precision)
3. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=0.86..20,078,299.97 rows=1,554,731 width=89) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using aafipersonas_idx on aafipersonas a (cost=0.43..6,355,121.91 rows=2,767,185 width=89) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Only Scan using aafipersonas_contrastacion_idx on aafipersonas_contrastacion c (cost=0.43..4.96 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ("PersonaId" = a."PersonaId")
6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.44..38,125,942.47 rows=21,461,203 width=47) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using idx_persona_nrodocumento on per_persona b (cost=0.44..38,072,289.46 rows=21,461,203 width=47) (actual rows= loops=)

  • Filter: (baja_logica IS FALSE)