explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g8nM

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

Subquery Scan mo_parcelascatastro_frentes (cost=87,716.69..87,736.47 rows=344 width=516) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=87,716.69..87,733.03 rows=344 width=638) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=87,716.69..87,717.55 rows=344 width=638) (actual rows= loops=)

  • Sort Key: "*SELECT* 1".gid, "*SELECT* 1".seccion, "*SELECT* 1".manzana, "*SELECT* 1".parcela, "*SELECT* 1".obs, "*SELECT* 1".s_m_p, "*SELECT* 1".weblink, (''::text), "*SELECT* 1".rot_sec, "*SELECT* 1".partida, "*SELECT* 1".the_geom, "*SELECT* 1".frente, "*SELECT* 1".num_dom, "*SELECT* 1".barrios, "*SELECT* 1".comuna, "*SELECT* 1".sup_edif, "*SELECT* 1".unidades, (NULL::bigint)
4. 0.000 0.000 ↓ 0.0

Append (cost=44,405.42..87,702.19 rows=344 width=638) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=44,405.42..44,425.14 rows=343 width=640) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Unique (cost=44,405.42..44,421.71 rows=343 width=640) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Sort (cost=44,405.42..44,406.28 rows=343 width=640) (actual rows= loops=)

  • Sort Key: public.mo_parcelasmap.gid, (split_part((public.mo_parcelasmap.smp)::text, '-'::text, 1)), (split_part((public.mo_parcelasmap.smp)::text, '-'::text, 2)), (split_part((public.mo_parcelasmap.smp)::text, '-'::text, 3)), public.mo_parcelasmap.obs, public.mo_parcelasmap.smp, (CASE WHEN (length(ltrim(split_part((public.mo_parcelasmap.smp)::text, '-'::text, 1), '0'::text)) = 1) THEN ('0'::text || ltrim(split_part((public.mo_parcelasmap.smp)::text, '-'::text, 1), '0'::text)) ELSE ltrim(split_part((public.mo_parcelasmap.smp)::text, '-'::text, 1), '0'::text) END), public.mo_parcelasmap.partida, public.mo_parcelasmap.the_geom, ((CASE WHEN (public.mo_orasync.numeros <> ''::text) THEN public.mo_orasync.numeros ELSE 'N'::text END)::character varying(254)), public.mo_parcelasmap.barrios, public.mo_parcelasmap.comuna, public.mo_parcelasmap.sup_edif, public.mo_parcelasmap.unidades
8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..44,390.98 rows=343 width=640) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..42,933.77 rows=258 width=640) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..41,507.73 rows=258 width=627) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on mo_orasync (cost=0.00..39,462.77 rows=258 width=26) (actual rows= loops=)

  • Filter: ((((calle)::character varying(254))::text = 'ESMERALDA'::text) AND (((CASE WHEN (numeros <> ''::text) THEN numeros ELSE 'N'::text END)::character varying(254))::text ~~ '%340%'::text))
12. 0.000 0.000 ↓ 0.0

Index Scan using mo_parcelasmap_idx_smp on mo_parcelasmap (cost=0.00..7.91 rows=1 width=613) (actual rows= loops=)

  • Index Cond: ((public.mo_parcelasmap.smp)::text = (public.mo_orasync.smp)::text)
13. 0.000 0.000 ↓ 0.0

Index Scan using mo_parcelasmap_idx_smp on mo_parcelasmap (cost=0.00..5.51 rows=1 width=25) (actual rows= loops=)

  • Index Cond: ((public.mo_parcelasmap.smp)::text = (public.mo_parcelasmap.smp)::text)
14. 0.000 0.000 ↓ 0.0

Index Scan using frentesparcelas_smp on frentesparcelas f (cost=0.00..5.57 rows=2 width=12) (actual rows= loops=)

  • Index Cond: ((public.mo_parcelasmap.smp)::text = (f.smp)::text)
15. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=0.00..43,277.05 rows=1 width=32) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=0.00..43,277.04 rows=1 width=32) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on mo_orasync (cost=0.00..42,685.30 rows=72 width=32) (actual rows= loops=)

  • Filter: ((numeros <> ''::text) AND (((calle)::character varying(254))::text = 'ESMERALDA'::text) AND (((CASE WHEN (numeros <> ''::text) THEN numeros ELSE 'N'::text END)::character varying(254))::text ~~ '%340%'::text))
18. 0.000 0.000 ↓ 0.0

Index Scan using mo_parcelasmap_idx_smp on mo_parcelasmap (cost=0.00..8.21 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((public.mo_parcelasmap.smp)::text = (public.mo_orasync.smp)::text)