explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pbIi

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

Merge Left Join (cost=20,492,801.85..22,029,799.96 rows=29,381,884 width=368) (actual rows= loops=)

  • Merge Cond: ((cpv.sexo = pgh.de_genero) AND (((cpv.dnac)::double precision) = pgh.dnac) AND (((cpv.mnac)::double precision) = pgh.mnac) AND (((cpv.anac)::double precision) = pgh.anac))
  • Join Filter: ((((cpv.dni)::text = (pgh.nu_doc_nacimiento)::text) OR (cpv.l_dni @> ARRAY[pgh.nu_doc_nacimiento])) AND (jaro_winkler(COALESCE(cpv.ap1, ''::text), COALESCE(pgh.ap_primer, ''::text)) > '0.9'::double precision) AND (jaro_winkler(COALESCE(cpv.ap2, ''::text), COALESCE(pgh.ap_segundo, ''::text)) > '0.9'::double precision))
2. 0.000 0.000 ↓ 0.0

Sort (cost=7,415,351.46..7,488,806.17 rows=29,381,884 width=184) (actual rows= loops=)

  • Sort Key: cpv.sexo, ((cpv.dnac)::double precision), ((cpv.mnac)::double precision), ((cpv.anac)::double precision)
3. 0.000 0.000 ↓ 0.0

Seq Scan on cpv17_pob_2 cpv (cost=0.00..1,159,672.84 rows=29,381,884 width=184) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=13,077,450.39..13,202,641.20 rows=25,038,162 width=148) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=13,077,450.39..13,140,045.80 rows=25,038,162 width=148) (actual rows= loops=)

  • Sort Key: pgh.de_genero, pgh.dnac, pgh.mnac, pgh.anac
6. 0.000 0.000 ↓ 0.0

Subquery Scan on pgh (cost=7,742,230.14..8,117,802.57 rows=25,038,162 width=148) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Unique (cost=7,742,230.14..7,867,420.95 rows=25,038,162 width=148) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Sort (cost=7,742,230.14..7,804,825.55 rows=25,038,162 width=148) (actual rows= loops=)

  • Sort Key: pgh_20200427.nu_doc_nacimiento
9. 0.000 0.000 ↓ 0.0

Seq Scan on pgh_20200427 (cost=0.00..2,782,582.32 rows=25,038,162 width=148) (actual rows= loops=)

  • Filter: ((in_doc_nacimiento)::text = '00030299'::text)